SAP ABAP Table /SAPNEA/MR3_ORDER_HEADER ([Mobile DB] Sales order header)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ /SAPNEA/MR3/HANDHELD_SALES (Package) Mobile Sales for Handhelds

Basic Data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in