ABAB

Tables (7)

SCARR (항공사 테이블)

  • CLIENT (MANDT) — CLNT — Foreign key → ZTREQMENU_28.CLIENT — NOT NULL
  • 기내식 신청 번호 (REQID) — NUMC — Foreign key → ZTREQMENU_28.기내식 신청 번호 — NOT NULL
  • CLIENT (MANDT2) — CLNT — Foreign key → ZTREQMENU_28.CLIENT — NOT NULL
  • 사번 (PERNR) — NUMC — Foreign key → ZTREQMENU_28.사번 — NOT NULL
  • CLIENT (MANDT22) — CLNT — Foreign key → ZTREQMENU_28.CLIENT — NOT NULL
  • 부서 (ORGEH2) — NUMC — Foreign key → ZTREQMENU_28.부서 — NOT NULL
  • 언어 (LANGU) — LANG — Foreign key → ZTREQMENU_28.언어 — NOT NULL

ZTADDR_28 (주소 테이블)

  • CLIENT (MANDT) — CLNT — Primary key — NOT NULL
  • 사번 (PERNR) — NUMC — Primary key — NOT NULL
  • CLIENT (MANDT2) — CLNT — Foreign key → ZTEMPLOYEE_28.CLIENT — NOT NULL
  • 사번 (PERNR2) — NUMC — Foreign key → ZTEMPLOYEE_28.사번 — NOT NULL
  • CLIENT (MANDT22) — CLNT — Foreign key → ZTEMPLOYEE_28.CLIENT — NOT NULL
  • 부서 (ORGEH2) — NUMC — Foreign key → ZTEMPLOYEE_28.부서 — NOT NULL
  • 언어 (LANGU) — LANG — Foreign key → ZTEMPLOYEE_28.언어 — NOT NULL
  • 집주소 (HOME) — CHAR
  • 회사주소 (OFFICE) — CHAR

ZTCONT_28 (연락처 테이블)

  • CLIENT (MANDT) — CLNT — Primary key — NOT NULL
  • 사번 (PERNR) — NUMC — Primary key — NOT NULL
  • CLIENT (MANDT2) — CLNT — Foreign key → ZTEMPLOYEE_28.CLIENT — NOT NULL
  • 사번 (PERNR2) — NUMC — Foreign key → ZTEMPLOYEE_28.사번 — NOT NULL
  • CLIENT (MANDT22) — CLNT — Foreign key → ZTEMPLOYEE_28.CLIENT — NOT NULL
  • 부서 (ORGEH2) — NUMC — Foreign key → ZTEMPLOYEE_28.부서 — NOT NULL
  • 언어 (LANGU) — LANG — Foreign key → ZTEMPLOYEE_28.언어 — NOT NULL
  • 휴대폰 번호 (PHONE) — CHAR
  • 집전화 번호 (TELL) — CHAR
  • 이메일 주소 (EMAIL) — CHAR

ZTEMPLOYEE_28 (사원 테이블)

  • CLIENT (MANDT) — CLNT — Primary key — NOT NULL
  • 사번 (PERNR) — NUMC — Primary key — NOT NULL
  • CLIENT (MANDT2) — CLNT — Foreign key → ZTORGEHT_28.CLIENT — NOT NULL
  • 부서 (ORGEH2) — NUMC — Foreign key → ZTORGEHT_28.부서 — NOT NULL
  • 언어 (LANGU) — LANG — Foreign key → ZTORGEHT_28.언어 — NOT NULL
  • 이름 (PNAME) — CHAR
  • 부서 (ORGEH) — NUMC
  • 성별 (GENDER) — CHAR
  • 매니저 여부 (ISMANAGER) — CHAR

ZTORGEHT_28 (부서 텍스트 테이블)

  • CLIENT (MANDT) — CLNT — Primary key — NOT NULL
  • 부서 (ORGEH) — NUMC — Primary key — NOT NULL
  • 언어 (LANGU) — LANG — Primary key — NOT NULL
  • 부서명 (OTEXT) — CHAR

ZTORGEH_28 (부서 테이블)

  • CLIENT (MANDT) — CLNT — Primary key — NOT NULL
  • 부서 (ORGEH) — NUMC — Primary key — NOT NULL
  • CLIENT (MANDT2) — CLNT — Foreign key → ZTORGEHT_28.CLIENT — NOT NULL
  • 부서 (ORGEH2) — NUMC — Foreign key → ZTORGEHT_28.부서 — NOT NULL
  • 언어 (LANGU) — LANG — Foreign key → ZTORGEHT_28.언어 — NOT NULL
  • 부서장 (CHIEF) — NUMC

ZTREQMENU_28 (기내식 신청 테이블)

  • CLIENT (MANDT) — CLNT — Primary key — NOT NULL
  • 기내식 신청 번호 (REQID) — NUMC — Primary key — NOT NULL
  • CLIENT (MANDT2) — CLNT — Foreign key → ZTEMPLOYEE_28.CLIENT — NOT NULL
  • 사번 (PERNR) — NUMC — Foreign key → ZTEMPLOYEE_28.사번 — NOT NULL
  • CLIENT (MANDT22) — CLNT — Foreign key → ZTEMPLOYEE_28.CLIENT — NOT NULL
  • 부서 (ORGEH2) — NUMC — Foreign key → ZTEMPLOYEE_28.부서 — NOT NULL
  • 언어 (LANGU) — LANG — Foreign key → ZTEMPLOYEE_28.언어 — NOT NULL
  • 항공사 (CARRID) — CHAR
  • 예약번호 (BOOKID) — NUMC
  • 기내식 메뉴번호 (MENUNUMBER) — NUMC
  • 신청일 (REQDT) — DATS
  • 신청 취소 (CANCELLED) — CHAR
  • 기내식 담당자 (MANAGER) — NUMC