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