P3

Tables (4)

Untitled (T000)

  • Key (MANDT) — CLIENT — Primary key — NOT NULL
  • Field (MTEXT) — CHAR
  • Field (ORT01) — CHAR
  • Field (MWAER) — CUKY
  • Field (ADRNR) — CHAR
  • Field (CCCATEGORY) — CHAR
  • Field (CCCORACTIV) — CHAR
  • Field (CCNOCLIIND) — CHAR
  • Field (CCCOPYLOCK) — CHAR
  • Field (CCNOCASCAD) — CHAR
  • Field (CCTEMPLOCK) — CHAR
  • Field (CCORIGCONT) — CHAR
  • Field (CCIMAILDIS) — CHAR
  • Field (CHANGEUSER) — CHAR
  • Field (CHANGEDATE) — DATS
  • Field (LOGSYS) — CHAR

Untitled (SCARR)

  • Field (CARRID) — CHAR — Primary key
  • Key (MENDT) — CLIENT — Primary key — NOT NULL
  • Key (MANDT2) — CLIENT — Foreign key → Untitled.Key — NOT NULL
  • Field (CARRNAME) — CHAR
  • Field (CURRCODE) — CUKY
  • Field (S_CARRURL) — CHAR

Untitled (YTEMPLOYEE)

  • Key2 (PERNR) — NYMC — Primary key — NOT NULL
  • Key3 (ORGEH) — NUMC — Primary key — NOT NULL
  • Key (MANDT) — CLIENT — Primary key — NOT NULL
  • Key (MANDT2) — CLIENT — Foreign key → Untitled.Key — NOT NULL
  • Field (PNAME) — char
  • Field (GBDAT) — DATS
  • Field (GENDER) — CHAR
  • Field (ISMANAGER) — CHAR

Untitled (YEMENUREQ)

  • Key2 (CARRID) — CHAR — Primary key — NOT NULL
  • Key (MANAGER) — NYMC — Primary key — NOT NULL
  • Key2 (REQID) — NUMC — Primary key — NOT NULL
  • Key (MANDT) — CLIENT — Primary key — NOT NULL
  • Key (MANDT2) — CLIENT — Foreign key → Untitled.Key — NOT NULL
  • Key2 (PERNR) — NYMC — Foreign key → Untitled.Key2 — NOT NULL
  • Field (CARRID2) — CHAR — Foreign key → Untitled.Field
  • Field (BOOKID) — NUMC
  • Field2 (MENUNUMBER) — NUMC
  • Field (REQDT) — DATS
  • Field2 (CANCELLED) — CHAR