SAP ABAP Table MSR20_ORDER_HEADER (MSR: Sales Order Header)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ MBA_MSR20 (Package) Mobile Sales for Handheld (R/3) 2.0

Basic Data

Table Category	INTTAB	Structure
Structure	MSR20_ORDER_HEADER	Table Relationship Diagram
Short Description	MSR: Sales Order Header

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	SALESDOCUMENT	☐			CHAR	10	0
2	REFOBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	TOJTB
3	REFOBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
4	REFDOCTYPE	☐	REFDOCTYPE	CHAR10	CHAR	10	0	Document type of reference object
5	DOC_TYPE	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
6	COLLECT_NO	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
7	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
9	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TVTA
10	SALES_GRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
11	SALES_OFF	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
12	REQ_DATE_H	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
13	DATE_TYPE	☐	PRGRS_VBAK	PRGRS	CHAR	1	0	Proposed Period for Date
14	PURCH_DATE	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
15	PO_METHOD	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
16	PO_SUPPLEM	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
17	REF_1	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
18	NAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
19	TELEPHONE	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
20	PRICE_GRP	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
21	CUST_GROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
22	SALES_DIST	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
23	PRICE_LIST	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
24	INCOTERMS1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
25	INCOTERMS2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
26	PMNTTRMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
27	DLV_BLOCK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
28	BILL_BLOCK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
29	ORD_REASON	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
30	COMPL_DLV	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
31	PRICE_DATE	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
32	QT_VALID_F	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
33	QT_VALID_T	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
34	CT_VALID_F	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
35	CT_VALID_T	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
36	CUST_GRP1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
37	CUST_GRP2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
38	CUST_GRP3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
39	CUST_GRP4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
40	CUST_GRP5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
41	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
42	PURCH_NO_S	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
43	PO_DAT_S	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
44	PO_METH_S	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	T176
45	REF_1_S	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
46	SD_DOC_CAT	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
47	DOC_DATE	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
48	WAR_DATE	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
49	SHIP_COND	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
50	PP_SEARCH	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
51	DUN_COUNT	☐	MAHZA	PACK2	DEC	3	0	Number of reminder notices, reminders for delivery purchase
52	DUN_DATE	☐	MAHDT	DATUM	DATS	8	0	Last Delivery Reminder Notice
53	DLVSCHDUSE	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
54	PLDLVSTYP	☐	ABDIS	ABRAB	CHAR	1	0	MRP for Release Types
55	REF_DOC	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
56	COMP_CDE_B	☐	BUKRS_VF	BUKRS	CHAR	4	0	Company code to be billed	T001
57	ALTTAX_CLS	☐	TAXK1_AK	TAXKD	CHAR	1	0	Alternative tax classification	TSKD
58	TAX_CLASS2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	TSKD
59	TAX_CLASS3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	TSKD
60	TAX_CLASS4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	TSKD
61	TAX_CLASS5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	TSKD
62	TAX_CLASS6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	TSKD
63	TAX_CLASS7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	TSKD
64	TAX_CLASS8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	TSKD
65	TAX_CLASS9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	TSKD
66	REF_DOC_L	☐	XBLNR_V	XBLNR	CHAR	16	0	Reference Document Number
67	ASS_NUMBER	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
68	REFDOC_CAT	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
69	ORDCOMB_IN	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
70	BILL_SCHED	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
71	INVO_SCHED	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
72	MN_INVOICE	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
73	EXRATE_FI	☐	KURRF_P	KURSP	DEC	9	5	Directly quoted exchange rate for FI postings
74	ADD_VAL_DY	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
75	FIX_VAL_DY	☐	VALDT	DATUM	DATS	8	0	Fixed value date
76	PYMT_METH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
77	ACCNT_ASGN	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
78	EXCHG_RATE	☐	KURSK_P	PKURS	DEC	9	5	Directly Quoted Exchange Rate for Pricing and Statistics
79	BILL_DATE	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
80	SERV_DATE	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
81	DUNN_KEY	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
82	DUNN_BLOCK	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
83	PMTGAR_PRO	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure
84	DEPARTM_NO	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
85	REC_POINT	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
86	DOC_NUM_FI	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	*
87	CSTCNDGRP1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
88	CSTCNDGRP2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
89	CSTCNDGRP3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
90	CSTCNDGRP4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
91	CSTCNDGRP5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
92	DLV_TIME	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time	TVDC
93	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
94	CURR_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
95	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
96	TAXDEP_CTY	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	T005
97	TAXDST_CTY	☐	LAND1TX	LAND1	CHAR	3	0	Tax Destination Country	T005
98	EUTRI_DEAL	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
99	MAST_CONTR	☐	VBELN_GRP	VBELN	CHAR	10	0	Group Master Contract	VBUK
100	REF_PROC	☐	SCHEME_GRP	SCHEME_GRP	CHAR	4	0	Referencing requirement: Procedure	TVGRPS
101	CHKPRTAUTH	☐	ABRUF_PART	ABRUF_PART	CHAR	1	0	Check partner authorizations
102	CMLQTY_DAT	☐	DAT_FZAU	DATUM	DATS	8	0	Cml delivery order qty date
103	VERSION	☐	VSNMR_V	VSNMR	CHAR	12	0	Sales document version number
104	NOTIF_NO	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
105	WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
106	EXCH_RATE_FI_V	☐	KURRF_V	KURSP	DEC	9	5	Indirectly quoted exchange rate for FI postings
107	EXCHG_RATE_V	☐	KURSK_V	PKURS	DEC	9	5	Indirectly Quoted Exchange Rate for Pricing and Statistics
108	FKK_CONACCT	☐	CHAR012	CHAR12	CHAR	12	0	Character field of length 12
109	DOC_CLASS	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
110	H_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
111	H_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
112	SHIP_TYPE	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
113	S_PROC_IND	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
114	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
115	PARTNER_SOLD	☐	KUNN2	KUNNR	CHAR	10	0	Customer number of business partner	*
116	PARTNER_BILL	☐	KUNN2	KUNNR	CHAR	10	0	Customer number of business partner	*
117	PARTNER_PAY	☐	KUNN2	KUNNR	CHAR	10	0	Customer number of business partner	*
118	PARTNER_SHIP	☐	KUNN2	KUNNR	CHAR	10	0	Customer number of business partner	*
119	PARTNER_EMPLOYEE	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
120	PAR_EMP_USERNAME	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
121	TEXT	☐	TEXT1000	TEXT1000	CHAR	1000	0	Text of length 1000
122	UNIT_SPLIT	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
123	STATUS_DOCUMENT	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
124	STATUS_DELIVERY	☐	LKGSK	STATV	CHAR	1	0	Overall delivery status for all items
125	STATUS_BILLING	☐	FKSAK	STATV	CHAR	1	0	Billing status (order-related billing document)
126	STATUS_DOC_TEXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
127	STATUS_DEL_TEXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
128	STATUS_BIL_TEXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
129	NET_VALUE	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
130	TAX_RATE	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
131	INV_TOTAL	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MSR20_ORDER_HEADER	ACCNT_ASGN	TVKT	KTGRD
2	MSR20_ORDER_HEADER	ALTTAX_CLS	TSKD	TAXKD
3	MSR20_ORDER_HEADER	BILL_BLOCK	TVFS	FAKSP
4	MSR20_ORDER_HEADER	BILL_SCHED	TFACD	IDENT
5	MSR20_ORDER_HEADER	COMP_CDE_B	T001	BUKRS
6	MSR20_ORDER_HEADER	CSTCNDGRP1	TVKGG	KDKGR
7	MSR20_ORDER_HEADER	CSTCNDGRP2	TVKGG	KDKGR
8	MSR20_ORDER_HEADER	CSTCNDGRP3	TVKGG	KDKGR
9	MSR20_ORDER_HEADER	CSTCNDGRP4	TVKGG	KDKGR
10	MSR20_ORDER_HEADER	CSTCNDGRP5	TVKGG	KDKGR
11	MSR20_ORDER_HEADER	CURRENCY	TCURC	WAERS
12	MSR20_ORDER_HEADER	CUST_GROUP	T151	KDGRP
13	MSR20_ORDER_HEADER	CUST_GRP1	TVV1	KVGR1
14	MSR20_ORDER_HEADER	CUST_GRP2	TVV2	KVGR2
15	MSR20_ORDER_HEADER	CUST_GRP3	TVV3	KVGR3
16	MSR20_ORDER_HEADER	CUST_GRP4	TVV4	KVGR4
17	MSR20_ORDER_HEADER	CUST_GRP5	TVV5	KVGR5
18	MSR20_ORDER_HEADER	DEPARTM_NO	TSAB	ABTNR
19	MSR20_ORDER_HEADER	DISTR_CHAN	TVKOV	VTWEG
20	MSR20_ORDER_HEADER	DIVISION	TVTA	SPART
21	MSR20_ORDER_HEADER	DLVSCHDUSE	TVLV	ABRVW
22	MSR20_ORDER_HEADER	DLV_BLOCK	TVLS	LIFSP
23	MSR20_ORDER_HEADER	DLV_TIME	TVDC	DELCO
24	MSR20_ORDER_HEADER	DOC_TYPE	TVAK	AUART
25	MSR20_ORDER_HEADER	DUNN_BLOCK	T040S	MANSP
26	MSR20_ORDER_HEADER	DUNN_KEY	T040	MSCHL
27	MSR20_ORDER_HEADER	H_CURR	TCURC	WAERS
28	MSR20_ORDER_HEADER	INCOTERMS1	TINC	INCO1
29	MSR20_ORDER_HEADER	INVO_SCHED	TFACD	IDENT
30	MSR20_ORDER_HEADER	MAST_CONTR	VBUK	VBELN
31	MSR20_ORDER_HEADER	ORD_REASON	TVAU	AUGRU
32	MSR20_ORDER_HEADER	PO_METHOD	T176	BSARK
33	MSR20_ORDER_HEADER	PO_METH_S	T176	BSARK
34	MSR20_ORDER_HEADER	PRICE_GRP	T188	KONDA
35	MSR20_ORDER_HEADER	PRICE_LIST	T189	PLTYP
36	MSR20_ORDER_HEADER	PYMT_METH	T042Z	ZLSCH
37	MSR20_ORDER_HEADER	REFOBJTYPE	TOJTB	NAME
38	MSR20_ORDER_HEADER	REF_DOC	VBUK	VBELN
39	MSR20_ORDER_HEADER	REF_PROC	TVGRPS	SCHEME
40	MSR20_ORDER_HEADER	SALES_DIST	T171	BZIRK
41	MSR20_ORDER_HEADER	SALES_GRP	TVBVK	VKGRP
42	MSR20_ORDER_HEADER	SALES_OFF	TVKBZ	VKBUR
43	MSR20_ORDER_HEADER	SALES_ORG	TVKO	VKORG
44	MSR20_ORDER_HEADER	SHIP_COND	TVSB	VSBED
45	MSR20_ORDER_HEADER	SHIP_TYPE	T173	VSART
46	MSR20_ORDER_HEADER	S_PROC_IND	TVSAK	SDABW
47	MSR20_ORDER_HEADER	TAXDEP_CTY	T005	LAND1
48	MSR20_ORDER_HEADER	TAXDST_CTY	T005	LAND1
49	MSR20_ORDER_HEADER	TAX_CLASS2	TSKD	TAXKD
50	MSR20_ORDER_HEADER	TAX_CLASS3	TSKD	TAXKD
51	MSR20_ORDER_HEADER	TAX_CLASS4	TSKD	TAXKD
52	MSR20_ORDER_HEADER	TAX_CLASS5	TSKD	TAXKD
53	MSR20_ORDER_HEADER	TAX_CLASS6	TSKD	TAXKD
54	MSR20_ORDER_HEADER	TAX_CLASS7	TSKD	TAXKD
55	MSR20_ORDER_HEADER	TAX_CLASS8	TSKD	TAXKD
56	MSR20_ORDER_HEADER	TAX_CLASS9	TSKD	TAXKD

History

Last changed by/on	SAP	20130529
SAP Release Created in	2004_1_46C