The DFMCAINVPOS table in SAP ERP or S/4HANA stores Invoice in IS-PS-CA: Items data. There are total 8 fields in DFMCAINVPOS table. The Invoice in IS-PS-CA: Items table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFMCAINVPOS table. It is in PSCD: Basics & Documents (FMCAD) ABAP package and is part of the Public Sector Contract Accounts Receivable and Payable (IS-PS-CA) module.
SAP DFMCAINVPOS Table Fields
Following is the list of fields that are available in SAP DFMCAINVPOS table. The primary key fields of the table are MANDT (Client), INVNR (Invoice Number), OPBEL (Number of a FI-CA Document), OPUPW (Repetition Item in FI-CA Document), OPUPK (Item Number in FI-CA Document), OPUPZ (Subitem for a Partial Clearing in Document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| INVNR | Invoice Number | INVNR_PS | DFMCAINV | CHAR (12) |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | * | CHAR (12) |
| OPUPW | Repetition Item in FI-CA Document | OPUPW_KK | NUMC (3) | |
| OPUPK | Item Number in FI-CA Document | OPUPK_KK | NUMC (4) | |
| OPUPZ | Subitem for a Partial Clearing in Document | OPUPZ_KK | NUMC (3) | |
| WAERS | Transaction Currency | BLWAE_KK | * | CUKY (5) |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) |
