SAP ABAP Table S2L_PLNG_ITEM_CALC_DETAILS (Details for Planning Item with Missing Qty Calculation Data)
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷ IS-A-S2L (Application Component) Production Supply
⤷ DI_S2L (Package) Production Supply
⤷ IS-A-S2L (Application Component) Production Supply
⤷ DI_S2L (Package) Production Supply
Basic Data
Table Category | INTTAB | Structure |
Structure | S2L_PLNG_ITEM_CALC_DETAILS | Table Relationship Diagram |
Short Description | Details for Planning Item with Missing Qty Calculation Data |
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 | CALC_ORDER | S2L_CALC_ORDER | NUMC | 6 | 0 | Check Sequence: Counter for Sorting | |||
2 | .INCLUDE | 0 | 0 | Details for Planning Item | |||||
3 | .INCLUDE | 0 | 0 | Details for Planning Element | |||||
4 | .INCLUDE | 0 | 0 | Details for Stock Type | |||||
5 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
6 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | MARC | |
7 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | MARD | |
8 | PRVBE | PRVBE | PRVBE | CHAR | 10 | 0 | Production Supply Area | PVBE | |
9 | .INCLUDE | 0 | 0 | Stock Key for WM Storage Bin | |||||
10 | LGNUM | LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | * | |
11 | LGTYP | LGTYP | LGTYP | CHAR | 3 | 0 | Storage Type | * | |
12 | LGPLA | LGPLA | LGPLA | CHAR | 10 | 0 | Storage Bin | * | |
13 | .INCLUDE | 0 | 0 | Stock Key for Reservation | |||||
14 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
15 | RSPOS | RSPOS | RSPOS | NUMC | 4 | 0 | Item Number of Reservation / Dependent Requirements | ||
16 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
17 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
18 | KDAUF | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
19 | KDPOS | POSNR | POSNR | NUMC | 6 | 0 | Item number of the SD document | * | |
20 | PSPNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
21 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
22 | .INCLUDE | 0 | 0 | Detailed Data for Planning Record | |||||
23 | RECORD_TYPE | S2L_PLNG_RECORD_TYPE | S2L_PLNG_RECORD_TYPE | CHAR | 2 | 0 | Type of Planning Object | ||
24 | EXTERNAL_ID | S2L_PREC_EXTID | S2L_PREC_EXTID | CHAR | 20 | 0 | Number of Planning Element | ||
25 | FIRMING_IND | S2L_FIRMING_IND | S2L_FIRMING_IND | CHAR | 1 | 0 | Firming Indicator for Replenishment Proposals | ||
26 | SEQNO | S2L_SEQNO | INT4 | INT4 | 10 | 0 | Number of Takts until Assembly of Components | ||
27 | SERIALIZED | S2L_SERIALIZED | XFELD | CHAR | 1 | 0 | Requirement is Serialized | ||
28 | .INCLUDE | 0 | 0 | Additional Details for Planning Element | |||||
29 | ELEMENT_TYPE | S2L_PLNG_ELEMENT_TYPE | S2L_PLNG_ELEMENT_TYPE | CHAR | 2 | 0 | Type of Planning Element | ||
30 | ELEMENT_TYPE_ABBRV | S2L_PELM_TYPE_ABBRV | S2L_PELM_TYPE_ABBRV | CHAR | 6 | 0 | Short Name of Planning Element | ||
31 | ELEMENT_TYPE_TXT | S2L_PELM_TYPE_TXT | S2L_PELM_TYPE_TXT | CHAR | 40 | 0 | Name for Planning Element | ||
32 | PLN_TOTAL | S2L_PELM_PLN_TOTAL | S2L_QUANTITY | QUAN | 15 | 3 | Total Requirements/Receipt Quantity of a Planning Element | ||
33 | EFF_TOTAL | S2L_PELM_EFF_TOTAL | S2L_QUANTITY | QUAN | 15 | 3 | Proportion of Requirement/Received Qty Relevant for Planning | ||
34 | UNIT | S2L_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure | * | |
35 | PLN_BEGIN_DATE | S2L_PELM_PLN_BEGIN_DATE | DATE | DATS | 8 | 0 | Requirements/Receipt Date of Planning Element | ||
36 | PLN_BEGIN_TIME | S2L_PELM_PLN_BEGIN_TIME | TIME | TIMS | 6 | 0 | Requirement/Receipt Time of Planning Element | ||
37 | PLN_END_DATE | S2L_PELM_PLN_END_DATE | DATE | DATS | 8 | 0 | Requirement/Receipt Finish Date of Planning Element | ||
38 | PLN_END_TIME | S2L_PELM_PLN_END_TIME | TIME | TIMS | 6 | 0 | Requirement/Receipt Finish Time of Planning Element | ||
39 | TZONE | TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone | * | |
40 | .INCLUDE | 0 | 0 | Additional Details for Planning Item | |||||
41 | QUANTITY | S2L_PITEM_QUANTITY | S2L_QUANTITY | QUAN | 15 | 3 | Requirment/Receipt Quantity of Planning Item | ||
42 | PLN_DATE | S2L_PITEM_PLN_DATE | DATE | DATS | 8 | 0 | Requirement/Receipt Date of Planning Item | ||
43 | PLN_TIME | S2L_PITEM_PLN_TIME | TIME | TIMS | 6 | 0 | Requirement/Receipt Time of Planning Item | ||
44 | EFF_DATE | S2L_PITEM_EFF_DATE | DATE | DATS | 8 | 0 | Effective Requirement/Receipt Date of Planning Item | ||
45 | EFF_TIME | S2L_PITEM_EFF_TIME | TIME | TIMS | 6 | 0 | Effective Requirement/Receipt Time of Planning Item | ||
46 | MIN_STOCK | S2L_MIN_STOCK | S2L_UQUANTITY | QUAN | 15 | 3 | Minimum Stock for Automatic Supply-to-Production | ||
47 | AVAILABLE_STOCK_P | S2L_AVAILABLE_STOCK | S2L_QUANTITY | QUAN | 15 | 3 | Available Stock | ||
48 | MISS_QTY_PURE_P | S2L_MISS_QTY_PURE | S2L_UQUANTITY | QUAN | 15 | 3 | Real Missing Quantity | ||
49 | MISS_QTY_MIN_P | S2L_MISS_QTY_MIN | S2L_UQUANTITY | QUAN | 15 | 3 | Below Minimum Stock Level | ||
50 | MISS_QTY_P | S2L_MISS_QTY | S2L_UQUANTITY | QUAN | 15 | 3 | Missing Quantity | ||
51 | CUM_MISS_QTY_P | S2L_CUM_MISS_QTY | S2L_UQUANTITY | QUAN | 15 | 3 | Total Missing Quantity | ||
52 | CUM_MISS_QTY_1_P | S2L_CUM_MISS_QTY_1 | S2L_UQUANTITY | QUAN | 15 | 3 | Cumulated Missing Quantity Without Temporary Shortages | ||
53 | AVAILABLE_STOCK_R | S2L_AVAILABLE_STOCK_R | S2L_QUANTITY | QUAN | 15 | 3 | Available Stock with Replenishment Proposals | ||
54 | MISS_QTY_PURE_R | S2L_MISS_QTY_PURE_R | S2L_UQUANTITY | QUAN | 15 | 3 | Real Missing Quantity with Replenishment Proposals | ||
55 | MISS_QTY_MIN_R | S2L_MISS_QTY_MIN_R | S2L_UQUANTITY | QUAN | 15 | 3 | Below Minimum Stock Level with Replenishment Proposals | ||
56 | MISS_QTY_R | S2L_MISS_QTY_R | S2L_UQUANTITY | QUAN | 15 | 3 | Missing Quantity Taking Replenishment Proposals into Account | ||
57 | CUM_MISS_QTY_R | S2L_CUM_MISS_QTY_R | S2L_UQUANTITY | QUAN | 15 | 3 | Total Missing Quantity with Replenishment Proposals | ||
58 | CUM_MISS_QTY_1_R | S2L_CUM_MISS_QTY_1_R | S2L_UQUANTITY | QUAN | 15 | 3 | Cumul.Missing Qty w/o Temporary Shortages w.Replen.Proposals |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | S2L_PLNG_ITEM_CALC_DETAILS | CHARG | MCH1 | CHARG | KEY | 1 | CN |
2 | S2L_PLNG_ITEM_CALC_DETAILS | LGORT | MARD | LGORT | KEY | 1 | CN |
3 | S2L_PLNG_ITEM_CALC_DETAILS | LIFNR | LFA1 | LIFNR | KEY | 1 | CN |
4 | S2L_PLNG_ITEM_CALC_DETAILS | MATNR | MARA | MATNR | KEY | 1 | CN |
5 | S2L_PLNG_ITEM_CALC_DETAILS | PRVBE | PVBE | PRVBE | KEY | 1 | CN |
6 | S2L_PLNG_ITEM_CALC_DETAILS | PSPNR | PRPS | PSPNR | KEY | 1 | CN |
7 | S2L_PLNG_ITEM_CALC_DETAILS | WERKS | MARC | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C2 |