SAP VSBITM IDoc-Item Self-Billing Procedure w. Automatic Postings Table
Overview
VSBITM is a standard SAP S/4HANA table that stores IDoc-Item Self-Billing Procedure w. Automatic Postings data. There are total 34 fields in the VSBITM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSBITM belongs to Self-Billing Proced. (SD-BIL-IV-SBI) module and is located in the package Application Development R/3 Sales / Self-Billing Process (VASB).
In addition, following links provide an overview of foreign key relationships, if any, that link VSBITM to other SAP tables and standard CDS views available based on VSBITM table in S/4HANA 2020.
Techincal Settings of VSBITM
Below are technical details of the table VSBITM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSBITM Fields
The following table gives you an overview of the fields available in VSBITM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| TRMNO_INT | Transfer Number (Internal) | TRMNO_INT | TRNSM | NUMC | 12 |
| DOCNUM | IDoc number | EDI_DOCNUM | VSBHDR | NUMC | 16 |
| DOCSPLIT | Splitting Counter if IDoc Contains Several Deliveries | DOCSPLIT | VSBHDR | NUMC | 4 |
| ITMNUM | IDoc Item Number in the IDoc | ITMNUM | NUMC | 6 | |
| ORGDAT | Original Data From the Transfer | ORGDATA | CHAR | 1 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| AEZET | Time last change was made | AEZET | TIMS | 6 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| PRCTYPI_T | Transferred Posting Key | PRCTYPI_T | CHAR | 3 | |
| POSEX_T | Transferred Item Number | POSEX_T | CHAR | 6 | |
| KDMAT_T | Transferred Customer Material Number | KDMAT_T | CHAR | 35 | |
| MATNR_T | Transferred SAP Material Number | MATNR_T | * | CHAR | 40 |
| VRKME_T | Transferred Unit of Measure | VRKME_T | * | UNIT | 3 |
| VMEISO_T | Transferred ISO Unit of Measure | VMEISO_T | * | CHAR | 3 |
| FKIMG_T | Transferred Quantity in Displayed Unit of Measure | FKIMG_T | QUAN | 13 | |
| NETWR_T | Transferred Net Value | NETWR_T | CURR | 15 | |
| NETWRRL_T | Transferred Net Value | NETWR_T | CURR | 15 | |
| MWSKZ_T | Transferred Value-Added Tax Indicator | MWSKZ_T | * | CHAR | 2 |
| MWPRZ_T | Transferred Value-Added Tax Percentage | MWPRZ_T | DEC | 5 | |
| MWSBP_T | Transferred VAT Amount | MWSBP_T | CURR | 13 | |
| MWSBPRL_T | Transferred VAT Amount | MWSBP_T | CURR | 13 | |
| SKTPRZ_T | Transferred Disount Percentage | SKTPRZ_T | DEC | 5 | |
| SKTBT_T | Transferred Discount Amount | SKTBT_T | CURR | 13 | |
| SKTBTRL_T | Transferred Discount Amount | SKTBT_T | CURR | 13 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| FKIMGBU_T | Transferred Quantity in Base Unit of Measure | FKIMGBU_T | QUAN | 13 | |
| ERRCNT | No. of Messages in Verification Step (Header and Item Level) | ERRCNT | NUMC | 3 | |
| ORGREC | Original Data Record is Available for Current Record | ORGREC | CHAR | 1 | |
| CONEXIST | Records Exist for Conditions to Be Transferred | CONEXIST | CHAR | 1 | |
| REFEXIST | Records available for transferred reference numbers | REFEXIST | CHAR | 1 | |
| DATEXIST | Transferred Dates Exist for Records | DATEXIST | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSBITM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSBITM | DOCNUM | 1: CN | VSBHDR |
| VSBITM | DOCSPLIT | 1: CN | VSBHDR |
| VSBITM | MANDT | 1: CN | T000 |
| VSBITM | MATNR | 1: CN | MARA |
| VSBITM | TRMNO_INT | 1: CN | TRNSM |