The DFMCAINV table in SAP ERP or S/4HANA stores Invoice in IS-PS-CA: Header Data data. There are total 16 fields in DFMCAINV table. The Invoice in IS-PS-CA: Header Data 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 DFMCAINV 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 DFMCAINV Table Fields
Following is the list of fields that are available in SAP DFMCAINV table. The primary key fields of the table are MANDT (Client), INVNR (Invoice Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| INVNR | Invoice Number | INVNR_PS | CHAR (12) | |
| INVTP | Invoice Type | INVTP_PS | CHAR (2) | |
| GPART | Business Partner Number | GPART_KK | * | CHAR (10) |
| VKONT | Contract Account Number | VKONT_KK | * | CHAR (12) |
| OPBUK | Company Code Group | OPBUK_KK | * | CHAR (4) |
| STDBK | Standard Company Code | STDBK_KK | * | CHAR (4) |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR (20) | |
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR (1) | |
| LAUFD | Date ID | LAUFD_KK | DATS (8) | |
| LAUFI | Run ID | LAUFI_KK | CHAR (6) | |
| SLART | Selection Category | SELTT_KK | * | CHAR (1) |
| WAERS | Currency Key | WAERS_KK | * | CUKY (5) |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| RFZAS | External key payment form | RFZAS_KK | CHAR (30) | |
| XSIMU | Mass act: Simulation run | FKK_XSIMU_KK | CHAR (1) |
