PP(full)
Tables (6)
ZPP_BOM_HEAD (ZTC2PP0001)
- BOM_NO — CHAR(8) — Primary key — NOT NULL
- PLANT_CD — CHAR(4) — Primary key — NOT NULL
- BOM_USAGE — CHAR(1) — Primary key — NOT NULL
- VALID_FROM — DATE — Primary key — NOT NULL
- PARENT_MATL — CHAR(18)
- VALID_TO — DATE
- BASE_QTY — DEC(13,3)
- BASE_UOM — UNIT(3)
- BOM_STATUS — CHAR(2)
ZPP_BOM_ITEM (ZTC2PP0002)
- BOM_NO — CHAR(8) — Primary key — Foreign key → ZPP_BOM_HEAD.BOM_NO — NOT NULL
- ITEM_NO — NUMC(4) — Primary key — NOT NULL
- CHILD_MATL — CHAR(18)
- ITEM_QTY — DEC(13,3)
- ITEM_UOM — UNIT(3)
- ITEM_CATEGORY — CHAR(1)
- SCRAP_PCT — DEC(5,2)
- FIXED_QTY_FLG — CHAR(1)
- VALID_FROM — DATE
- VALID_TO — DATE
- OPER_NO — NUMC(4) — Foreign key → ZPP_ROUTING_OPER.OPER_NO
- LEAD_TIME_OFFSET — DEC(5,1)
- SORT_STR — CHAR(18)
- ITEM_NOTE — CHAR(40)
ZPP_CONF (ZTC2PP0006)
- CONF_NO — CHAR(12) — Primary key — NOT NULL
- CONF_ITEM — NUMC(3) — Primary key — NOT NULL
- ORDER_NO — CHAR(12) — Foreign key → ZPP_ORDER.ORDER_NO
- OPER_NO — NUMC(4) — Foreign key → ZPP_ROUTING_OPER.OPER_NO
- MATL_CODE — CHAR(18)
- PLANT_CD — CHAR(4)
- SLOC_CD — CHAR(4)
- WORKCENTER_CD — CHAR(8)
- CONF_QTY — DEC(13,3)
- SCRAP_QTY — DEC(13,3)
- REWORK_QTY — DEC(13,3)
- BASE_UOM — UNIT(3)
- ACTUAL_SETUP_TIME — DEC(9,2)
- ACTUAL_MACHINE_TIME — DEC(9,2)
- ACTUAL_LABOR_TIME — DEC(9,2)
- TIME_UOM — UNIT(3)
- CONF_DATE — DATE
- CONF_TIME — TIME
- POSTING_DATE — DATE
- COST_CTR — CHAR(10)
- COST_ELEM — CHAR(10)
- ACTUAL_COST — DEC(15,2)
- REVERSAL_FLG — CHAR(1)
- REVERSAL_CONF_NO — CHAR(12)
- GR_DOC_NO — CHAR(10)
- CO_DOC_NO — CHAR(10)
ZPP_ORDER (ZTC2PP0005)
- ORDER_NO — CHAR(12) — Primary key — NOT NULL
- ORDER_TYPE — CHAR(4)
- MATL_CODE — CHAR(18)
- PLANT_CD — CHAR(4)
- SLOC_CD — CHAR(4)
- BOM_NO — CHAR(8) — Foreign key → ZPP_BOM_HEAD.BOM_NO
- ROUTING_NO — CHAR(8) — Foreign key → ZPP_ROUTING_HEAD.ROUTING_NO
- PLAN_QTY — DEC(13,3)
- CONF_QTY — DEC(13,3)
- SCRAP_QTY — DEC(13,3)
- BASE_UOM — UNIT(3)
- PLAN_START — DATETIME
- PLAN_END — DATETIME
- ACTUAL_START — DATETIME
- ACTUAL_END — DATETIME
- ORDER_STATUS — CHAR(2)
- PRIORITY — CHAR(2)
- COST_CTR — CHAR(10)
- COST_ELEM — CHAR(10)
- STD_COST — DEC(15,2)
- ACTUAL_COST — DEC(15,2)
- PARENT_ORDER_NO — CHAR(12) — Foreign key → ZPP_ORDER.ORDER_NO
- SO_NO — CHAR(10)
- FI_DOC_NO — CHAR(10)
ZPP_ROUTING_HEAD (ZTC2PP0003)
- ROUTING_NO — CHAR(8) — Primary key — NOT NULL
- PLANT_CD — CHAR(4) — Primary key — NOT NULL
- ROUTING_USAGE — CHAR(1) — Primary key — NOT NULL
- VALID_FROM — DATE — Primary key — NOT NULL
- MATL_CODE — CHAR(18)
- VALID_TO — DATE
- BASE_QTY — DEC(13,3)
- BASE_UOM — UNIT(3)
- ROUTING_STATUS — CHAR(2)
ZPP_ROUTING_OPER (ZTC2PP0004)
- ROUTING_NO — CHAR(8) — Primary key — Foreign key → ZPP_ROUTING_HEAD.ROUTING_NO — NOT NULL
- OPER_NO — NUMC(4) — Primary key — NOT NULL
- OPER_NAME — CHAR(40)
- WORKCENTER_CD — CHAR(8)
- CONTROL_KEY — CHAR(4)
- SETUP_TIME — DEC(9,2)
- MACHINE_TIME — DEC(9,2)
- LABOR_TIME — DEC(9,2)
- WAIT_TIME — DEC(9,2)
- TIME_UOM — UNIT(3)
- COST_ELEM — CHAR(10)
- COST_CTR — CHAR(10)
- SUBCON_VENDOR — CHAR(10)
- SCRAP_PCT — DEC(5,2)
- USER_FIELD_1 — CHAR(20)