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