SAP Table VSBHDR

IDoc Self-Billing Procedure w. Automatic Postings

VSBHDR (IDoc Self-Billing Procedure w. Automatic Postings) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VSBHDR to other SAP tables.

VSBHDR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TRMNO_INT Transfer Number (Internal) TRMNO_INT TRNSM NUMC 12 0
DOCNUM IDoc number EDI_DOCNUM NUMC 16 0
DOCSPLIT Splitting Counter if IDoc Contains Several Deliveries DOCSPLIT NUMC 4 0
ORGDAT Original Data From the Transfer ORGDATA CHAR 1 0
X Yes
NULL No
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
AEDAT Changed On AEDAT DATS 8 0
AEZET Time last change was made AEZET TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
KUNAG_T Transferred Sold-To Party Number KUNAG_T CHAR 17 0
LIFNR_T Vendor number at customer location LIFNR_ED1 CHAR 17 0
KNREF_T Transferred Customer Plant KNREF_T CHAR 17 0
ABLAD_T Customer's Transferred Unloading Point ABLAD_T CHAR 17 0
PRCTYPH_T Transferred Transaction Code PRCTYPH_T CHAR 3 0
005 Credit memo display /ERS method
006 Retroactive price change/clearing invoice
007 Non-Valuated Goods Receipt (No Processing, Display Only)
DELNOQ_T Transferred Category for Delivery Determination DELNOQ_T CHAR 3 0
009 Invoice Number
012 Delivery Note Number (Imply 061 - 063)
061 Internal delivery note number
062 Customer PO no. for consignment issue by ext. service agent
063 External delivery note number
081 Collective Daily Delivery Note
082 Summarized JIT call
DELNO_T Transferred Number for Delivery Determination DELNO_T CHAR 35 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
KUNRG Payer KUNRG KNA1 CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
MREFSRC Type/Origin of Main Reference MREFSRC CHAR 1 0
A Transfer Number (E1EDK02-BELNR, Qual.: 074)
B Credit Advice Number (E1EDK02-BELNR, Qual.: 073)
C Cheque Number (E1EDK02-BELNR, Qual.: 075)
D BMW: Vendor Posting Number (E1EDK02-BELNR, Qual.: 076)
E Document Number From IDoc Header (E1EDK01-BELNR)
COMNUM Combination Number COMNUM NUMC 6 0
KUNAG_CUST Sold-To Party for Customizing Data KUNAG_CUST KNA1 CHAR 10 0
DELCOM Group Deliveries DELCOM CHAR 1 0
X Group Same Deliveries in the Processing Step
NULL Do not Group Same Deliveries in the Processing Step
PARPAY Subsets Can Be Displayed PARPAY CHAR 1 0
X Credit Advice Displays Planned for Partial Quantities
NULL Credit Advice Displays Not Planned for Partial Quantities
SBTGRP Tolerance group SBTGRP CHAR 4 0
KSCHL Condition Type KSCHL CHAR 4 0
DDELNO Delivery Note Number to Determine Sales Document DDELNO CHAR 1 0
X Yes
NULL No
DXONO External Order Number to Determine Sales Document DXONO CHAR 1 0
X Yes
NULL No
DXDELNO External Delivery Note Number to Determine Sales Document DXDELNO CHAR 1 0
X Yes
NULL No
DBDJIT Billing Doc. for Delivery Confirmation to Determ. Sales Doc. DBDJIT CHAR 1 0
X Yes
NULL No
DXRELNO Ext. Release No. (sumJC) for Determination DXRELNO CHAR 1 0
X Yes
NULL No
MREFNO Main Reference MREFNO1 CHAR 16 0
CURCY SD Document Currency WAERK TCURC CUKY 5 0
CURCY_T Transferred Currency Converted CURCY_T TCURC CUKY 5 0
CURISO_T Transferred Currency (ISO Code) CURISO_T CHAR 3 0
CURCYRL_T Converted Transferred Original Currency CURCYRL_T TCURC CUKY 5 0
ERRCNT No. of Messages in Verification Step (Header and Item Level) ERRCNT NUMC 3 0
ORGREC Original Data Record is Available for Current Record ORGREC CHAR 1 0
X Yes
NULL No
DEACT Deactivation Indicator DEACT CHAR 1 0
NULL Active
A Manually Deactivated (in Verification Step)
B Automatically Deactivated (in Verification Step)
C Manually Deactivated (in Processing Step)
CONEXIST Records Exist for Conditions to Be Transferred CONEXIST CHAR 1 0
X Yes
NULL No
REFEXIST Records available for transferred reference numbers REFEXIST CHAR 1 0
X Yes
NULL No
DATEXIST Transferred Dates Exist for Records DATEXIST CHAR 1 0
X Yes
NULL No

VSBHDR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VSBHDR BUKRS VSBHDR BUKRS T001 Company Codes BUKRS
VSBHDR BUKRS VSBHDR MANDT T001 Company Codes MANDT
VSBHDR CURCY VSBHDR MANDT TCURC Currency Codes MANDT
VSBHDR CURCY VSBHDR CURCY TCURC Currency Codes WAERS
VSBHDR CURCYRL_T VSBHDR MANDT TCURC Currency Codes MANDT
VSBHDR CURCYRL_T VSBHDR CURCYRL_T TCURC Currency Codes WAERS
VSBHDR CURCY_T VSBHDR CURCY_T TCURC Currency Codes WAERS
VSBHDR CURCY_T VSBHDR MANDT TCURC Currency Codes MANDT
VSBHDR GSBER VSBHDR MANDT TGSB Business Areas MANDT
VSBHDR GSBER VSBHDR GSBER TGSB Business Areas GSBER
VSBHDR KUNAG VSBHDR MANDT KNA1 General Data in Customer Master MANDT
VSBHDR KUNAG VSBHDR KUNAG KNA1 General Data in Customer Master KUNNR
VSBHDR KUNAG_CUST VSBHDR KUNAG_CUST KNA1 General Data in Customer Master KUNNR
VSBHDR KUNAG_CUST VSBHDR MANDT KNA1 General Data in Customer Master MANDT
VSBHDR KUNRG VSBHDR MANDT KNA1 General Data in Customer Master MANDT
VSBHDR KUNRG VSBHDR KUNRG KNA1 General Data in Customer Master KUNNR
VSBHDR MANDT VSBHDR MANDT T000 Clients MANDT
VSBHDR TRMNO_INT VSBHDR MANDT TRNSM Data Transfer MANDT
VSBHDR TRMNO_INT VSBHDR TRMNO_INT TRNSM Data Transfer TRMNO_INT
VSBHDR VKORG VSBHDR MANDT TVKO Organizational Unit: Sales Organizations MANDT
VSBHDR VKORG VSBHDR VKORG TVKO Organizational Unit: Sales Organizations VKORG