SAP VSBHDR IDoc Self-Billing Procedure w. Automatic Postings Table
Overview
VSBHDR is a standard SAP S/4HANA table that stores IDoc Self-Billing Procedure w. Automatic Postings data. There are total 47 fields in the VSBHDR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSBHDR 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 VSBHDR to other SAP tables and standard CDS views available based on VSBHDR table in S/4HANA 2020.
Techincal Settings of VSBHDR
Below are technical details of the table VSBHDR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSBHDR Fields
The following table gives you an overview of the fields available in VSBHDR
| 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 | NUMC | 16 | |
| DOCSPLIT | Splitting Counter if IDoc Contains Several Deliveries | DOCSPLIT | NUMC | 4 | |
| 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 | |
| KUNAG_T | Transferred Sold-To Party Number | KUNAG_T | CHAR | 17 | |
| LIFNR_T | Supplier Number at Customer Location | LIFNR_ED1 | CHAR | 17 | |
| KNREF_T | Transferred Customer Plant | KNREF_T | CHAR | 17 | |
| ABLAD_T | Customer's Transferred Unloading Point | ABLAD_T | CHAR | 17 | |
| PRCTYPH_T | Transferred Transaction Code | PRCTYPH_T | CHAR | 3 | |
| DELNOQ_T | Transferred Category for Delivery Determination | DELNOQ_T | CHAR | 3 | |
| DELNO_T | Transferred Number for Delivery Determination | DELNO_T | CHAR | 35 | |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| VBTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| KUNAG | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| KUNRG | Payer | KUNRG | KNA1 | CHAR | 10 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| MREFSRC | Type/Origin of Main Reference | MREFSRC | CHAR | 1 | |
| COMNUM | Combination Number | COMNUM | NUMC | 6 | |
| KUNAG_CUST | Sold-To Party for Customizing Data | KUNAG_CUST | KNA1 | CHAR | 10 |
| DELCOM | Group Deliveries | DELCOM | CHAR | 1 | |
| PARPAY | Subsets Can Be Displayed | PARPAY | CHAR | 1 | |
| SBTGRP | Tolerance group | SBTGRP | CHAR | 4 | |
| KSCHL | Condition type | KSCHL | * | CHAR | 4 |
| DDELNO | Delivery Note Number to Determine Sales Document | DDELNO | CHAR | 1 | |
| DXONO | External Order Number to Determine Sales Document | DXONO | CHAR | 1 | |
| DXDELNO | External Delivery Note Number to Determine Sales Document | DXDELNO | CHAR | 1 | |
| DBDJIT | Billing Doc. for Delivery Confirmation to Determ. Sales Doc. | DBDJIT | CHAR | 1 | |
| DXRELNO | Ext. Release No. (sumJC) for Determination | DXRELNO | CHAR | 1 | |
| MREFNO | Main Reference | MREFNO1 | CHAR | 16 | |
| CURCY | SD document currency | WAERK | TCURC | CUKY | 5 |
| CURCY_T | Transferred Currency Converted | CURCY_T | TCURC | CUKY | 5 |
| CURISO_T | Transferred Currency (ISO Code) | CURISO_T | CHAR | 3 | |
| CURCYRL_T | Converted Transferred Original Currency | CURCYRL_T | TCURC | CUKY | 5 |
| 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 | |
| DEACT | Deactivation Indicator | DEACT | 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 VSBHDR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSBHDR | BUKRS | 1: CN | T001 |
| VSBHDR | CURCY | 1: CN | TCURC |
| VSBHDR | CURCYRL_T | 1: CN | TCURC |
| VSBHDR | CURCY_T | 1: CN | TCURC |
| VSBHDR | GSBER | 1: CN | TGSB |
| VSBHDR | KUNAG | 1: CN | KNA1 |
| VSBHDR | KUNAG_CUST | : | KNA1 |
| VSBHDR | KUNRG | 1: CN | KNA1 |
| VSBHDR | MANDT | 1: CN | T000 |
| VSBHDR | TRMNO_INT | 1: CN | TRNSM |
| VSBHDR | VKORG | 1: CN | TVKO |