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
⤷ 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
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |