SD process

Tables (17)

billing type (Untitled10)

  • sales order type (Key2) — Foreign key → delivery order type.sales order type — NOT NULL

company code (회사코드)

  • companycode (Key) — Primary key — NOT NULL

delivery item category (Untitled11)

  • item category (Key) — Foreign key → item category.item category — NOT NULL
  • item category group (Key3) — Foreign key → item category.item category group — NOT NULL
  • sales order type (Key2) — Foreign key → item category.sales order type — NOT NULL
  • item category (Key4) — Foreign key → item category.item category — NOT NULL

delivery order type (Untitled9)

  • sales order type (Key) — Foreign key → sales order type.sales order type — NOT NULL

distri chan (Untitled)

  • distri chan (Key) — Primary key — NOT NULL
  • sales org (Key2) — Foreign key → sales area.sales area — NOT NULL

division (Untitled2)

  • division (Key) — Primary key — NOT NULL
  • sales org (Key2) — Foreign key → sales area.sales area — NOT NULL

higher item category (Untitled13)

  • item category (Key) — Primary key — NOT NULL

item category (Untitled8)

  • item category (Key) — Primary key — NOT NULL
  • item category group (Key3) — Foreign key → material master.item category group — NOT NULL
  • sales order type (Key2) — Foreign key → sales order type.sales order type — NOT NULL
  • item category (Key4) — Foreign key → higher item category.item category — NOT NULL

material master (Untitled12)

  • item category group (Key) — Primary key — NOT NULL
  • mrp type (Key2) — Primary key — NOT NULL

plant (Untitled4)

  • plant (Key) — Primary key — NOT NULL
  • sales org (Key2) — Foreign key → sales org.sales org — NOT NULL
  • distri chan (Key3) — Foreign key → distri chan.distri chan — NOT NULL

sales area (Untitled3)

  • sales area (Key) — Primary key — NOT NULL

sales order (Untitled6)

  • item (Key2) — Primary key — NOT NULL
  • header (Key) — Primary key — NOT NULL
  • sales order type (Key3) — Foreign key → sales order type.sales order type — NOT NULL
  • sales area (Key4) — Foreign key → sales area.sales area — NOT NULL

sales order type (Untitled7)

  • sales order type (Key) — Primary key — NOT NULL

sales org (사업영역)

  • sales org (Key) — Primary key — NOT NULL
  • companycode (Key4) — Foreign key → company code.companycode — NOT NULL

schedule line category (Untitled15)

  • schedule line category (Key) — Primary key — NOT NULL
  • mrp type (Key22) — Foreign key → material master.mrp type — NOT NULL
  • item category (Key4) — Foreign key → item category.item category — NOT NULL

shpping point (Untitled14)

  • shipping point (Key) — Primary key — NOT NULL
  • schedule line category (Key2) — Foreign key → schedule line category.schedule line category — NOT NULL
  • mrp type (Key22) — Foreign key → schedule line category.mrp type — NOT NULL
  • item category (Key4) — Foreign key → schedule line category.item category — NOT NULL
  • plant (Key3) — Foreign key → plant.plant — NOT NULL

storage location (Untitled5)

  • division (Key) — Primary key — NOT NULL
  • plant (Key2) — Foreign key → plant.plant — NOT NULL