SAP ABAP Table MASSSDHEAD (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure MASSSDHEAD   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
3 POSNR POSNR POSNR NUMC 6   0   Item number of the SD document VBUP
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 BSTZD BSTZD BSTZD CHAR 4   0   Customer purchase order number supplement  
42 BNAME BNAME_V NAME CHAR 35   0   Name of orderer  
43 TELF1 TELF1_VP TELF1 CHAR 16   0   Telephone Number  
44 MAHZA MAHZA PACK2 DEC 3   0   Number of reminder notices, reminders for delivery purchase  
45 MAHDT MAHDT DATUM DATS 8   0   Last Delivery Reminder Notice  
46 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
47 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center  
48 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update  
49 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
50 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
51 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
52 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
53 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
54 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
55 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
56 KNUMA KNUMA KNUMA CHAR 10   0   Agreement (various conditions grouped together) KONA
57 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
58 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
59 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
60 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
61 KNKLI KNKLI KUNNR CHAR 10   0   Customer's account number with credit limit reference KNA1
62 GRUPP GRUPP_CM GRUPP_CM CHAR 4   0   Customer credit group  
63 SBGRP SBGRP_CM SBGRP_CM CHAR 3   0   Credit Representative Group for Credit Management T024B
64 CTLPC CTLPC_CM CTLPC_CM CHAR 3   0   Credit management: Risk category T691A
65 CMWAE WAERS_CM WAERS CUKY 5   0   Currency key of credit control area TCURC
66 CMFRE CMFRE DATUM DATS 8   0   Release date of the document determined by credit management  
67 CMNUP CMNUP DATUM DATS 8   0   Date of next credit check of document  
68 CMNGV CMNGV DATUM DATS 8   0   Next date  
69 AMTBL AMTBL_CM WERTV8 CURR 15   2   Released credit value of the document  
70 HITYP_PR HITYP_PR HITYP CHAR 1   0   Hierarchy type for pricing THIT
71 ABRVW ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
72 ABDIS ABDIS ABRAB CHAR 1   0   MRP for Release Types  
73 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document VBUK
74 OBJNR OBJKO J_OBJNR CHAR 22   0   Object number at header level ONR00
75 BUKRS_VF BUKRS_VF BUKRS CHAR 4   0   Company code to be billed T001
76 TAXK1 TAXK1_AK TAXKD CHAR 1   0   Alternative tax classification  
77 TAXK2 TAXK2 TAXKD CHAR 1   0   Tax classification 2 for customer  
78 TAXK3 TAXK3 TAXKD CHAR 1   0   Tax classification 3 for customer  
79 TAXK4 TAXK4 TAXKD CHAR 1   0   Tax classification 4 for customer  
80 TAXK5 TAXK5 TAXKD CHAR 1   0   Tax classification 5 for customer  
81 TAXK6 TAXK6 TAXKD CHAR 1   0   Tax classification 6 for customer  
82 TAXK7 TAXK7 TAXKD CHAR 1   0   Tax classification 7 for customer  
83 TAXK8 TAXK8 TAXKD CHAR 1   0   Tax classification 8 for customer  
84 TAXK9 TAXK9 TAXKD CHAR 1   0   Tax classification 9 for customer  
85 XBLNR XBLNR_V1 XBLNR1 CHAR 16   0   Reference Document Number  
86 ZUONR ORDNR_V ZUONR CHAR 18   0   Assignment Number  
87 VGTYP VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
88 KALSM_CH KALSMA_CH KALSM CHAR 6   0   Search procedure for batch determination T683
89 AGRZR AGRZR NUM2 NUMC 2   0   Accrual period for order-related billing docs.to be accrued  
90 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
91 QMNUM QMNUM QMNUM CHAR 12   0   Message Number QMEL
92 VBELN_GRP VBELN_GRP VBELN CHAR 10   0   Group Master Contract  
93 SCHEME_GRP SCHEME_GRP SCHEME_GRP CHAR 4   0   Referencing requirement: Procedure TVGRPS
94 ABRUF_PART ABRUF_PART ABRUF_PART CHAR 1   0   Check partner authorizations  
95 ABHOD ABHOD DATUM DATS 8   0   Pick up date  
96 ABHOV ABHOZ UZEIT TIMS 6   0   Pick up time  
97 ABHOB ABHOZ UZEIT TIMS 6   0   Pick up time  
98 RPLNR RPLNR FPLNR CHAR 10   0   Installment Plan Number FPLA
99 VZEIT EZEIT_VBAK TIME_SAORG TIMS 6   0   Proposed schedule line time (local with ref. to sales org.)  
100 STCEG_L LAND1TX LAND1 CHAR 3   0   Tax Destination Country T005
101 LANDTX LANDTX LAND1 CHAR 3   0   Tax Departure Country T005
102 XEGDR XEGDR XFELD CHAR 1   0   Indicator: Triangular deal within the EU ?  
103 ENQUEUE_GRP ENQUEUE_GRP ENQUEUE_GRP CHAR 1   0   Block master contr. until all lower level contracts updated  
104 DAT_FZAU DAT_FZAU DATUM DATS 8   0   Cml delivery order qty date  
105 FMBDAT MBDAT DATUM DATS 8   0   Material Staging/Availability Date  
106 VSNMR_V VSNMR_V VSNMR CHAR 12   0   Sales document version number  
107 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
108 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
109 BZIRK BZIRK BZIRK CHAR 6   0   Sales district T171
110 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
111 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
112 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
113 KZAZU KZAZU_D XFELD CHAR 1   0   Order combination indicator  
114 PERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
115 PERRL PERRL WFCID CHAR 2   0   Invoice list schedule (calendar identification) TFACD
116 MRNKZ MRNKZ XFELD CHAR 1   0   Manual invoice maintenance  
117 KURRF KURRF KURRF DEC 9   5   Exchange rate for FI postings  
118 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
119 VALDT VALDT DATUM DATS 8   0   Fixed value date  
120 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
121 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
122 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
123 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
124 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
125 FKDAT FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
126 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
127 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
128 POPER POPER POPER NUMC 3   0   Posting period  
129 STCUR STCUR KURRF DEC 9   5   Exchange rate for statistics  
130 MSCHL MSCHL MSCHL CHAR 1   0   Dunning key T040
131 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
132 FPLNR FPLNR FPLNR CHAR 10   0   Billing plan number / invoicing plan number FPLA
133 WAKTION WAKTION WAKTION CHAR 10   0   Promotion WAKH
134 ABSSC ABSSCHE_CM ABSSCHE_CM CHAR 6   0   Payment Guarantee Procedure T691M
135 LCNUM LCNUM LCNUM CHAR 10   0   Financial doc. processing: Internal financial doc. number AKKP
136 J_1AFITP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type J_1AFITP
137 J_1ARFZ J_1ARFZVAT J_1ARFZVAT CHAR 1   0   Reason for zero VAT J_1ARFZ
138 J_1AREGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
139 J_1AGICD J_1AGICD_D J_1AGICD2 CHAR 2   0   Activity Code for Gross Income Tax J_1AGICD
140 J_1ADTYP J_1ADTYP_D J_1ADTYP CHAR 2   0   Distribution Type for Employment Tax J_1ADTYP
141 J_1ATXREL J_1ATXREL_ J_1ATXREL CHAR 10   0   Tax relevant classification J_1ATXREL
142 ABTNR ABTNR ABTNR CHAR 4   0   Department number TSAB
143 EMPST EMPST TEXT25 CHAR 25   0   Receiving point  
144 BSTKD BSTKD BSTKD CHAR 35   0   Customer purchase order number  
145 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
146 BSARK BSARK BSARK CHAR 4   0   Customer Order Type T176
147 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
148 BSTKD_E BSTKD_E BSTKD CHAR 35   0   Ship-to Party's Purchase Order Number  
149 BSTDK_E BSTDK_E DATUM DATS 8   0   Ship-to party's PO date  
150 BSARK_E BSARK_E BSARK CHAR 4   0   Ship-to party purchase order type T176
151 IHREZ_E IHREZ_E TEXT12 CHAR 12   0   Ship-to party character  
152 POSEX_E POSEX_E POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
153 KURSK_DAT WWERT_D DATUM DATS 8   0   Translation date  
154 KURRF_DAT WWERT_D DATUM DATS 8   0   Translation date  
155 KDKG1 KDKG1 KDKGR CHAR 2   0   Customer condition group 1 TVKGG
156 KDKG2 KDKG2 KDKGR CHAR 2   0   Customer condition group 2 TVKGG
157 KDKG3 KDKG3 KDKGR CHAR 2   0   Customer condition group 3 TVKGG
158 KDKG4 KDKG4 KDKGR CHAR 2   0   Customer condition group 4 TVKGG
159 KDKG5 KDKG5 KDKGR CHAR 2   0   Customer condition group 5 TVKGG
160 WKWAE WKWAE WAERS CUKY 5   0   Value contract currency TCURC
161 WKKUR WKKUR KURRF DEC 9   5   Exchange rate in value contract currency  
162 AKWAE AKWAE WAERS CUKY 5   0   Currency key for letter-of-credit procg in foreign trade TCURC
163 AKKUR AKKUR KURRF DEC 9   5   Exchange rate for letter-of-credit procg in foreign trade  
164 AKPRZ AKPRZ PRZ32 DEC 5   2   Depreciation percentage for financial document processing  
165 J_1AINDXP J_1AINDXP J_1AINDXP CHAR 5   0   Inflation Index J_1AINFT20
166 J_1AIDATEP J_1AIDATES J_1AUDATEP DATS 8   0   Indexing base date  
167 BSTKD_M BSTKD_M CHAR35 CHAR 35   0   Customer PO number as matchcode field  
168 DELCO DELCO DELCO CHAR 3   0   Agreed delivery time TVDC
169 FFPRF AD01PROFNR AD01PROFNR CHAR 8   0   Dynamic Item Processor Profile AD01C_PROF
170 BEMOT BEMOT BEMOT CHAR 2   0   Accounting Indicator TBMOT
171 FAKTF FAKTF FAKTF CHAR 2   0   Billing Form  
172 RRREL RR_RELTYP RR_RELTYP CHAR 1   0   Revenue recognition category  
173 ACDATV RR_ACDATV RR_ACDATV CHAR 1   0   Proposed start date for accrual period  
174 HANDLE TSEGGUID_VBAK SYSUUID_22 CHAR 22   0   International unique key for VBAK-VBELN  
175 PROLI ADGE_PROLI ADGD_PROLI CHAR 3   0   Dangerous Goods Management Profile in SD Documents TDGC5
176 CONT_DG ADGE_NCDG X CHAR 1   0   Indicator: Document contains dangerous goods  
177 VSART VSARTTR VERSART CHAR 2   0   Shipping type T173
178 TRATY TRATY TRATY CHAR 4   0   Means-of-Transport Type TVTY
179 TRMTYP TRMTYP MATNR CHAR 18   0   Means of Transportation MARA
180 SDABW SDABW SDABW CHAR 4   0   Special Processing Indicator TVSAK
181 WMINR WMINR WMINR CHAR 10   0   Product catalog number WWMI
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MASSSDHEAD ABRVW TVLV ABRVW REF C CN
2 MASSSDHEAD ABSSC T691M ABSSC REF C CN
3 MASSSDHEAD ABTNR TSAB ABTNR REF 1 CN
4 MASSSDHEAD AKWAE TCURC WAERS REF 1 CN
5 MASSSDHEAD AUART TVAK AUART REF 1 CN
6 MASSSDHEAD AUFNR AUFK AUFNR REF C CN
7 MASSSDHEAD AUGRU TVAU AUGRU REF C CN
8 MASSSDHEAD BEMOT TBMOT BEMOT REF 1 CN
9 MASSSDHEAD BSARK T176 BSARK REF C CN
10 MASSSDHEAD BSARK_E T176 BSARK C CN
11 MASSSDHEAD BUKRS_VF T001 BUKRS REF C CN
12 MASSSDHEAD BZIRK T171 BZIRK REF C CN
13 MASSSDHEAD CMWAE TCURC WAERS REF C CN
14 MASSSDHEAD CTLPC T691A CTLPC REF C CN
15 MASSSDHEAD DELCO TVDC DELCO KEY 1 CN
16 MASSSDHEAD FAKSK TVFS FAKSP REF C CN
17 MASSSDHEAD FFPRF AD01C_PROF PROFNR 1 CN
18 MASSSDHEAD FKARA TVFK FKART REF C CN
19 MASSSDHEAD FPLNR FPLA FPLNR REF C CN
20 MASSSDHEAD GSBER TGSB GSBER REF C CN
21 MASSSDHEAD GSKST TGSB GSBER REF C CN
22 MASSSDHEAD HITYP_PR THIT HITYP REF C CN
23 MASSSDHEAD INCO1 TINC INCO1 REF C CN
24 MASSSDHEAD J_1ADTYP J_1ADTYP J_1ADTYP 1 CN
25 MASSSDHEAD J_1AFITP J_1AFITP J_1AFITP 1 CN
26 MASSSDHEAD J_1AGICD J_1AGICD J_1AGICD 1 CN
27 MASSSDHEAD J_1AINDXP J_1AINFT20 J_1AINDX KEY 1 CN
28 MASSSDHEAD J_1AREGIO T005S BLAND 1 CN
29 MASSSDHEAD J_1ARFZ J_1ARFZ J_1ARFZ 1 CN
30 MASSSDHEAD J_1ATXREL J_1ATXREL J_1ATXREL 1 CN
31 MASSSDHEAD KALSM T683 KALSM REF C CN
32 MASSSDHEAD KALSM_CH T683 KALSM REF C CN
33 MASSSDHEAD KDGRP T151 KDGRP REF C CN
34 MASSSDHEAD KDKG1 TVKGG KDKGR C CN
35 MASSSDHEAD KDKG2 TVKGG KDKGR C CN
36 MASSSDHEAD KDKG3 TVKGG KDKGR C CN
37 MASSSDHEAD KDKG4 TVKGG KDKGR C CN
38 MASSSDHEAD KDKG5 TVKGG KDKGR C CN
39 MASSSDHEAD KKBER T014 KKBER REF C CN
40 MASSSDHEAD KNKLI KNA1 KUNNR REF C CN
41 MASSSDHEAD KNUMA KONA KNUMA KEY 1 CN
42 MASSSDHEAD KOKRS TKA01 KOKRS REF C CN
43 MASSSDHEAD KONDA T188 KONDA REF C CN
44 MASSSDHEAD KTGRD TVKT KTGRD REF C CN
45 MASSSDHEAD KUNNR KNA1 KUNNR REF C CN
46 MASSSDHEAD KURST TCURV KURST REF C CN
47 MASSSDHEAD KVGR1 TVV1 KVGR1 REF C CN
48 MASSSDHEAD KVGR2 TVV2 KVGR2 REF C CN
49 MASSSDHEAD KVGR3 TVV3 KVGR3 REF C CN
50 MASSSDHEAD KVGR4 TVV4 KVGR4 REF C CN
51 MASSSDHEAD KVGR5 TVV5 KVGR5 REF C CN
52 MASSSDHEAD LANDTX T005 LAND1 C CN
53 MASSSDHEAD LCNUM AKKP LCNUM C CN
54 MASSSDHEAD LIFSK TVLS LIFSP REF C CN
55 MASSSDHEAD MANDT T000 MANDT KEY 1 CN
56 MASSSDHEAD MANSP T040S MANSP REF C CN
57 MASSSDHEAD MSCHL T040 MSCHL REF C CN
58 MASSSDHEAD OBJNR ONR00 OBJNR REF C CN
59 MASSSDHEAD PERFK TFACD IDENT REF C CN
60 MASSSDHEAD PERRL TFACD IDENT REF C CN
61 MASSSDHEAD PLTYP T189 PLTYP REF C CN
62 MASSSDHEAD POSNR VBUP POSNR KEY 1 CN
63 MASSSDHEAD PROLI TDGC5 PROLI    
64 MASSSDHEAD PS_PSP_PNR PRPS PSPNR REF C CN
65 MASSSDHEAD QMNUM QMEL QMNUM REF C CN
66 MASSSDHEAD RPLNR FPLA FPLNR REF C 1
67 MASSSDHEAD SBGRP T024B SBGRP REF C CN
68 MASSSDHEAD SCHEME_GRP TVGRPS SCHEME 1 CN
69 MASSSDHEAD SDABW TVSAK SDABW KEY 1 CN
70 MASSSDHEAD SPART TVTA SPART REF 1 CN
71 MASSSDHEAD STCEG_L T005 LAND1 C CN
72 MASSSDHEAD STWAE TCURC WAERS REF C CN
73 MASSSDHEAD TRATY TVTY TRATY KEY 1 CN
74 MASSSDHEAD TRMTYP MARA MATNR KEY 1 CN
75 MASSSDHEAD VBELN VBUK VBELN KEY 1 C
76 MASSSDHEAD VGBEL VBUK VBELN REF C CN
77 MASSSDHEAD VKBUR TVKBZ VKBUR REF C CN
78 MASSSDHEAD VKGRP TVBVK VKGRP REF C CN
79 MASSSDHEAD VKORG TVKO VKORG REF 1 CN
80 MASSSDHEAD VSART T173 VSART KEY 1 CN
81 MASSSDHEAD VSBED TVSB VSBED REF C CN
82 MASSSDHEAD VTWEG TVKOV VTWEG REF 1 CN
83 MASSSDHEAD WAERK TCURC WAERS REF C CN
84 MASSSDHEAD WAKTION WAKH AKTNR REF 1 CN
85 MASSSDHEAD WKWAE TCURC WAERS 1 CN
86 MASSSDHEAD WMINR WWMI WMINR REF 1 CN
87 MASSSDHEAD ZLSCH T042Z ZLSCH REF C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in