p3 캡스톤

테이블 (10)

T000

  • MANDT — CLNT — 기본 키 — NOT NULL
  • MTEXT (MTEXT_D) — CHAR
  • ORT01 — CHAR
  • MWEAR — CUKY
  • ADRNR (CHAR10) — CHAR
  • CCCATEGORY — CHAR
  • CCCORACTIY — CHAR
  • CCNOCLIIND — CHAR
  • CCCOPYLOCK — CHAR
  • CCNOCASCAD — CHAR
  • CCSOFTLOCK — CHAR
  • CCORIGCONT — CHAR
  • CCIMAILDIS — CHAR
  • CCTEMPLOCK — CHAR
  • CHANGEUSER (AS4USER) — CHAR
  • CHANGEDATE (AS4DATE) — DATS
  • LOGSYS — CHAR

Untitled (YLOG_321(STRUCTURE))

  • Field (ERDAT) — DATS
  • Field2 (ERZET) — TIMS
  • Field3 (ERNAM) — CHAR
  • Field4 (AEDAT) — DATS
  • Field (AEZET) — TIMS
  • Field (AENAM) — CHAR

Untitled (T527X)

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • Key2 (SPRSL) — LANG — 기본 키 — NOT NULL
  • Key3 (ORGEH) — NUMC — 기본 키 — NOT NULL
  • Key4 (ENDDA) — DATS — 기본 키 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Key3 (ORGEH2) — NUMC — 외래 키 → YTEMPLOYEE_321.Key3 — NOT NULL
  • Field (BEGDA) — CHAR
  • Field (ORGTX) — CHAR
  • Field (MAINT) — CHAR

Untitled (YTMENUREQ_321)

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • Key2 (CARRID) — CHAR — 기본 키 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Key2 (PERNR) — NUMC — 외래 키 → YTEMPLOYEE_321.Key2 — NOT NULL
  • Field (BOOKID) — NUMC
  • Field (MANAGER) — NUMC
  • Field (REQID) — NUMC
  • Field (MENUNUMBER) — NUMC
  • Field (REQDT) — DATS
  • Field (CANCELLED) — CHAR
  • Field (.INCLUDE) — STRU

Untitled (SCARR)

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • Key2 (CARRIDS) — CHAR — 기본 키 — NOT NULL
  • Key2 (CARRID2) — CHAR — 외래 키 → Untitled.Key2 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Field (CARRNAME) — CHAR
  • Field (CURRCODE) — CUKY
  • Field (URL) — CHAR

Untitled (YTORGEH_321)

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • Key2 (ORGEH) — NUMC — 기본 키 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Key2 (CHEIF2) — NUMC — 외래 키 → YTEMPLOYEE_321.Key2 — NOT NULL
  • Key3 (ORGEH2) — NUMC — 외래 키 → YTEMPLOYEE_321.Key3 — NOT NULL
  • Field (CHEIF) — NUMC
  • Field (.INCLUDE) — STRU

Untitled (YTORGEHT_321)

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • Key2 (ORGEH) — NUMC — 기본 키 — NOT NULL
  • Key3 (LANGU) — LANG — 기본 키 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Key3 (ORGEH2) — NUMC — 외래 키 → YTEMPLOYEE_321.Key3 — NOT NULL
  • Field (OTEXT) — CHAR
  • Field2 (.INCLUDE) — STRU

Untitled (YTCONT_321)

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Key2 (PERNR2) — NUMC — 외래 키 → YTEMPLOYEE_321.Key2 — NOT NULL
  • Field (PERNR) — NUMC
  • Field (CELL) — CHAR
  • Field (TELL) — CHAR
  • Field (EMAIL) — CHAR
  • Field (.INCLUDE) — STRU

Untitled (YTADDR_321)

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Key2 (PERNR2) — NUMC — 외래 키 → YTEMPLOYEE_321.Key2 — NOT NULL
  • Field (PERNR) — NUMC
  • Field (HOME) — CHAR
  • Field (OFFICE) — CHAR
  • Field (.INCLUDE) — STRU

YTEMPLOYEE_321

  • Key (MANDT) — CLNT — 기본 키 — NOT NULL
  • Key2 (PERNR) — NUMC — 기본 키 — NOT NULL
  • Key3 (ORGEH) — NUMC — 기본 키 — NOT NULL
  • MANDT (MANDT2) — CLNT — 외래 키 → T000.MANDT — NOT NULL
  • Field (PNAME) — CHAR
  • Field (GBDAT) — DATS
  • Field (GENDER) — CHAR
  • Field (ISMANGER) — CHAR
  • Field (.INCLUDE) — STRU