SAP ABAP Table /SAPTRX/SD_SLS_HDR (Sales order header with update flag)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SCM-EM-AS (Application Component) Application System
     ⤷ /SAPTRX/AI_CONNECT (Package) SCEM-AI connect to application

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPTRX/SD_SLS_HDR	Table Relationship Diagram
Short Description	Sales order header with update flag

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Sales Document: Header Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
4	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
5	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
6	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
7	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
8	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
9	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
10	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
11	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
12	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
13	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
14	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
15	SUBMI	☐	SUBMI_SD	CHAR10	CHAR	10	0	Collective number (SD)
16	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
17	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
18	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
19	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
20	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
21	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
22	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
23	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
24	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
27	GUEBG	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
28	GUEEN	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
29	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
30	VDATU	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
31	VPRGR	☐	PRGRS_VBAK	PRGRS	CHAR	1	0	Proposed Period for Date
32	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
33	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
34	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
35	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
36	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
37	FKARA	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	TVFK
38	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
39	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
40	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
41	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
42	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
43	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
44	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
45	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
46	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
47	MAHZA	☐	MAHZA	PACK2	DEC	3	0	Number of reminder notices, reminders for delivery purchase
48	MAHDT	☐	MAHDT	DATUM	DATS	8	0	Last Delivery Reminder Notice
49	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
50	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
51	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
52	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
53	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
54	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
55	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
56	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
57	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
58	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
59	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
60	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
61	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
62	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
63	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
64	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
65	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	*
66	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
67	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
68	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
69	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
70	CMNUP	☐	CMNUP	DATUM	DATS	8	0	Date of next credit check of document
71	CMNGV	☐	CMNGV	DATUM	DATS	8	0	Next date
72	AMTBL	☐	AMTBL_CM	WERTV8	CURR	15	2	Released credit value of the document
73	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing	THIT
74	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
75	ABDIS	☐	ABDIS	ABRAB	CHAR	1	0	MRP for Release Types
76	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
77	OBJNR	☐	OBJKO	J_OBJNR	CHAR	22	0	Object number at header level	ONR00
78	BUKRS_VF	☐	BUKRS_VF	BUKRS	CHAR	4	0	Company code to be billed	T001
79	TAXK1	☐	TAXK1_AK	TAXKD	CHAR	1	0	Alternative tax classification	*
80	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
81	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
82	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
83	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
84	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
85	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
86	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
87	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
88	XBLNR	☐	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
89	ZUONR	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
90	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
91	KALSM_CH	☐	KALSMA_CH	KALSM	CHAR	6	0	Search procedure for batch determination	T683
92	AGRZR	☐	AGRZR	NUM2	NUMC	2	0	Accrual period for order-related billing docs.to be accrued
93	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
94	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
95	VBELN_GRP	☐	VBELN_GRP	VBELN	CHAR	10	0	Group Master Contract	*
96	SCHEME_GRP	☐	SCHEME_GRP	SCHEME_GRP	CHAR	4	0	Referencing requirement: Procedure	TVGRPS
97	ABRUF_PART	☐	ABRUF_PART	ABRUF_PART	CHAR	1	0	Check partner authorizations
98	ABHOD	☐	ABHOD	DATUM	DATS	8	0	Pick up date
99	ABHOV	☐	ABHOZ	UZEIT	TIMS	6	0	Pick up time
100	ABHOB	☐	ABHOZ	UZEIT	TIMS	6	0	Pick up time
101	RPLNR	☐	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number	FPLA
102	VZEIT	☐	EZEIT_VBAK	TIME_SAORG	TIMS	6	0	Proposed schedule line time (local with ref. to sales org.)
103	STCEG_L	☐	LAND1TX	LAND1	CHAR	3	0	Tax Destination Country	T005
104	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	T005
105	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
106	ENQUEUE_GRP	☐	ENQUEUE_GRP	ENQUEUE_GRP	CHAR	1	0	Block master contr. until all lower level contracts updated
107	DAT_FZAU	☐	DAT_FZAU	DATUM	DATS	8	0	Cml delivery order qty date
108	FMBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
109	VSNMR_V	☐	VSNMR_V	VSNMR	CHAR	12	0	Sales document version number
110	HANDLE	☐	TSEGGUID_VBAK	SYSUUID_22	CHAR	22	0	International unique key for VBAK-VBELN
111	PROLI	☐	ADGE_PROLI	ADGD_PROLI	CHAR	3	0	Dangerous Goods Management Profile in SD Documents	TDGC5
112	CONT_DG	☐	ADGE_NCDG	X	CHAR	1	0	Indicator: Document contains dangerous goods
113	CRM_GUID	☐	CHAR70	CHAR70	CHAR	70	0	Character field, length 70
114	UPD_TMSTMP	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
115	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
116	TM_CTRL_KEY	☐	TM_CTRL_KEY		CHAR	4	0	Control Key for Document Transfer to TM
117	.INCLUDE	☐				0	0	Structure: Handover of Goods at Agreed Location
118	HANDOVERLOC	☐	HANDOVER_LOC	HANDOVER_LOC	CHAR	10	0	Location for a physical handover of goods
119	.INCLU--AP	☐				0	0	Append structure for Posting Date in PSM
120	PSM_BUDAT	☐	PSM_BUDAT	DATUM	DATS	8	0	Posting Date in the Document
121	.INCLU--AP	☐				0	0	RE-SCM append to VBAK
122	SWENR	☐	HB_SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
123	SMENR	☐	HB_SMENR	SMENR	CHAR	8	0	Number of Sales Unit	VIMI01
124	PHASE	☐	HB_SPHSE	HBS_PHASE	CHAR	11	0	Sales Phase	HBSSPH
125	MTLAUR	☐	HB_MTLAUR	HBS_MTLAUR	CHAR	1	0	Marker for Low Income Housing	CHBSNCM
126	STAGE	☐	HB_STAGE	INT4	INT4	10	0	Construction Stage
127	HB_CONT_REASON	☐	HB_CONT	CHAR2	CHAR	2	0	Contingency data	HBSCREASON
128	HB_EXPDATE	☐	HB_EXP	DATS	DATS	8	0	Expiration date
129	HB_RESDATE	☐	HB_RES	DATS	DATS	8	0	Resolution date
130	.INCLU--AP	☐				0	0	VBAK Fields for CRM Documents
131	LOGSYSB	☐	LOGSYSB	LOGSYS	CHAR	10	0	Logical system with which document was created	*
132	.INCLU--AP	☐				0	0	TPM Campaign Determination: Append to VBAK
133	KALCD	☐	KALCD	KALSM	CHAR	6	0	Procedure for Campaign Determination	*
134	MULTI	☐	CMPC_MULT_CAMPAIGN	CMPGN_MULT_CAMPAIGN	CHAR	1	0	Multiple Campaigns/Trade Promotions Active Indicator
135	.INCLU--AP	☐				0	0	Append Structure for Special Paymenents
136	SPPAYM	☐	SPPAYM	SPPAYM	CHAR	2	0	Payment Form for Special Payment Method
137	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPTRX/SD_SLS_HDR	ABRVW	TVLV	ABRVW	REF	C	CN
2	/SAPTRX/SD_SLS_HDR	AUART	TVAK	AUART	REF	1	CN
3	/SAPTRX/SD_SLS_HDR	AUFNR	AUFK	AUFNR	REF	C	CN
4	/SAPTRX/SD_SLS_HDR	AUGRU	TVAU	AUGRU	REF	C	CN
5	/SAPTRX/SD_SLS_HDR	BSARK	T176	BSARK	REF	C	CN
6	/SAPTRX/SD_SLS_HDR	BUKRS_VF	T001	BUKRS	REF	C	CN
7	/SAPTRX/SD_SLS_HDR	CMWAE	TCURC	WAERS	REF	C	CN
8	/SAPTRX/SD_SLS_HDR	CTLPC	T691A	CTLPC	REF	C	CN
9	/SAPTRX/SD_SLS_HDR	FAKSK	TVFS	FAKSP	REF	C	CN
10	/SAPTRX/SD_SLS_HDR	FKARA	TVFK	FKART	REF	C	CN
11	/SAPTRX/SD_SLS_HDR	GSBER	TGSB	GSBER	REF	C	CN
12	/SAPTRX/SD_SLS_HDR	GSKST	TGSB	GSBER	REF	C	CN
13	/SAPTRX/SD_SLS_HDR	HB_CONT_REASON	HBSCREASON	HB_CONT	KEY
14	/SAPTRX/SD_SLS_HDR	HITYP_PR	THIT	HITYP	REF	C	CN
15	/SAPTRX/SD_SLS_HDR	KALSM	T683	KALSM	REF	C	CN
16	/SAPTRX/SD_SLS_HDR	KALSM_CH	T683	KALSM	REF	C	CN
17	/SAPTRX/SD_SLS_HDR	KKBER	T014	KKBER	REF	C	CN
18	/SAPTRX/SD_SLS_HDR	KNKLI	KNA1	KUNNR	REF	C	CN
19	/SAPTRX/SD_SLS_HDR	KNUMA	KONA	KNUMA	KEY	1	CN
20	/SAPTRX/SD_SLS_HDR	KOKRS	TKA01	KOKRS	REF	C	CN
21	/SAPTRX/SD_SLS_HDR	KUNNR	KNA1	KUNNR	REF	C	CN
22	/SAPTRX/SD_SLS_HDR	KURST	TCURV	KURST	REF	C	CN
23	/SAPTRX/SD_SLS_HDR	KVGR1	TVV1	KVGR1	REF	C	CN
24	/SAPTRX/SD_SLS_HDR	KVGR2	TVV2	KVGR2	REF	C	CN
25	/SAPTRX/SD_SLS_HDR	KVGR3	TVV3	KVGR3	REF	C	CN
26	/SAPTRX/SD_SLS_HDR	KVGR4	TVV4	KVGR4	REF	C	CN
27	/SAPTRX/SD_SLS_HDR	KVGR5	TVV5	KVGR5	REF	C	CN
28	/SAPTRX/SD_SLS_HDR	LANDTX	T005	LAND1		C	CN
29	/SAPTRX/SD_SLS_HDR	LIFSK	TVLS	LIFSP	REF	C	CN
30	/SAPTRX/SD_SLS_HDR	MANDT	T000	MANDT	KEY	1	CN
31	/SAPTRX/SD_SLS_HDR	MTLAUR	CHBSNCM	INCOME
32	/SAPTRX/SD_SLS_HDR	OBJNR	ONR00	OBJNR	REF	C	CN
33	/SAPTRX/SD_SLS_HDR	PHASE	HBSSPH	PHASE
34	/SAPTRX/SD_SLS_HDR	PROLI	TDGC5	PROLI
35	/SAPTRX/SD_SLS_HDR	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
36	/SAPTRX/SD_SLS_HDR	QMNUM	QMEL	QMNUM	REF	C	CN
37	/SAPTRX/SD_SLS_HDR	RPLNR	FPLA	FPLNR	REF	C	1
38	/SAPTRX/SD_SLS_HDR	SBGRP	T024B	SBGRP	REF	C	CN
39	/SAPTRX/SD_SLS_HDR	SCHEME_GRP	TVGRPS	SCHEME		1	CN
40	/SAPTRX/SD_SLS_HDR	SMENR	VIMI01	SMENR
41	/SAPTRX/SD_SLS_HDR	SPART	TVTA	SPART	REF	1	CN
42	/SAPTRX/SD_SLS_HDR	STCEG_L	T005	LAND1		C	CN
43	/SAPTRX/SD_SLS_HDR	STWAE	TCURC	WAERS	REF	C	CN
44	/SAPTRX/SD_SLS_HDR	SWENR	VIOB01	SWENR
45	/SAPTRX/SD_SLS_HDR	VBELN	VBUK	VBELN	KEY	1	C
46	/SAPTRX/SD_SLS_HDR	VGBEL	VBUK	VBELN	REF	C	CN
47	/SAPTRX/SD_SLS_HDR	VKBUR	TVKBZ	VKBUR	REF	C	CN
48	/SAPTRX/SD_SLS_HDR	VKGRP	TVBVK	VKGRP	REF	C	CN
49	/SAPTRX/SD_SLS_HDR	VKORG	TVKO	VKORG	REF	1	CN
50	/SAPTRX/SD_SLS_HDR	VSBED	TVSB	VSBED	REF	C	CN
51	/SAPTRX/SD_SLS_HDR	VTWEG	TVKOV	VTWEG	REF	1	CN
52	/SAPTRX/SD_SLS_HDR	WAERK	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	2002_1_470