erd1

Tables (6)

T000 (Untitled)

  • MANDT (Key) — Primary key — NOT NULL
  • MTEXT (Field)
  • ORT01 (Field2)
  • MWAWER (Field3)

YTADDR (Untitled5)

  • MANDT (Key) — Primary key — NOT NULL
  • PERNR (Key2) — Primary key — NOT NULL
  • MANDT (Key3) — Foreign key → T000.MANDT — NOT NULL
  • MANDT (Key4) — Foreign key → YTEMPLOYEE.MANDT — NOT NULL
  • PERNR (Key22) — Foreign key → YTEMPLOYEE.PERNR — NOT NULL
  • MANDT (Key32) — Foreign key → YTEMPLOYEE.MANDT — NOT NULL
  • HOME (Field)
  • OFFICE (Field2)

YTCONT (Untitled6)

  • MADNT (Key) — Primary key — NOT NULL
  • PERNR (Key2) — Primary key — NOT NULL
  • MANDT (Key3) — Foreign key → T000.MANDT — NOT NULL
  • MANDT (Key4) — Foreign key → YTEMPLOYEE.MANDT — NOT NULL
  • PERNR (Key22) — Foreign key → YTEMPLOYEE.PERNR — NOT NULL
  • MANDT (Key32) — Foreign key → YTEMPLOYEE.MANDT — NOT NULL
  • CELL (Field)
  • TELL (Field2)
  • EMAIL (Field3)

YTEMPLOYEE (Untitled4)

  • MANDT (Key) — Primary key — NOT NULL
  • PERNR (Key2) — Primary key — NOT NULL
  • MANDT (Key3) — Foreign key → T000.MANDT — NOT NULL

YTORGEH (Untitled2)

  • MANDT (Key) — Primary key — NOT NULL
  • ORGEH (Key2) — Primary key — NOT NULL
  • MANDT (Key3) — Foreign key → T000.MANDT — NOT NULL
  • CHIEF (Field)

YTORGEHT (Untitled3)

  • MANDT (Key) — Primary key — NOT NULL
  • ORGEH (Key2) — Primary key — NOT NULL
  • LANGU (Key3) — Primary key — NOT NULL
  • MANDT (Key4) — Foreign key → YTORGEH.MANDT — NOT NULL
  • ORGEH (Key22) — Foreign key → YTORGEH.ORGEH — NOT NULL
  • MANDT (Key32) — Foreign key → YTORGEH.MANDT — NOT NULL
  • MANDT (Key5) — Foreign key → T000.MANDT — NOT NULL
  • OTEXT (Field)