SAP ABAP Table MDSM_BERID (MDSM Extended by MRP Area)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ MM-CBP (Application Component) Consumption-Based Planning (See Also PP-MRP)
⤷ MD06 (Package) Development Material Requirements Planning
⤷ MM-CBP (Application Component) Consumption-Based Planning (See Also PP-MRP)
⤷ MD06 (Package) Development Material Requirements Planning
Basic Data
Table Category | INTTAB | Structure |
Structure | MDSM_BERID | Table Relationship Diagram |
Short Description | MDSM Extended by MRP Area |
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 | Simulative dependent requirements | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | SBNUM | SBNUM | SBNUM | NUMC | 10 | 0 | Simulation requirements number | * | |
4 | SBPOS | SBPOS | RSPOS | NUMC | 4 | 0 | Simulation requirements item number | ||
5 | SBART | 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 | PLSCN | PLSCN | PLSCN | NUMC | 3 | 0 | Planning Scenario of Long-Term Planning | PLSC | |
11 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
12 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
13 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
14 | PRVBE | PRVBE | PRVBE | CHAR | 10 | 0 | Production Supply Area | PVBE | |
15 | BDART | BDART | BDART | CHAR | 2 | 0 | Requirement type | ||
16 | POSTP | POSTP | POSTP | CHAR | 1 | 0 | Item category (bill of material) | T418 | |
17 | UPSKZ | UPSKZ | XFELD | CHAR | 1 | 0 | Indicator: Subitems Exist | ||
18 | SCHGT | SCHGT | XFELD | CHAR | 1 | 0 | Indicator: bulk material | ||
19 | TXTPS | TXTPS | XFELD | CHAR | 1 | 0 | Item text indicator | ||
20 | INPOS | INPOS | XFELD | CHAR | 1 | 0 | Indicator: intra material | ||
21 | DUMPS | DUMPS | XFELD | CHAR | 1 | 0 | Phantom item indicator | ||
22 | KFPOS | KFPOS | XFLAG | CHAR | 1 | 0 | Indicator: "configurable item" | ||
23 | NODSP | NODISP | XFELD | CHAR | 1 | 0 | Ind: Reserv. not applicable to MRP;Purc. req. not created | ||
24 | DBSKZ | DBSKZ | DBSKZ | CHAR | 1 | 0 | Direct procurement indicator | ||
25 | BDMNG | BDMNG | MENG13 | QUAN | 13 | 3 | Requirement Quantity | ||
26 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
27 | ESMNG | ESMNG | ESMNG | FLTP | 16 | 16 | Usage quantity per order unit of measure | ||
28 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
29 | BEIKZ | BEIKZ | BEIKZ | CHAR | 1 | 0 | Material Provision Indicators | T417 | |
30 | ERSKZ | ERSKZ | ERSKZ | CHAR | 1 | 0 | Indicator: Spare Part | T413 | |
31 | ERFMG | ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry | ||
32 | ERFME | ERFME | MEINS | UNIT | 3 | 0 | Unit of entry | T006 | |
33 | UMREZ | UMREZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion to Base Units of Measure | ||
34 | UMREN | UMREN | UMBSN | DEC | 5 | 0 | Denominator for conversion to base units of measure | ||
35 | FMENG | FMENG | XFELD | CHAR | 1 | 0 | Quantity is fixed | ||
36 | ALPOS | ALTPS | XFELD | CHAR | 1 | 0 | Alternative item indicator | ||
37 | EWAHR | EWAHR | DEC3 | DEC | 3 | 0 | Usage Probability in % (Alternative Item) | ||
38 | ALPGR | CS_ALPGR | CHAR2 | CHAR | 2 | 0 | Alternative Item: Group | ||
39 | ALPRF | CS_ALPRF | NUM2 | NUMC | 2 | 0 | Alternative Item: Ranking Order | ||
40 | ALPST | CS_ALPST | CS_ALPST | CHAR | 1 | 0 | Alternative Item: Strategy | ||
41 | AUSCH | KAUSF | DEC3_2 | DEC | 5 | 2 | Component scrap in percent | ||
42 | AVOAU | AVOAU | DEC3_2 | DEC | 5 | 2 | Operation Scrap | ||
43 | NETAU | NETAU | XFELD | CHAR | 1 | 0 | Indicator: Net Scrap | ||
44 | BDTER | BDTER | DATUM | DATS | 8 | 0 | Requirements date for the component | ||
45 | SBTER | SBTER | DATUM | DATS | 8 | 0 | Latest requirements date | ||
46 | VERTI | SA_VERTL | SA_VERTL | CHAR | 4 | 0 | MRP Distribution Key | * | |
47 | NLFZT | NLFZT | NLFZT | DEC | 3 | 0 | Lead-Time Offset | ||
48 | BDZTP | BDZTP | BDZTP | TIMS | 6 | 0 | Time that reservation quantity required | ||
49 | ROHPS | ROHPS | XFELD | CHAR | 1 | 0 | Variable-sized item indicator | ||
50 | ROANZ | ROANZ | MENG13 | QUAN | 13 | 3 | Number of Variable-Size Items | ||
51 | ROMEN | ROMEN | MENG13 | QUAN | 13 | 3 | VarSizeItem Qty | ||
52 | ROMEI | ROMEI | MEINS | UNIT | 3 | 0 | Unit of measure for sizes 1 to 3 | T006 | |
53 | ROMS1 | ROMS1 | MENG13 | QUAN | 13 | 3 | Size 1 | ||
54 | ROMS2 | ROMS2 | MENG13 | QUAN | 13 | 3 | Size 2 | ||
55 | ROMS3 | ROMS3 | MENG13 | QUAN | 13 | 3 | Size 3 | ||
56 | RFORM | RFORM | RFORM | CHAR | 2 | 0 | Formula Key | T418F | |
57 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
58 | NFPKZ | CS_KZNFP | XFELD | CHAR | 1 | 0 | Indicator: Follow-Up Item | ||
59 | KZAUS | KZAUS | KZAUS | CHAR | 1 | 0 | Discontinuation indicator | ||
60 | NFEAG | CS_NFEAG | CHAR2 | CHAR | 2 | 0 | Discontinuation Group | ||
61 | NFGRP | CS_NFGRP | CHAR2 | CHAR | 2 | 0 | Follow-Up Group | ||
62 | NAFKZ | NAFKZ | XFELD | CHAR | 1 | 0 | Indicator: follow-up material active/not active | ||
63 | NOMNG | NOMNG | MENG13 | QUAN | 13 | 3 | Required quantity | ||
64 | NOMAT | NOMAT | MATNR | CHAR | 18 | 0 | Follow-Up/Original Material | * | |
65 | NFUML | NFUML | NFUML | DEC | 5 | 4 | NOT USED: Quantity transfer factor for follow-up material | ||
66 | LTXSP | LTXSP | SPRAS | LANG | 1 | 0 | Language: The long text was stored in this language | T002 | |
67 | POTX1 | POTX1 | TEXT40 | CHAR | 40 | 0 | BOM Item Text (Line 1) | ||
68 | POTX2 | POTX2 | TEXT40 | CHAR | 40 | 0 | BOM Item Text (Line 2) | ||
69 | PLNUM | PLNUM | PLNUM | CHAR | 10 | 0 | Planned order number | PLAF | |
70 | BAUGR | BAUGR | MATNR | CHAR | 18 | 0 | Material number of higher-level assembly | MARA | |
71 | BAUST | BAUST | AUFST | NUMC | 2 | 0 | Assembly order level | ||
72 | BAUWG | BAUWG | AUFWG | NUMC | 2 | 0 | Assembly order path | ||
73 | SERNR | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | * | |
74 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
75 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
76 | STLTY | STLTY | STLTY | CHAR | 1 | 0 | BOM Category | ||
77 | STLNR | STNUM | STNUM | CHAR | 8 | 0 | Bill of Material | ||
78 | STLKN | STLKN | KNTNR | NUMC | 8 | 0 | BOM Item Node Number | ||
79 | STPOZ | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
80 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
81 | FLGAT | FOLGENART | FLGAT | CHAR | 1 | 0 | Sequence category | TCA07 | |
82 | PLNFL | PLNFOLGE | PLNFOLGE | CHAR | 6 | 0 | Sequence | ||
83 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
84 | APLZL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
85 | STVKN | STVKN | KNTNR | NUMC | 8 | 0 | Inherited Node Number of BOM Item | ||
86 | VRPLA | VRPLA | XFELD | CHAR | 1 | 0 | Indicator: planning without final assembly | ||
87 | PBDNR | PBDNR | CHAR10 | CHAR | 10 | 0 | Requirements Plan Number | ||
88 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
89 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
90 | KZVBR | KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
91 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
92 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
93 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
94 | PSPEL | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | PRPS | |
95 | CLAKZ | CLAKZ | XFELD | CHAR | 1 | 0 | Indicator: classification exists | ||
96 | SANKA | SANKA | KAREL | CHAR | 1 | 0 | Indicator: item relevant to costing | ||
97 | KZKUP | KZKUP | XFELD | CHAR | 1 | 0 | Indicator: Co-Product | ||
98 | STLAL | STLAL | ALTNR | CHAR | 2 | 0 | Alternative BOM | ||
99 | TECHS | TECHS | TECHS | CHAR | 12 | 0 | Parameter Variant/Standard Variant | ||
100 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
101 | EDGNO | EDGNO | EDGNO | NUMC | 17 | 0 | Internal number for edge of object dependencies tree | M60I | |
102 | NLFZV | CS_NLFZV | NLFZT | DEC | 3 | 0 | Lead-time offset for operation | ||
103 | NLFMV | CS_NLFMV | MEINS | UNIT | 3 | 0 | Unit for lead-time offset for operation | * | |
104 | KZBWS | KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
105 | BERID | BERID | BERID | CHAR | 10 | 0 | MRP Area | * | |
106 | BERTY | BERTY | BERTY | NUMC | 2 | 0 | Type of MRP area |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |