SAP ABAP Table VMDSB (VMDSB)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ MM-PUR (Application Component) Purchasing
⤷ MEDCM (Package) Purchasing: Change Management
⤷ MM-PUR (Application Component) Purchasing
⤷ MEDCM (Package) Purchasing: Change Management
Basic Data
Table Category | INTTAB | Structure |
Structure | VMDSB | Table Relationship Diagram |
Short Description |
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 | .INCLUDE | 0 | 0 | Generated Table for View | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
4 | RSPOS | RSPOS | RSPOS | NUMC | 4 | 0 | Item Number of Reservation / Dependent Requirements | ||
5 | RSART | RSART | RSART | CHAR | 1 | 0 | Record type | ||
6 | AUFST | AUFST | AUFST | NUMC | 2 | 0 | Order level | ||
7 | AUFWG | AUFWG | AUFWG | NUMC | 2 | 0 | Order path | ||
8 | POSNR | APOSN | SPOSN | CHAR | 4 | 0 | BOM item number | ||
9 | SORTF | SORTP | CHAR10 | CHAR | 10 | 0 | Sort String | ||
10 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
11 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
12 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
13 | PRVBE | PRVBE | PRVBE | CHAR | 10 | 0 | Production Supply Area | * | |
14 | BDART | BDART | BDART | CHAR | 2 | 0 | Requirement type | ||
15 | POSTP | POSTP | POSTP | CHAR | 1 | 0 | Item category (bill of material) | T418 | |
16 | XLOEK | XLOEK | XFELD | CHAR | 1 | 0 | Item is deleted | ||
17 | NODSP | NO_DISP_PLUS | NO_DISP_PLUS | CHAR | 1 | 0 | Effective for Materials Planning | ||
18 | UPSKZ | UPSKZ | XFELD | CHAR | 1 | 0 | Indicator: Subitems Exist | ||
19 | SCHGT | SCHGT | XFELD | CHAR | 1 | 0 | Indicator: bulk material | ||
20 | TXTPS | TXTPS | XFELD | CHAR | 1 | 0 | Item text indicator | ||
21 | INPOS | INPOS | XFELD | CHAR | 1 | 0 | Indicator: intra material | ||
22 | DUMPS | DUMPS | XFELD | CHAR | 1 | 0 | Phantom item indicator | ||
23 | KFPOS | KFPOS | XFLAG | CHAR | 1 | 0 | Indicator: "configurable item" | ||
24 | CLAKZ | CLAKZ | XFELD | CHAR | 1 | 0 | Indicator: classification exists | ||
25 | DBSKZ | DBSKZ | DBSKZ | CHAR | 1 | 0 | Direct procurement indicator | ||
26 | SANKA | CK_SELKZ | CK_SELKZ | CHAR | 1 | 0 | Indicator for Relevancy to Costing | TCK08 | |
27 | BDMNG | BDMNG | MENG13 | QUAN | 13 | 3 | Requirement Quantity | ||
28 | VMENG | VMENG | MENG15 | QUAN | 15 | 3 | Confirmed quantity for availability check in SKU | ||
29 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
30 | ESMNG | ESMNG | ESMNG | FLTP | 16 | 16 | Usage quantity per order unit of measure | ||
31 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
32 | BEIKZ | BEIKZ | BEIKZ | CHAR | 1 | 0 | Material Provision Indicators | T417 | |
33 | ERSKZ | ERSKZ | ERSKZ | CHAR | 1 | 0 | Indicator: Spare Part | T413 | |
34 | ERFMG | ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry | ||
35 | ERFME | ERFME | MEINS | UNIT | 3 | 0 | Unit of entry | T006 | |
36 | UMREZ | UMREZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion to Base Units of Measure | ||
37 | UMREN | UMREN | UMBSN | DEC | 5 | 0 | Denominator for conversion to base units of measure | ||
38 | FMENG | FMENG | XFELD | CHAR | 1 | 0 | Quantity is fixed | ||
39 | ALPOS | ALTPS | XFELD | CHAR | 1 | 0 | Alternative item indicator | ||
40 | EWAHR | EWAHR | DEC3 | DEC | 3 | 0 | Usage Probability in % (Alternative Item) | ||
41 | ALPGR | CS_ALPGR | CHAR2 | CHAR | 2 | 0 | Alternative Item: Group | ||
42 | ALPRF | CS_ALPRF | NUM2 | NUMC | 2 | 0 | Alternative Item: Ranking Order | ||
43 | ALPST | CS_ALPST | CS_ALPST | CHAR | 1 | 0 | Alternative Item: Strategy | ||
44 | AUSCH | KAUSF | DEC3_2 | DEC | 5 | 2 | Component scrap in percent | ||
45 | AVOAU | AVOAU | DEC3_2 | DEC | 5 | 2 | Operation Scrap | ||
46 | NETAU | NETAU | XFELD | CHAR | 1 | 0 | Indicator: Net Scrap | ||
47 | BDTER | BDTER | DATUM | DATS | 8 | 0 | Requirements date for the component | ||
48 | SBTER | SBTER | DATUM | DATS | 8 | 0 | Latest requirements date | ||
49 | VERTI | SA_VERTL | SA_VERTL | CHAR | 4 | 0 | MRP Distribution Key | T437V | |
50 | NLFZT | NLFZT | NLFZT | DEC | 3 | 0 | Lead-Time Offset | ||
51 | BDZTP | BDZTP | BDZTP | TIMS | 6 | 0 | Time that reservation quantity required | ||
52 | ROHPS | ROHPS | XFELD | CHAR | 1 | 0 | Variable-sized item indicator | ||
53 | ROANZ | ROANZ | MENG13 | QUAN | 13 | 3 | Number of Variable-Size Items | ||
54 | ROMEN | ROMEN | MENG13 | QUAN | 13 | 3 | VarSizeItem Qty | ||
55 | ROMEI | ROMEI | MEINS | UNIT | 3 | 0 | Unit of measure for sizes 1 to 3 | T006 | |
56 | ROMS1 | ROMS1 | MENG13 | QUAN | 13 | 3 | Size 1 | ||
57 | ROMS2 | ROMS2 | MENG13 | QUAN | 13 | 3 | Size 2 | ||
58 | ROMS3 | ROMS3 | MENG13 | QUAN | 13 | 3 | Size 3 | ||
59 | RFORM | RFORM | RFORM | CHAR | 2 | 0 | Formula Key | T418F | |
60 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
61 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
62 | KZVBR | KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
63 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
64 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
65 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
66 | PSPEL | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | * | |
67 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
68 | KZAUS | AUSLF | AUSLF | CHAR | 1 | 0 | Discontinuation type | ||
69 | NFEAG | CS_NFEAG | CHAR2 | CHAR | 2 | 0 | Discontinuation Group | ||
70 | NFGRP | CS_NFGRP | CHAR2 | CHAR | 2 | 0 | Follow-Up Group | ||
71 | NFPKZ | CS_KZNFP | XFELD | CHAR | 1 | 0 | Indicator: Follow-Up Item | ||
72 | NAFKZ | NAFKZ | XFELD | CHAR | 1 | 0 | Indicator: follow-up material active/not active | ||
73 | NOMNG | NOMNG | MENG13 | QUAN | 13 | 3 | Required quantity | ||
74 | NFUML | NFUML | NFUML | DEC | 5 | 4 | NOT USED: Quantity transfer factor for follow-up material | ||
75 | NOMAT | NOMAT | MATNR | CHAR | 18 | 0 | Follow-Up/Original Material | MARA | |
76 | LTXSP | LTXSP | SPRAS | LANG | 1 | 0 | Language: The long text was stored in this language | T002 | |
77 | POTX1 | POTX1 | TEXT40 | CHAR | 40 | 0 | BOM Item Text (Line 1) | ||
78 | POTX2 | POTX2 | TEXT40 | CHAR | 40 | 0 | BOM Item Text (Line 2) | ||
79 | PLNUM | PLNUM | PLNUM | CHAR | 10 | 0 | Planned order number | PLAF | |
80 | BANFN | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
81 | BNFPO | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | EBAN | |
82 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | EKKO | |
83 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
84 | EBELE | EETEN | EETEN | NUMC | 4 | 0 | Delivery Schedule Line Counter | EKET | |
85 | BAUGR | BAUGR | MATNR | CHAR | 18 | 0 | Material number of higher-level assembly | MARA | |
86 | BAUST | BAUST | AUFST | NUMC | 2 | 0 | Assembly order level | ||
87 | BAUWG | BAUWG | AUFWG | NUMC | 2 | 0 | Assembly order path | ||
88 | SERNR | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | SNUM | |
89 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
90 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
91 | STLTY | STLTY | STLTY | CHAR | 1 | 0 | BOM Category | ||
92 | STLNR | STNUM | STNUM | CHAR | 8 | 0 | Bill of Material | ||
93 | STLKN | STLKN | KNTNR | NUMC | 8 | 0 | BOM Item Node Number | ||
94 | STPOZ | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
95 | KZEAR | KZEAR | XFELD | CHAR | 1 | 0 | Final issue for this reservation | ||
96 | ENMNG | ENMNG | MENG13 | QUAN | 13 | 3 | Quantity withdrawn | ||
97 | SAKNR | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
98 | KZKUP | KZKUP | XFELD | CHAR | 1 | 0 | Indicator: Co-Product | ||
99 | STLAL | STALT | ALTNR | CHAR | 2 | 0 | Alternative BOM | ||
100 | STVKN | STVKN | KNTNR | NUMC | 8 | 0 | Inherited Node Number of BOM Item | ||
101 | PBDNR | PBDNR | CHAR10 | CHAR | 10 | 0 | Requirements Plan Number | ||
102 | VRPLA | VRPLA | XFELD | CHAR | 1 | 0 | Indicator: planning without final assembly | ||
103 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
104 | KZBWS | KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
105 | APLZL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
106 | TECHS | TECHS | TECHS | CHAR | 12 | 0 | Parameter Variant/Standard Variant | ||
107 | NLFZV | CS_NLFZV | NLFZT | DEC | 3 | 0 | Lead-time offset for operation | ||
108 | NLFMV | CS_NLFMV | MEINS | UNIT | 3 | 0 | Unit for lead-time offset for operation | T006 | |
109 | XFEHL | XFEHL | XFELD | CHAR | 1 | 0 | Pre-allocated stock | ||
110 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHA | |
111 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
112 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |