SAP ABAP Table MDSB_X (Dependent reqts. from database (SC processing, Purchasing))
Hierarchy
BBPCRM (Software Component) BBPCRM
   SRM-EBP (Application Component) Enterprise Buyer
     BBP_APPLICATION (Package) Structure Package EBP
       ME (Package) Application development R/3 Purchasing
Basic Data
Table Category INTTAB    Structure 
Structure MDSB_X   Table Relationship Diagram
Short Description Dependent reqts. from database (SC processing, Purchasing)    
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 EEBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
2 EPOSN EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
3 ETENR EETEN EETEN NUMC 4   0   Delivery Schedule Line Counter *
4 .INCLUDE       0   0   Reservation/dependent requirements  
5 MANDT MANDT MANDT CLNT 3   0   Client T000
6 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements *
7 RSPOS RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
8 RSART RSART RSART CHAR 1   0   Record type  
9 BDART BDART BDART CHAR 2   0   Requirement type  
10 RSSTA RSSTA STATR CHAR 1   0   Status of reservation  
11 XLOEK XLOEK XFELD CHAR 1   0   Item is deleted  
12 XWAOK XWAOK XFELD CHAR 1   0   Goods movement for reservation allowed  
13 KZEAR KZEAR XFELD CHAR 1   0   Final issue for this reservation  
14 XFEHL XFEHL XFELD CHAR 1   0   Pre-allocated stock  
15 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
16 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
17 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
18 PRVBE PRVBE PRVBE CHAR 10   0   Production Supply Area *
19 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
20 PLPLA PLPLA PLPLA CHAR 10   0   Distribution of Differences  
21 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
22 BDTER BDTER DATUM DATS 8   0   Requirements date for the component  
23 BDMNG BDMNG MENG13 QUAN 13   3   Requirement Quantity  
24 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
25 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
26 FMENG FMENG XFELD CHAR 1   0   Quantity is fixed  
27 ENMNG ENMNG MENG13 QUAN 13   3   Quantity withdrawn  
28 ENWRT ENWRT VWERT13 CURR 13   2   Value Withdrawn  
29 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
30 ERFMG ERFMG MENG13 QUAN 13   3   Quantity in unit of entry  
31 ERFME ERFME MEINS UNIT 3   0   Unit of entry T006
32 PLNUM PLNUM PLNUM CHAR 10   0   Planned order number PLAF
33 BANFN BANFN BANFN CHAR 10   0   Purchase requisition number  
34 BNFPO BNFPO BNFPO NUMC 5   0   Item number of purchase requisition EBAN
35 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
36 BAUGR BAUGR MATNR CHAR 18   0   Material number of higher-level assembly MARA
37 SERNR SERNR SERNR CHAR 8   0   BOM explosion number SNUM
38 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
39 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
40 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
41 PROJN PROJN PROJN CHAR 16   0   Old: Project number : No longer used --> PS_POSNR  
42 BWART BWART BWART CHAR 3   0   Movement type (inventory management) T156
43 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number *
44 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
45 UMWRK UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant T001W
46 UMLGO UMLGO LGORT CHAR 4   0   Receiving/issuing storage location T001L
47 NAFKZ NAFKZ XFELD CHAR 1   0   Indicator: follow-up material active/not active  
48 NOMAT NOMAT MATNR CHAR 18   0   Follow-Up/Original Material MARA
49 NOMNG NOMNG MENG13 QUAN 13   3   Required quantity  
50 POSTP POSTP POSTP CHAR 1   0   Item category (bill of material) T418
51 POSNR APOSN SPOSN CHAR 4   0   BOM item number  
52 ROMS1 ROMS1 MENG13 QUAN 13   3   Size 1  
53 ROMS2 ROMS2 MENG13 QUAN 13   3   Size 2  
54 ROMS3 ROMS3 MENG13 QUAN 13   3   Size 3  
55 ROMEI ROMEI MEINS UNIT 3   0   Unit of measure for sizes 1 to 3 T006
56 ROMEN ROMEN MENG13 QUAN 13   3   VarSizeItem Qty  
57 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
58 LMENG LMENG MENG13 QUAN 13   3   Required quantity for mat.management in stockkeeping units  
59 ROHPS ROHPS XFELD CHAR 1   0   Variable-sized item indicator  
60 RFORM RFORM RFORM CHAR 2   0   Formula Key T418F
61 ROANZ ROANZ MENG13 QUAN 13   3   Number of Variable-Size Items  
62 FLMNG FLMNG MENG13 QUAN 13   3   Shortfall quantity of the component in the order  
63 STLTY STLTY STLTY CHAR 1   0   BOM Category  
64 STLNR STNUM STNUM CHAR 8   0   Bill of Material  
65 STLKN STLKN KNTNR NUMC 8   0   BOM Item Node Number  
66 STPOZ CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
67 LTXSP LTXSP SPRAS LANG 1   0   Language: The long text was stored in this language T002
68 POTX1 POTX1 TEXT40 CHAR 40   0   BOM Item Text (Line 1)  
69 POTX2 POTX2 TEXT40 CHAR 40   0   BOM Item Text (Line 2)  
70 SANKA CK_SELKZ CK_SELKZ CHAR 1   0   Indicator for Relevancy to Costing TCK08
71 ALPOS ALTPS XFELD CHAR 1   0   Alternative item indicator  
72 EWAHR EWAHR DEC3 DEC 3   0   Usage Probability in % (Alternative Item)  
73 AUSCH KAUSF DEC3_2 DEC 5   2   Component scrap in percent  
74 AVOAU AVOAU DEC3_2 DEC 5   2   Operation Scrap  
75 NETAU NETAU XFELD CHAR 1   0   Indicator: Net Scrap  
76 NLFZT NLFZT NLFZT DEC 3   0   Lead-Time Offset  
77 AENNR AENNR AENNR CHAR 12   0   Change Number AENR
78 UMREZ UMREZ UMBSZ DEC 5   0   Numerator for Conversion to Base Units of Measure  
79 UMREN UMREN UMBSN DEC 5   0   Denominator for conversion to base units of measure  
80 SORTF SORTP CHAR10 CHAR 10   0   Sort String  
81 SBTER SBTER DATUM DATS 8   0   Latest requirements date  
82 VERTI SA_VERTL SA_VERTL CHAR 4   0   MRP Distribution Key T437V
83 SCHGT SCHGT XFELD CHAR 1   0   Indicator: bulk material  
84 UPSKZ UPSKZ XFELD CHAR 1   0   Indicator: Subitems Exist  
85 DBSKZ DBSKZ DBSKZ CHAR 1   0   Direct procurement indicator  
86 TXTPS TXTPS XFELD CHAR 1   0   Item text indicator  
87 DUMPS DUMPS XFELD CHAR 1   0   Phantom item indicator  
88 BEIKZ BEIKZ BEIKZ CHAR 1   0   Material Provision Indicators T417
89 ERSKZ ERSKZ ERSKZ CHAR 1   0   Indicator: Spare Part T413
90 AUFST AUFST AUFST NUMC 2   0   Order level  
91 AUFWG AUFWG AUFWG NUMC 2   0   Order path  
92 BAUST BAUST AUFST NUMC 2   0   Assembly order level  
93 BAUWG BAUWG AUFWG NUMC 2   0   Assembly order path  
94 AUFPS AUFPS CHAR2 CHAR 2   0   Order item number  
95 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
96 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
97 EBELE EETEN EETEN NUMC 4   0   Delivery Schedule Line Counter EKET
98 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category T163K
99 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
100 PSPEL PS_POSNR PS_POSNR NUMC 8   0   WBS Element *
101 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
102 PLNFL PLNFOLGE PLNFOLGE CHAR 6   0   Sequence  
103 VORNR VORNR VORNR CHAR 4   0   Operation/Activity Number  
104 APLZL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
105 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
106 FLGAT FOLGENART FLGAT CHAR 1   0   Sequence category TCA07
107 GPREIS PPCOMP WERTV8 CURR 15   2   Price in component currency  
108 FPREIS OPREIFX WERTV8 CURR 15   2   Fixed Price in Foreign Currency  
109 PEINH PEINH PACK3 DEC 5   0   Price unit  
110 RGEKZ RGEKZ XFELD CHAR 1   0   Indicator: Backflush  
111 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group T024
112 ROKME ROKME MEINS UNIT 3   0   Unit of measure for variable-size component T006
113 ZUMEI DZUMEI MEINS UNIT 3   0   Unit for cutting measures T006
114 ZUMS1 DZUMS1 MENG13 QUAN 13   3   Cutting measure 1  
115 ZUMS2 DZUMS2 MENG13 QUAN 13   3   Cutting measure 2  
116 ZUMS3 DZUMS3 MENG13 QUAN 13   3   Cutting measure 3  
117 ZUDIV DZUDIV ZUDIV NUMC 5   0   Integral divisor for cutting measures  
118 VMENG VMENG MENG15 QUAN 15   3   Confirmed quantity for availability check in SKU  
119 PRREG PRREG PRREG CHAR 2   0   Checking rule for the availability check T441R
120 LIFZT LIFZT DEC3 DEC 3   0   Delivery Time in Days  
121 CUOBJ CUOBJ CUOBJ NUMC 18   0   Configuration (internal object number)  
122 KFPOS KFPOS XFLAG CHAR 1   0   Indicator: "configurable item"  
123 REVLV REVLV REVLV CHAR 2   0   Revision level  
124 BERKZ BERKZ LVS_BERKZ CHAR 1   0   Material Staging Indicator for Production Supply  
125 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
126 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type T301
127 LGPLA LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
128 TBMNG TBMNG MENG13 QUAN 13   3   Transfer requirement quantity already requested  
129 NPTXTKY TXTKY CHAR12 CHAR 12   0   Internal text number (12-character)  
130 KBNKZ KBNKZ KBNKZ CHAR 1   0   Kanban Indicator  
131 KZKUP KZKUP XFELD CHAR 1   0   Indicator: Co-Product  
132 AFPOS CO_POSNR CO_POSNR NUMC 4   0   Order item number  
133 NO_DISP NO_DISP_PLUS NO_DISP_PLUS CHAR 1   0   Effective for Materials Planning  
134 BDZTP BDZTP BDZTP TIMS 6   0   Time that reservation quantity required  
135 ESMNG ESMNG ESMNG FLTP 16   16   Usage quantity per order unit of measure  
136 ALPGR CS_ALPGR CHAR2 CHAR 2   0   Alternative Item: Group  
137 ALPRF CS_ALPRF NUM2 NUMC 2   0   Alternative Item: Ranking Order  
138 ALPST CS_ALPST CS_ALPST CHAR 1   0   Alternative Item: Strategy  
139 KZAUS AUSLF AUSLF CHAR 1   0   Discontinuation type  
140 NFEAG CS_NFEAG CHAR2 CHAR 2   0   Discontinuation Group  
141 NFPKZ CS_KZNFP XFELD CHAR 1   0   Indicator: Follow-Up Item  
142 NFGRP CS_NFGRP CHAR2 CHAR 2   0   Follow-Up Group  
143 NFUML NFUML NFUML DEC 5   4   NOT USED: Quantity transfer factor for follow-up material  
144 ADRNR CADNR CADRNR CHAR 10   0   Addresses: Address Number *
145 CHOBJ CUOBJ_CH CUOBJ NUMC 18   0   Internal object number of the batch classification  
146 SPLKZ CHSPLIT CHSPLIT CHAR 1   0   Batch key  
147 SPLRV RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
148 KNUMH KNUMH_CH KNUMB CHAR 10   0   Number of condition record from batch determination  
149 WEMPF WEMPF WEMPF CHAR 12   0   Goods recipient  
150 ABLAD ABLAD TEXT25 CHAR 25   0   Unloading Point  
151 HKMAT HKMAT HKMAT CHAR 1   0   Material-related origin  
152 HRKFT HRKFT HRKFT CHAR 4   0   Origin Group as Subdivision of Cost Element *
153 VORAB VORABKZ XFELD CHAR 1   0   Ind: Preliminary order  
154 MATKL MATKL MATKL CHAR 9   0   Material Group T023
155 FRUNV FRUNV KREUZ CHAR 1   0   Indicator: External procurement data incomplete  
156 CLAKZ CLAKZ XFELD CHAR 1   0   Indicator: classification exists  
157 INPOS INPOS XFELD CHAR 1   0   Indicator: intra material  
158 WEBAZ WEBAZ DEC3 DEC 3   0   Goods receipt processing time in days  
159 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
160 FLGEX FLGEX XFELD CHAR 1   0   Indicator: External procurement  
161 FUNCT CY_FUNCT CY_FUNC CHAR 3   0   Distribution function TC29V
162 GPREIS_2 PPGXXX WERTV8 CURR 15   2   Total Price in Local Currency  
163 FPREIS_2 PPFXXX WERTV8 CURR 15   2   Fixed price in local currency  
164 PEINH_2 PEINH PACK3 DEC 5   0   Price unit  
165 INFNR INFNR INFNR CHAR 10   0   Number of purchasing info record EINA
166 KZECH KZECH KZECH CHAR 1   0   Determination of batch entry in the production/process order  
167 KZMPF KZMPF XFELD CHAR 1   0   Manual Maintenance of Requirement Date  
168 STLAL STALT ALTNR CHAR 2   0   Alternative BOM  
169 PBDNR PBDNR CHAR10 CHAR 10   0   Requirements Plan Number  
170 STVKN STVKN KNTNR NUMC 8   0   Inherited Node Number of BOM Item  
171 KTOMA KTOMA CHAR1 CHAR 1   0   Acct entered manually  
172 VRPLA VRPLA XFELD CHAR 1   0   Indicator: planning without final assembly  
173 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
174 NLFZV CS_NLFZV NLFZT DEC 3   0   Lead-time offset for operation  
175 NLFMV CS_NLFMV MEINS UNIT 3   0   Unit for lead-time offset for operation T006
176 TECHS TECHS TECHS CHAR 12   0   Parameter Variant/Standard Variant  
177 OBJTYPE OCM_OBJ_TYPE OCM_OBJ_TYPE CHAR 1   0   Change indicator  
178 CH_PROC OCM_CH_PROC OCM_CH_PROC CHAR 1   0   Process that has lead to the change of an object  
179 FXPRU CK_FIXPRKU XFELD CHAR 1   0   Fixed-Price Co-Product  
180 UMSOK UMSOK SOBKZ CHAR 1   0   Special stock indicator for physical stock transfer *
181 VORAB_SM VORAB_SM VORAB_SM CHAR 1   0   Advance Shipment Indicator  
182 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
183 FIPEX FM_FIPEX FM_FIPEX CHAR 24   0   Commitment item *
184 FISTL FISTL FISTL CHAR 16   0   Funds Center *
185 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
186 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
187 FKBER FKBER FKBER CHAR 16   0   Functional Area *
188 PRIO_URG PRIO_URG PRIO_URG NUMC 2   0   Requirement Urgency PURG
189 PRIO_REQ PRIO_REQ PRIO_REQ NUMC 3   0   Requirement Priority PREQ
190 KBLNR KBLNR KBLNR CHAR 10   0   Document Number for Earmarked Funds *
191 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
192 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
193 SC_OBJECT_ID /SRMERP/OBJECT_ID /SRMERP/OBJECT_ID CHAR 10   0   Object ID - Document Number  
194 SC_ITM_NO /SRMERP/SC_ITM_NO INT4 INT4 10   0   Internal Shopping Cart Item Number  
195 .INCLU--AP       0   0   Append to RESB for DFPS  
196 ADVCODE /ISDFPS/ADVCODE /ISDFPS/ADVCODE CHAR 2   0   Advice Code /ISDFPS/ADVCODE1
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MDSB_X ADVCODE /ISDFPS/ADVCODE1 ADVCODE    
2 MDSB_X AENNR AENR AENNR REF C CN
3 MDSB_X AUFNR AUFK AUFNR REF C CN
4 MDSB_X BAUGR MARA MATNR REF C CN
5 MDSB_X BEIKZ T417 BEIKZ REF C CN
6 MDSB_X BNFPO EBAN BNFPO REF C CN
7 MDSB_X BWART T156 BWART REF 1 CN
8 MDSB_X CHARG MCHA CHARG REF C CN
9 MDSB_X EBELE EKET ETENR KEY 1 CN
10 MDSB_X EBELN EKKO EBELN KEY 1 CN
11 MDSB_X EBELP EKPO EBELP KEY 1 CN
12 MDSB_X EKGRP T024 EKGRP REF C CN
13 MDSB_X ERFME T006 MSEHI REF C CN
14 MDSB_X ERSKZ T413 ERSKZ REF C CN
15 MDSB_X FLGAT TCA07 FLGAT REF C CN
16 MDSB_X FUNCT TC29V FUNCT REF C CN
17 MDSB_X GSBER TGSB GSBER REF C CN
18 MDSB_X INFNR EINA INFNR REF C CN
19 MDSB_X KDAUF VBUK VBELN REF C CN
20 MDSB_X KNTTP T163K KNTTP KEY 1 CN
21 MDSB_X LGNUM T300 LGNUM REF C CN
22 MDSB_X LGORT T001L LGORT REF C CN
23 MDSB_X LGPLA LAGP LGPLA REF C CN
24 MDSB_X LGTYP T301 LGTYP REF C CN
25 MDSB_X LIFNR LFA1 LIFNR REF C CN
26 MDSB_X LTXSP T002 SPRAS REF C CN
27 MDSB_X MANDT T000 MANDT KEY 1 CN
28 MDSB_X MATKL T023 MATKL REF 1 N
29 MDSB_X MATNR MARA MATNR REF 1 CN
30 MDSB_X MEINS T006 MSEHI REF 1 CN
31 MDSB_X NLFMV T006 MSEHI 1 N
32 MDSB_X NOMAT MARA MATNR REF C CN
33 MDSB_X OBJNR ONR00 OBJNR REF C 1
34 MDSB_X PLNUM PLAF PLNUM REF C CN
35 MDSB_X POSTP T418 POSTP REF C CN
36 MDSB_X PRIO_REQ PREQ PRIO_REQ REF 1 CN
37 MDSB_X PRIO_URG PURG PRIO_URG REF 1 CN
38 MDSB_X PRREG T441R PRREG KEY 1 1
39 MDSB_X RFORM T418F RFORM REF C CN
40 MDSB_X ROKME T006 MSEHI REF C CN
41 MDSB_X ROMEI T006 MSEHI REF C CN
42 MDSB_X SANKA TCK08 SELKZ KEY 1 CN
43 MDSB_X SERNR SNUM SERNR C CN
44 MDSB_X SOBKZ T148 SOBKZ REF C CN
45 MDSB_X UMLGO T001L LGORT REF C CN
46 MDSB_X UMWRK T001W WERKS REF C CN
47 MDSB_X VERTI T437V VERTL REF C CN
48 MDSB_X WAERS TCURC WAERS REF 1 CN
49 MDSB_X WERKS T001W WERKS REF 1 CN
50 MDSB_X ZUMEI T006 MSEHI REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in