SAP ABAP Table TDS_SLS_IND_PUR (Individual Purchase Document Structure)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD (Application Component) Sales and Distribution
     ⤷ ERP_SALES_O2C_WHOLESALE (Package) ERP Sales Order 2 Cash - Wholesale
Basic Data
Table Category INTTAB    Structure 
Structure TDS_SLS_IND_PUR   Table Relationship Diagram
Short Description Individual Purchase Document Structure    
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 VBELN VBELN VBELN CHAR 10   0   Sales and Distribution Document Number *
2 TRVOG TRVOG_GEN TRVOG_GEN CHAR 1   0   Transaction Group  
3 TRVOG_T BEZEI20 TEXT20 CHAR 20   0   Description  
4 AUART AUART AUART CHAR 4   0   Sales Document Type *
5 AUART_T BEZEI20 TEXT20 CHAR 20   0   Description  
6 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
7 KUNAG_T AD_NAME1 TEXT40 CHAR 40   0   Name 1  
8 BSTKD BSTKD BSTKD CHAR 35   0   Customer purchase order number  
9 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
10 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
11 ZPAVW PARVW PARVW CHAR 2   0   Partner Role *
12 ZPERS DZPERS PERNR NUMC 8   0   Person responsible  
13 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
14 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
15 SPART SPART SPART CHAR 2   0   Division TSPA
16 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
17 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
18 WAERK WAERK WAERS CUKY 5   0   SD document currency *
19 NETWR NETWR_AK WERTV8 CURR 15   2   Net Value of the Sales Order in Document Currency  
20 AWAHR AWAHR_AK AWAHR NUMC 3   0   Sales Probability  
21 PARVW_T PARVW_BEZ TEXT20 CHAR 20   0   Description of partner function  
22 VKORG_T VKORG_BEZ TEXT20 CHAR 20   0   Description of sales organization  
23 VTWEG_T VTWEG_BEZ TEXT20 CHAR 20   0   Description of distribution channel  
24 SPART_T SPART_BEZ TEXT20 CHAR 20   0   Description of division  
25 VKBUR_T VKBUR_BEZ TEXT20 CHAR 20   0   Description of sales office  
26 VKGRP_T VKGRP_BEZ TEXT20 CHAR 20   0   Description of Sales Group  
27 SPSTG SPSTG STATV CHAR 1   0   Overall blocked status  
28 ABSTK ABSTK STATV CHAR 1   0   Overall rejection status of all sales document items  
29 GBSTK GBSTK STATV CHAR 1   0   Overall processing status of document  
30 UVALS UVALL_SU STATV CHAR 1   0   Total incompletion status of all items in general  
31 UVALL UVALL_UK STATV CHAR 1   0   General incompletion status of the header  
32 CMGST CMGST CMGST CHAR 1   0   Overall status of credit checks  
33 LFSTK LFSTK STATV CHAR 1   0   Delivery status  
34 FSSTK FSSTK STATV CHAR 1   0   Overall billing block status  
35 LSSTK LSSTK_G STATV CHAR 1   0   Overall delivery block status  
36 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) *
37 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
38 VSBED VSBED VSBED CHAR 2   0   Shipping conditions *
39 GUEBG GUEBG DATUM DATS 8   0   Valid-from date (outline agreements, product proposals)  
40 GUEEN GUEEN DATUM DATS 8   0   Valid-to date (outline agreements, product proposals)  
41 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
42 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) *
43 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
44 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
45 ZTERM_T DZTERM_BEZ TEXT30 CHAR 30   0   Description of terms of payment  
46 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
47 VBTYP_T VBTYP_TXT AS4TEXT CHAR 60   0   Description of sales and distribution document category  
48 POSNR POSNR_VA POSNR NUMC 6   0   Sales Document Item *
49 MATNR MATNR MATNR CHAR 18   0   Material Number *
50 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
51 KWMENG KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
52 VRKME VRKME MEINS UNIT 3   0   Sales unit *
53 KBMENG KBMENG MENG15 QUAN 15   3   Cumulative confirmed quantity in sales unit  
54 KDMAT MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
55 ABGRU ABGRU_VA ABGRU_VA CHAR 2   0   Reason for rejection of quotations and sales orders *
56 ABGRU_T ABGRU_BEZ TEXT40 CHAR 40   0   Description of reason for rejection  
57 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
58 ZMENG DZMENG MENG13 QUAN 13   3   Target quantity in sales units  
59 ZWERT DZWERT WERT7 CURR 13   2   Target value for outline agreement in document currency  
60 ZIEME DZIEME MEINS UNIT 3   0   Target quantity UoM *
61 NETPR NETPR WERTV6 CURR 11   2   Net price  
62 EDATU EDATU DATUM DATS 8   0   Schedule line date  
63 ETENR ETENR ETENR NUMC 4   0   Schedule line *
64 BANFN BANFN BANFN CHAR 10   0   Purchase requisition number  
65 BNFPO BNFPO BNFPO NUMC 5   0   Item number of purchase requisition *
66 EBANBSART BBSRT BSART CHAR 4   0   Purchase Requisition Document Type *
67 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group *
68 BEDNR BEDNR CHAR10 CHAR 10   0   Requirement Tracking Number  
69 MATKL MATKL MATKL CHAR 9   0   Material Group *
70 RESWK RESWK WERKS CHAR 4   0   Supplying (issuing) plant in case of stock transport order *
71 MENGE BAMNG MENG13 QUAN 13   3   Purchase requisition quantity  
72 EBANMEINS BAMEI MEINS UNIT 3   0   Purchase requisition unit of measure *
73 BADAT BADAT DATUM DATS 8   0   Requisition (request) date  
74 LFDAT EINDT DATUM DATS 8   0   Item delivery date  
75 PSTYP PSTYP PSTYP CHAR 1   0   Item category in purchasing document *
76 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category *
77 EBANFRGRL FRGRL XFELD CHAR 1   0   Release Not Yet Completely Effected  
78 FRGDT FRGDT DATUM DATS 8   0   Purchase Requisition Release Date  
79 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number *
80 LIFNAM NAME1 TEXT30 CHAR 30   0   Name  
81 EKORG EKORG EKORG CHAR 4   0   Purchasing organization *
82 BSMNG BSMNG MENG13 QUAN 13   3   Quantity ordered against this purchase requisition  
83 BMEIN BSTME MEINS UNIT 3   0   Order unit *
84 WERKS EWERK WERKS CHAR 4   0   Plant *
85 WAERS WAERS WAERS CUKY 5   0   Currency Key *
86 EBAKZ EBAKZ XFELD CHAR 1   0   Purchase requisition closed  
87 PREIS BAPRE WERT11 CURR 11   2   Price in Purchase Requisition  
88 STATU BANST BANST CHAR 1   0   Processing status of purchase requisition  
89 BANPR BANPR BANPR CHAR 2   0   Requisition Processing State  
90 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
91 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
92 BSART ESART BSART CHAR 4   0   Purchasing Document Type *
93 BEDAT EBDAT DATUM DATS 8   0   Purchasing Document Date  
94 TXZ01 TXZ01 TEXT40 CHAR 40   0   Short Text  
95 EKPOMENGE BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
96 EKPOMEINS BSTME MEINS UNIT 3   0   Order unit *
97 BPRME BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) *
98 EKPONETPR BPREI WERT11 CURR 11   2   Net Price in Purchasing Document (in Document Currency)  
99 PEINH EPEIN DEC5 DEC 5   0   Price unit  
100 EKPONETWR BWERT WERT7 CURR 13   2   Net Order Value in PO Currency  
101 BRTWR BBWERT WERT7 CURR 13   2   Gross order value in PO currency  
102 BSTAE BSTAE BSTAE CHAR 4   0   Confirmation Control Key *
103 NAME1 NAME1 TEXT30 CHAR 30   0   Name  
104 LGORT LGORT_D LGORT CHAR 4   0   Storage location *
105 INFNR INFNR INFNR CHAR 10   0   Number of purchasing info record *
106 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
107 KZABS KZABS XFELD CHAR 1   0   Order Acknowledgment Requirement  
108 LABNR LABNR TEXT20 CHAR 20   0   Order Acknowledgment Number  
109 OWEMG OWEMG MENG13 QUAN 13   3   Open goods receipt quantity  
110 EKKOFRGRL FRGRL XFELD CHAR 1   0   Release Not Yet Completely Effected  
111 SLSPTYP SLSPTYP SLSPTYP CHAR 6   0   Sales Document Problem Type  
112 SLSSRC SLSSRC SLSSRC CHAR 6   0   Sales Document Problem Source  
113 MSEGSTATUS MSEGSTATUS STATV CHAR 1   0   Good Receipt Status  
114 EKPOWEBAZ WEBAZ DEC3 DEC 3   0   Goods receipt processing time in days  
115 MBDAT MBDAT DATUM DATS 8   0   Material Staging/Availability Date  
116 BWART BWART BWART CHAR 3   0   Movement type (inventory management) *
117 EKPOELIKZ ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
118 GBSTK_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
119 LFSTK_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
120 MSEGSTATUS_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
121 STATU_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
122 BANPR_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
123 ABSTK_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
124 CMGST_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
125 SPSTG_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
126 LSSTK_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
127 SLSPTYP_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
128 SLSSRC_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
129 COSTA COSTA_D COSTA CHAR 1   0   Confirmation status for ALE  
130 COSTA_T DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
131 UMVKZ UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
132 UMVKN UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
133 PZPERS_T NAME1 TEXT30 CHAR 30   0   Name  
134 FABKL FABKL WFCID CHAR 2   0   Factory calendar key *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TDS_SLS_IND_PUR SPART TSPA SPART    
2 TDS_SLS_IND_PUR VKORG TVKO VKORG    
3 TDS_SLS_IND_PUR VTWEG TVTW VTWEG    
History
Last changed by/on SAP  20130529 
SAP Release Created in 602