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