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)