ERD
Tables (21)
Untitled2 (회사코드마스터)
- MANDT (Key) — Primary key — NOT NULL
- BUKRS (Key2) — Primary key — NOT NULL
- BUTXT (Key3) — NOT NULL
- LAND1 (Field)
- WAERS (Field2)
- KTOPL (Field3)
Untitled2 (종사업장 마스터)
- BUPLA (Key3) — Primary key — NOT NULL
- MANDT (Key) — Foreign key → Untitled2.MANDT — NOT NULL
- BUKRS (Key2) — Foreign key → Untitled2.BUKRS — NOT NULL
- NAME (Field)
- KR_REPRES (Field2)
- KR_BUSTYPE (Field3)
- KR_INDTYPE (Field4)
- STCD1 (Field5)
- ORT01 (Field6)
- STRAS (Field7)
Untitled2 (비용센터 마스터)
- Key3 — Primary key — NOT NULL
- MANDT (Key) — Foreign key → Untitled2.MANDT — NOT NULL
- BUKRS (Key2) — Foreign key → Untitled2.BUKRS — NOT NULL
- KTEXT (Field)
- PRCTR (Field2)
Untitled2 (직원 등급당 생산력 마스터)
- RATE (Key) — Primary key — NOT NULL
- CAPACITY (Field)
- CAPACITY_UNIT (Field2)
Untitled3 (직원)
- PERNR (Field) — Primary key
- BUPLA (Key3) — Foreign key → Untitled2.BUPLA — NOT NULL
- MANDT (Key) — Foreign key → Untitled2.MANDT — NOT NULL
- BUKRS (Key2) — Foreign key → Untitled2.BUKRS — NOT NULL
- ENAME (Field2)
- STELL (Field3)
- SALARY (Field4)
- BEGDA (Field5)
- ENDDA (Field6)
- STAT2 (Field7)
- IS_ENG (Field9)
- TELNR (Field10)
- RATE (Key4) — Foreign key → Untitled2.RATE — NOT NULL
Untitled4 (지역 마스터 테이블)
- ORTO1 (Key) — Primary key — NOT NULL
- REGION_TEXT (Field)
- REMARKS (Field2)
- STATUS (Field3)
ZCOM0100 (플랜트 마스터)
- MANDT (클라이언트) — Primary key — NOT NULL
- WERKS (플랜트(지사) 코드) — Primary key — NOT NULL
- NAME1 (Field)
- BWKEY (Field2)
- STRAS (Field3)
- PSTLZ (Field4)
- REGION_CODE (Field5)
- REGIO (Field6)
- LAND1 (Field7)
- TELF1 (Field8)
ZCUSTOMER_MASTER (Untitled2)
- KUNNR (Key) — Primary key — NOT NULL
- NAME1 (Field)
- STCD1 (Field2)
- LAND1 (Field3)
- REGIO (Field4)
- REGION_CODE (Field5)
- PSTLZ (Field6)
- STRAS (Field7)
- TELF1 (Field8)
- BRSCH (Field9)
- SAKNR (Field10)
ZDISTANCE_RATE (거리별 운송비 마스터)
- DISTANCE_RATE_ID (Key) — Primary key — NOT NULL
- VKBUR (Key2) — Primary key — NOT NULL
- ORTO1 (Key3) — Foreign key → Untitled4.ORTO1 — NOT NULL
- KBETR (Field)
- WAERS (Field2)
- DATAB (Field3)
- DATBI (Field4)
- STATUS (Field5)
ZGL (GL 계정 마스터)
- SAKNR (Key2) — Primary key — NOT NULL
- MANDT (Key) — Primary key — NOT NULL
- TXT20 (Field)
- XBILK (Field2)
- XOPVW (Field3)
- FSTAG (Field4)
ZINSTALL_RATE (설치비 마스터)
- INSTALL_RATE_ID (Key) — Primary key — NOT NULL
- FROM_M2 (Field)
- TO_MW (Field2)
- KBETR (Field3)
- KONWA (Field4)
- DATAB (Field5)
- DATBI (Field6)
- STATUS (Field7)
ZMM0100 (자재마스터)
- MANDT (Key) — Primary key — NOT NULL
- MATNR (Key2) — Primary key — NOT NULL
- MTART (Field)
- MTAKL (Field2)
- MEINS (Field3)
- BRGEW (Field4)
- GEWEI (Field5)
- GROES (Field6)
- MSTAE (Field7)
- ERSDA (Field8)
- ERNAM (Field9)
- LAEDA (Field10)
- AENAM (Field11)
- ZZRTKPZ (Field12)
- ZZTRUNT (Field13)
- ZZMFR (Field14)
- ZZMODEL (Field15)
- ZZWRTY (Field16)
ZMM0300 (공급업체 마스터)
- MANDT (Key) — Primary key — NOT NULL
- LIFNR (Key4) — Primary key — NOT NULL
- NAME1 (Field)
- LAND1 (Field2)
- REGION_CODE (Field3)
- STRAS (Field4)
- TELF1 (Field5)
- ZZBIZNO (Field6)
ZQRTQ_H (Untitled3)
- REQUEST_ID (Key) — Primary key — NOT NULL
ZQRTQ_I (CopyOfUntitled3)
- POSNR (Key) — Primary key — NOT NULL
- REQUEST_ID (Key2) — Foreign key → ZQRTQ_H.REQUEST_ID — NOT NULL
ZQUOTATION_H (CopyOfUntitled32)
- VBELN_Q (Key) — Primary key — NOT NULL
- REQUEST_ID (Key2) — Foreign key → ZQRTQ_H.REQUEST_ID — NOT NULL
ZQUOTATION_I (A)
- POSNR (Key) — Primary key — NOT NULL
- VBELN_Q (Key3) — Foreign key → ZQUOTATION_H.VBELN_Q — NOT NULL
- MANDT (Key2) — Foreign key → ZMM0100.MANDT — NOT NULL
- MATNR (Key22) — Foreign key → ZMM0100.MATNR — NOT NULL
ZROUTE (Untitled)
- ROUTE_ID (Key) — Primary key — NOT NULL
- FROM_TYPE (Key2) — NOT NULL
- FROM_ID (Key3) — NOT NULL
- TO_TYPE (Field)
- TO_ID (Field2)
- EST_TRANSIT_DAYS (Field3)
- USE_YN (Field4)
ZSALES_ORG (Untitled4)
- VKORG (Key) — Primary key — NOT NULL
- MANDT (Key2) — Foreign key → Untitled2.MANDT — NOT NULL
- BUKRS (Key22) — Foreign key → Untitled2.BUKRS — NOT NULL
ZSO_H (SO 헤더)
- VBELN (Key) — Primary key — NOT NULL
- VKORG (Key2) — Foreign key → ZSALES_ORG.VKORG — NOT NULL
- KUNNR (Key3) — Foreign key → ZCUSTOMER_MASTER.KUNNR — NOT NULL
ZSO_I (SO아이템)
- POSNR (Key) — Primary key — NOT NULL
- VBELN (Key2) — Foreign key → ZSO_H.VBELN — NOT NULL
- MANDT (Key3) — Foreign key → ZMM0100.MANDT — NOT NULL
- MATNR (Key22) — Foreign key → ZMM0100.MATNR — NOT NULL