SyncRoad v.0.0.4
Tables (83)
CDS VIEW (누적)
- G/L 계정 — Primary key — NOT NULL
- BUKRS (Field) — Primary key
- GJAHR (Field2) — Primary key
- 계정과목표 (Field3) — Primary key
- SHKZG
- WRBTR (Field5)
- WAERS (통화키)
- HSLVT (이월금액)
- HSL01
- HSL02
- HSL03
- HSL04
- HSL05
- HSL06
- HSL07
- HSL08
- HSL09
- HSL10
- HSL11
- HSL12
ZC102BPT0001 (BP 마스터)
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Primary key — NOT NULL
- ACCNO (계좌코드) — ZC102E_FI_ACCNO — Foreign key → ZC102FIT0013.ACCNO — NOT NULL
- BP_TYPE (BP 타입) — ZC102E_MM_BPTYPE
- BP_ROLE (BP 유형) — ZC102E_MM_BPROLE
- P_GROUP (BP그룹) — ZC102E_BP_BPGROUP — Foreign key → ZC102BPT0003.P_GROUP — NOT NULL
- CTLZL (신용평가2) — ZC102E_SD_CTLZL — Foreign key → ZC102SDT0001.CTLZL
- NAME1 (BP 이름) — ZC102E_BP_PARTNER
- EMAIL (이메일) — ZC102E_BP_EMAIL
- LAND1 (국가 코드) — ZC102E_BP_LAND1 — Foreign key → ZC102BPT0004.LAND1 — NOT NULL
- IMAGE_URL (BP 로고) — ZC102E_BP_IMAGE_URL
- MIMETYPE (MIME 타입) — ZC102E_BP_MIMETYPE
- IMAGE_DATA (로고 데이터) — ZC102E_BP_IMAGE_DATA
- FILENAME (PDF파일) — ZC102E_BP_FNAME
- PMIMETYPE (파일 MIME타입) — ZC102E_BP_PTYPE
- FILEDATA (PDF 데이터) — ZC102E_BP_PDATA
ZC102BPT0003 (BP 그룹 마스터)
- P_GROUP (BP그룹) — ZC102E_BP_BPGROUP — Primary key — NOT NULL
- TXT20 (BP그룹 이름) — ZC102E_BP_TXT20
ZC102BPT0003 (BP 조정계정 마스터)
- SAKNR (계정과목) — ZC102E_FI_SAKNR — Primary key — NOT NULL
- BPACT (고객 계정) — ZC102E_FI_BPACT — Primary key — NOT NULL
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- ACCNO (계좌코드) — ZC102E_FI_ACCNO
- ZCCNUM (계좌번호) — ZC102E_FI_ACCNUM
ZC102BPT0004 (BP 국가 마스터)
- LAND1 (국가 코드) — ZC102E_BP_LAND1 — Primary key — NOT NULL
- LANDX (국가 이름) — ZC102E_BP_LANDX
- WAERS (통화키) — ZC102E_FI_WAERS
- INTCA (ISO 코드) — ZC102E_BP_INTCA
ZC102COT0001 (Controlling Area 마스터)
- KOKRS (컨트롤링 에어리아) — ZC102E_CO_KOKRS — Primary key — NOT NULL
- BUKRS (회사 코드) — BUKRS
- WAERS (Field) — WAERS
ZC102COT0002 (Cost Elements)
- KTOPL (계정과목표) — ZC102E_FI_KTOPL — Foreign key → ZC102FIT0001.KTOPL — NOT NULL
- KOKRS (컨트롤링 에어리어) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0001.KOKRS — NOT NULL
- KSTAR (코스트 엘리먼트) — ZC102E_CO_KSTAR
ZC102COT0003 (코스트센터 마스터)
- KOSTL (코스트 센터) — ZC102E_CO_KOSTL — Primary key
- KOKRS (관리 회계 영역) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0001.KOKRS — NOT NULL
- BUKRS (회사코드) — ZC102E_FI_BUKRS
- PRCTR — ZC102E_CO_PRCTR
- WERKS (WERKS_D) — ZC102E_PP_WERKS
- DESCT (상세 정보) — ZC102E_CO_DESCT
ZC102COT0004 (프로핏 센터 마스터)
- PRCTR (프로핏 센터) — ZC102E_CO_PRCTR — Primary key — NOT NULL
- KOKRS (관리 회계 영역) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0001.KOKRS — NOT NULL
- BUKRS — ZC102E_FI_BUKRS
- WAERS (통화키) — ZC102E_FI_WAERS
ZC102COT0005 (코스트 센터 계획 값)
- KOSTL (코스트 센터) — ZC102E_CO_KOSTL — Primary key
- KOKRS (관리 회계 영역) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0001.KOKRS — NOT NULL
- BUKRS (회사코드) — ZC102E_FI_BUKRS
- WRBTR (PRCTR) — ZC102E_FI_AWRBTR
- WAERS (WERKS_D) — ZC102E_FI_WAERS
ZC102COT0006 (SKF)
- AUNIT (단위) — ZC102E_CO_AUNIT — Primary key — NOT NULL
- SKF_VALUE (지표 값) — ZC102E_CO_SKF_VALUE — Primary key — NOT NULL
- KOSTL (코스트 센터) — ZC102E_CO_KOSTL — Foreign key → ZC102COT0003.KOSTL
- KOKRS (관리 회계 영역) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0003.KOKRS — NOT NULL
- WERKS (WERKS_D) — ZC102E_PP_WERKS
ZC102COT0007 (Cost Element 계획 값)
- KOKRS (컨트롤링 에어리어) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0001.KOKRS — NOT NULL
- SAKNR (계정과목) — ZC102E_FI_SAKNR — Foreign key → ZC102FIT0001.SAKNR
- KOSTL (코스트센터) — ZC102E_CO_KOSTL
- BUKRS (회사 코드) — ZC102E_FI_BUKRS
- WRBTR (금액) — ZC102E_FI_AWRBTR
- WAERS (통화키) — ZC102E_FI_WAERS
ZC102COT0008 (코스트센터 하이어라키)
- KOHIR (코스트센터 계층) — ZC102E_CO_KOHIR — Primary key — NOT NULL
- KOSTL (코스트 센터) — ZC102E_CO_KOSTL — Foreign key → ZC102COT0003.KOSTL
- KOKRS (관리 회계 영역) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0003.KOKRS — NOT NULL
- DESCT (상세 정보) — ZC102E_CO_DESCT
ZC102COT0009 (CO 전표 헤더)
- BUKRS (회사코드) — ZC102E_FI_BUKRS — Primary key — NOT NULL
- BELNR (회계 전표 번호) — ZC102E_FI_BELNR — Primary key — NOT NULL
- GJAHR (회계연도) — ZC102E_FI_GJAHR — Primary key — NOT NULL
- KOKRS (컨트롤링 에어리아) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0001.KOKRS — NOT NULL
- BLART (CO 전표 유형) — ZC102E_CO_BLART
- BLDAT (전표 문서일자) — ZC102E_FI_BLDAT
- BUDAT (전표의 전기일) — ZC102E_FI_BUDAT
- BKTXT (문서 헤더 텍스트) — ZC102E_FI_BKTXT
- WAERS (통화키) — ZC102E_FI_WAERS
- VALID_FROM (효력 시작일) — ZC102E_CO_FROM
- VALID_TO (효력 종료일) — ZC102E_CO_TO
ZC102COT0010 (CO 전표 ITEM)
- BUZEI (개별 항목 번호) — ZC102E_FI_BUZEI — Primary key — NOT NULL
- BUKRS (회사코드) — ZC102E_FI_BUKRS — Foreign key → ZC102COT0009.BUKRS — NOT NULL
- BELNR (회계 전표 번호) — ZC102E_FI_BELNR — Foreign key → ZC102COT0009.BELNR — NOT NULL
- GJAHR (회계연도) — ZC102E_FI_GJAHR — Foreign key → ZC102COT0009.GJAHR — NOT NULL
- KOKRS (컨트롤링 에어리아) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0009.KOKRS — NOT NULL
- OBJNR (기능 영역) — ZC102E_CO_OBJNO
- BENKZ (송/수신 지시자) — ZC102E_CO_BENKZ
- SAKNR (게정과목) — ZC102E_FI_SAKNR
- SGTXT (아이템 상세) — ZC102E_FI_SGTXT
- WRBTR (금액) — ZC102E_FI_AWRBTR
- WAERS (통화키) — ZC102E_FI_WAERS
ZC102COT0011 (2차 원가 요소)
- SCCEL (2차 계정) — ZECL102SAKNR — Primary key — NOT NULL
- SAKNR (계정과목) — ZC102E_FI_SAKNR — Foreign key → ZC102FIT0002.SAKNR
- DESCT (상세 정보) — ZC102E_CO_DESCT
ZC102COT0012 (활동 유형)
- ACCTP (활동 유형) — ZC102E_CO_ACCTP — Primary key — NOT NULL
- DESCT (상세) — ZC102E_CO_DESCT
ZC102FIT0001 ([FI]G/L 계정과목표)
- KTOPL (계정과목표) — ZC102E_FI_KTOPL — Primary key — NOT NULL
- SAKNR (계정과목) — ZC102E_FI_SAKNR — Primary key
- KTOKS (계정구분) — ZC102E_FI_KTOKS
ZC102FIT0002 ([FI]G/L 계정 테이블)
- SPRAS (언어키) — SPRAS — Primary key — NOT NULL
- KTOPL (계정과목표) — ZC102E_FI_KTOPL — Foreign key → ZC102FIT0001.KTOPL — NOT NULL
- SAKNR (계정과목) — ZC102E_FI_SAKNR — Foreign key → ZC102FIT0001.SAKNR
- ACDES (계정분류) — ZC102E_FI_ACDES
- BS_LVL1 ([FI] B/S 1레벨) — ZC102E_FI_LVL1
- BS_LVL2 ([FI] B/S 2레벨) — ZC102E_FI_LVL2
- KTOKS (G/L 계정그룹) — ZC102E_FI_KTOKS
- TXT20 (계정과목 설명) — ZC102E_FI_TXT20
- KSTAR (Cost Element) — ZC102E_CO_KSTAR
ZC102FIT0003 ([FI]계정과목표 마스터 테이블)
- SPRAS (언어키) — SPRAS — Primary key — NOT NULL
- KTOPL (계정과목표) — ZC102E_FI_KTOPL — Foreign key → ZC102FIT0001.KTOPL — NOT NULL
- KTPLT (계정그룹 이름) — KTPLT
ZC102FIT0004 (전기키 마스터)
- BSCHL (전기키) — ZC102E_FI_BSCHL — Primary key — NOT NULL
- SHKZG (차변/대변 지시자) — SHKZG
- KOART (계정 유형) — ZC102E_FI_KOART
- LTEXT (전기키 이름) — ZC102E_FI_TEXT_BSLT
ZC102FIT0005 ([FI]전표유형 마스터 테이블)
- BLART (전표유형) — ZC102E_FI_BLART — Primary key — NOT NULL
- SPRAS (언어키) — SPRAS — Primary key
- LTEXT (전표유형 내역) — LTEXT_003T
ZC102FIT0006 ([FI]역분개 텍스트)
- STGRD (역분개 사유 코드) — ZC102E_FI_STGRD — Primary key
- TXT50 (사유 설명) — TXT50
ZC102FIT0007 ([AA] 자산 관리 마스터)
- BUKRS (회사코드) — BUKRS — Primary key — NOT NULL
- ANLN1 (주요 자산번호) — ZC102E_FI_ALNL1 — Primary key
- USEYE (내용 연수) — ZC102E_FI_USEYE
- REMVL (잔존 가치) — ZC102E_FI_REMVL
- DEPMT (감가상각방법) — ZC102E_FI_DEPMT
- TXT50 (설명) — TXT50
- STATUS (삭제 플래그) — ZC102E_AA_STATUS
- WAERS (통화키) — WAERS
- ERDAT (자산 취득일) — ERDAT
ZC102FIT0008 ([FI] 여신관리)
- 회사코드 — ZC102E_FI_BUKRS — Primary key
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- CTLZL (신용평가2) — ZC102E_SD_CTLZL — Foreign key → ZC102BPT0001.CTLZL
- CREDIT_LIMIT (여신한도) — WRBTR
- CREDIT_USED (사용 여신) — WRBTR
- WAERS (통화키) — WAERS
- LAST_UPDATED (여신 유효 시작일) — AEDAT
ZC102FIT0009 ([FI]전표(H))
- BUKRS (회사코드) — ZC102E_FI_BUKRS — Primary key — NOT NULL
- BELNR (전표번호) — ZC102E_FI_BELNR — Primary key — NOT NULL
- GJAHR (회계연도) — ZC102E_FI_GJAHR — Primary key — NOT NULL
- BLART (전표유형) — ZC102E_FI_BLART — Foreign key → ZC102FIT0005.BLART — NOT NULL
- BUDAT (전표의 전기일) — ZC102E_FI_BUDAT
- BKTXT (전표 헤더 텍스트) — ZC102E_FI_BKTXT
- STBLG (역분개 전표 번호) — ZC102E_FI_STBLG
- STODT (역분개 전기 계획일) — ZC102E_FI_STODT
- STGRD (역분개 사유 코드) — ZC102E_FI_STGRD — Foreign key → ZC102FIT0006.STGRD
- WAERS (통화키) — ZC102E_FI_WAERS
ZC102FIT0010 ([FI]전표(Item))
- BUZEI (회계 전표 내 개별 항목 번호) — ZC102D_FI_BUZEI — Primary key — NOT NULL
- BUKRS (회사코드) — ZC102D_FI_BUKRS — Foreign key → ZC102FIT0009.BUKRS — NOT NULL
- BELNR (전표번호) — ZC102D_FI_BELNR — Foreign key → ZC102FIT0009.BELNR — NOT NULL
- GJAHR (회계연도) — ZC102D_FI_GJAHR — Foreign key → ZC102FIT0009.GJAHR — NOT NULL
- SAKNR (계정과목) — ZC102E_FI_SAKNR — Foreign key → ZC102FIT0001.SAKNR
- AUGDT (반제일) — ZC102E_FI_AUGDT
- AUGBL (반제 전표번호) — ZC102E_FI_AUGBL
- BSCHL (전기키) — ZC102E_FI_BSCHL — Foreign key → ZC102FIT0004.BSCHL — NOT NULL
- SHKZG (차변/대변 지시자) — ZC102E_FI_SHKZG
- KOART (계정 유형) — ZC102E_FI_KOART
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- SGTXT (아이템 상세) — ZC102E_FI_SGTXT
- PDONO (생산오더번호) — ZC102E_PP_PDONO
- ANLN1 (주요 자산번호) — ZC102E_FI_ALNL1 — Foreign key → ZC102FIT0007.ANLN1
- WRBTR (금액) — ZC102E_FI_AWRBTR
- DMBTR (환율 환산 금액) — ZC102E_FI_DMBTR
- WAERS (통화키) — ZC102E_FI_WAERS
- KOSTL (코스트 센터) — ZC102E_CO_KOSTL
- PRCTR (프로핏 센터) — ZC102E_CO_PRCTR — Foreign key → ZC102COT0004.PRCTR — NOT NULL
- KOKRS (관리 회계 영역) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0004.KOKRS — NOT NULL
- MWSKZ (세금 코드) — ZC102E_FI_MWSKZ — Foreign key
- MBLNR (자재문서번호) — ZC102E_MM_MBLNR — Foreign key → ZC102MMT0012.MBLNR
- EBELN (구매오더번호) — ZC102E_MM_EBELN — Foreign key → ZC102MMT0011.EBELN
- VBELN (판매오더 번호) — ZC102E_SD_VBELNS — Foreign key → ZC102SDT0006.VBELN_SO
- DUEDT (지급 기한) — ZC102E_FI_DUEDT
- REBZG (원 전표 번호) — ZC102E_FI_REBZG
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Foreign key → ZC102SDT0006.CUSNO
- BPACT (고객계정) — ZC102E_FI_SAKNR
- STATUS (상태) — ZC102E_PP_STATUS
- MATNR (자재번호2) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0011.MATNR
- PRNO (구매요청번호2) — ZC102E_MM_PRNO — Foreign key → ZC102MMT0011.PRNO — NOT NULL
ZC102FIT0011 ([FI]계정그룹 정보 테이블)
- SPRAS (언어키) — SPRAS — Primary key — NOT NULL
- KTOKS (계정구분) — ZC102E_FI_KTOKS — Primary key — NOT NULL
- KTOPL (계정과목표) — ZC102E_FI_KTOPL — Foreign key → ZC102FIT0001.KTOPL — NOT NULL
- TXT30 (계정 그룹 이름) — TXT30_077T
ZC102FIT0012 (자산 관리)
- GJAHR (회계 연도) — GJAHR — Primary key — NOT NULL
- ANLN1 (주요 자산번호) — ZC102E_FI_ALNL1 — Foreign key → ZC102FIT0007.ANLN1
- BUYPR (매입가) — ZC102E_FI_BUYPR
- BVALU (장부가액) — ZC102E_FI_BUYPR
- DESUM (감가상각누계액) — ZC102E_FI_BUYPR
- WAERS (Field) — WAERS
- DEPPR01 (1월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR02 (2월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR03 (3월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR04 (4월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR05 (5월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR06 (6월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR07 (7월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR08 (8월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR09 (9월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR10 (10월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR11 (11월 감가상각비) — ZC102E_AA_DEPPR
- DEPPR12 (12월 감가상각비) — ZC102E_AA_DEPPR
- STATUS (삭제 플래그) — ZC102E_AA_STATUS
ZC102FIT0013 (계좌 마스터)
- ACCNO (계좌코드) — ZC102E_FI_ACCNO — Primary key — NOT NULL
- ACCNUM (계좌번호) — ZC102E_FI_ACCNUM — NOT NULL
- BANK (은행) — ZC102E_FI_BANK
- WAERS (통화키) — ZC102E_FI_WAERS
- PARTNER (비즈니스 파트너) — ZC102E_BP_PARTNER
- OWNER_TYPE (소유자 구분) — ZC102E_FI_OWNER
ZC102FIT0014 (계좌)
- SERNO (일련번호) — ZC102E_FI_SERNO — Primary key — NOT NULL
- DWDATE (거래일자) — ZC102E_FI_DWDATE — Primary key
- ACCNO (계좌코드) — ZC102E_FI_ACCNO — Foreign key → ZC102FIT0013.ACCNO — NOT NULL
- HISTORY (거래내역) — ZC102E_FI_HISTORY
- TTYPE (거래타입) — ZC102E_FI_TTYPE
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- CTLZL (신용평가2) — ZC102E_SD_CTLZL — Foreign key → ZC102BPT0001.CTLZL
- WRBTR (금액) — ZC102E_FI_AWRBTR
- WAERS (통화키) — ZC102E_FI_WAERS
ZC102FIT0015 (환율)
- T_WAERS (변경 대상 통화키) — ZC102E_FI_TWAERS — Primary key — NOT NULL
- O_WAERS (원 통화키) — ZC102E_FI_OWAERS — Primary key — NOT NULL
- DATUM (일자) — ZC102E_FI_DATUM — Primary key
- WRBTR (환전 금액) — ZC102E_FI_WRBTR
ZC102FIT0016 ([FI]반제전표(item))
- BUZEI (회계 전표 내 개별 항목 번호) — ZC102E_FI_BUZEI — Primary key — NOT NULL
- AUGBL (반제 전표번호) — ZC102E_FI_AUGBL — Primary key
- BUKRS (회사코드) — ZC102E_FI_BUKRS — Foreign key → ZC102FIT0009.BUKRS — NOT NULL
- BELNR (전표번호) — ZC102E_FI_BELNR — Foreign key → ZC102FIT0009.BELNR — NOT NULL
- GJAHR (회계연도) — ZC102E_FI_GJAHR — Foreign key → ZC102FIT0009.GJAHR — NOT NULL
- SAKNR (계정과목) — ZC102E_FI_SAKNR — Foreign key → ZC102FIT0001.SAKNR
- AUGDT (반제일) — ZC102E_FI_AUGDT
- BSCHL (전기키) — ZC102E_FI_BSCHL — Foreign key → ZC102FIT0004.BSCHL — NOT NULL
- BPACT (고객 계정) — ZC102E_FI_BPACT
- SHKZG (차변/대변 지시자) — ZC102E_FI_SHKZG
- KOART (계정 유형) — ZC102E_FI_KOART
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- SGTXT (아이템 상세) — ZC102E_FI_SGTXT
- PDONO (생산오더번호) — ZC102E_PP_PDONO
- ANLN1 (주요 자산번호) — ZC102E_FI_ALNL1 — Foreign key → ZC102FIT0007.ANLN1
- WRBTR (금액) — ZC102E_FI_AWRBTR
- DMBTR (환율 환산 금액) — ZC102E_FI_DMBTR
- WAERS (통화키) — ZC102E_FI_WAERS
- KOSTL (코스트 센터) — ZC102E_CO_KOSTL
- PRCTR (프로핏 센터) — ZC102E_CO_PRCTR — Foreign key → ZC102COT0004.PRCTR — NOT NULL
- KOKRS — ZC102E_CO_KOKRS — Foreign key → ZC102COT0004.KOKRS — NOT NULL
- MWSKZ (세금 코드) — ZC102E_FI_MWSKZ — Foreign key
- MBLNR (자재문서번호) — ZC102E_MM_MBLNR — Foreign key → ZC102MMT0012.MBLNR
- EBELN (구매오더번호) — ZC102E_MM_EBELN — Foreign key → ZC102MMT0011.EBELN
- VBELN (판매오더 번호) — ZC102E_SD_VBELNS — Foreign key → ZC102SDT0006.VBELN_SO
- DUEDT (지급 기한) — ZC102E_FI_DUEDT
- REBZG (원전표번호) — ZC102E_FI_REBZG
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Foreign key → ZC102SDT0006.CUSNO
- MATNR (자재번호2) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0011.MATNR
- PRNO (구매요청번호2) — ZC102E_MM_PRNO — Foreign key → ZC102MMT0011.PRNO — NOT NULL
ZC102FIT0019 ([FI]분쟁조정)
- REQID (조정요청 ID) — ZC102E_FI_REQID — Primary key — NOT NULL
- TITLE (제목) — ZC102E_FI_TITLE
- REASON (조정 사유 코드) — ZC102E_FI_REASON
- PRIO (우선순위) — ZC102E_FI_PRIO
- PROCES (처리자ID) — ZC102E_FI_PROCES
- EXTREF (외부 참조번호) — ZC102E_FI_EXTREF
- EXTREF2 (외부 참조번호2) — ZC102E_FI_EXTREF2
- CONNA (연락 담당자명) — ZC102E_FI_CONNA
- NOTE (메모/지시사항) — ZC102E_FI_NOTE
ZC102HRT0001 (부서 마스터 테이블)
- DEPNO (부서번호) — ZC102E_SD_DEPNO — Primary key — NOT NULL
- DEPNAME (팀명) — ZC102E_SD_DEPNAME
- KOSTL (코스트 센터) — ZC102E_CO_KOSTL — Foreign key → ZC102COT0003.KOSTL
- DEPPSNO (인원수) — ZC102E_HR_DEPPSNO
ZC102HRT0002 (사원)
- EMPNO (사원번호) — ZC102E_HR_EMPNO — Primary key — NOT NULL
- HTYPE (사원 유형) — ZC102E_HR_HTYPE
- EMAIL (이메일 주소) — ZC102E_MM_EMAIL
- DEPNO (부서번호) — ZC102E_SD_DEPNO — Foreign key → ZC102HRT0001.DEPNO — NOT NULL
- EMPNAM (사원명) — ZC102E_HR_EMPNAM
- AVNOW (가용여부) — ZC102E_HR_AVNOW
- GRADE (직급) — ZC102E_HR_GRADE
- ENTDT (입사일) — ZC102E_HR_ENTDT
- EVALG (성과등급) — ZC102E_HR_EVALG
- TELF1 (연락처) — ZC102E_SD_TELF1
- REGNO (지역 코드) — ZC102E_PP_REGNO
ZC102MMT0001 (자재관리)
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- STLNO (창고번호) — ZC102E_MM_STLNO — Foreign key → ZC102MMT0008.STLNO — NOT NULL
- STLTYPE (창고유형) — ZC102E_MM_STLTYPE — Foreign key → ZC102MMT0008.STLTYPE — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102MMT0008.WERKS — NOT NULL
- LABST (가용재고량) — ZC102E_MM_LABST
- RABST (현재재고량) — ZC102E_MM_RABST
- EISBE (안전재고량) — ZC102E_MM_EISBE
- MEINS (단위) — MEINS
ZC102MMT0002 (거래처 마스터)
- VENNO (거래처번호) — ZC102E_MM_VENNO — Primary key — NOT NULL
- NAME1 (거래처명) — ZC102E_MM_NAME1
- TELF1 (연락처) — ZC102E_MM_TELF1
- STRAS (주소) — ZC102E_MM_STRAS
- KNKLI (거래처 등급) — ZC102E_MM_KNKLI
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
ZC102MMT0003 (가공 완제품)
- STLNO (창고번호) — ZC102E_MM_STLNO — Primary key — NOT NULL
- STLTYPE (창고유형) — ZC102E_MM_STLTYPE — Primary key — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Primary key — NOT NULL
- BATNO (배치번호) — ZC102E_MM_BATNO — Primary key
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- LABST (가용재고량) — ZC102E_MM_LABST
- MEINS (단위) — MEINS
- LFDAT (입고일) — ZC102E_MM_LFDAT
- VFDAT (유통기한) — ZC102E_MM_VFDAT
- TEMPE (온도) — ZC102E_MM_TEMP
- T_UNIT (온도단위) — ZC102E_MM_TEMPUNIT
ZC102MMT0004 (자재마스터)
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key — NOT NULL
- MAKTX (자재명) — ZC102E_MM_MAKTX
- MTART (자재유형) — ZC102E_MM_MTART
- MTYPE (신선/가공) — ZC102E_MM_MTYPE
- STPRS (구매가) — ZC102E_MM_STPRS
- PRICE (표준 원가) — ZC102E_MM_PRICE
- WAERS (통화키) — WAERS
- MEINS (단위) — MEINS
- RGTIME (입고 리드타임) — ZC102E_MM_RGTIME
- IMAGE_URL (이미지) — ZC102E_BP_IMAGE
- MIMETYPE (MIME 타입) — ZC102E_BP_MIMETYPE
- IMAGE_DATA (이미지 데이터) — ZC102E_BP_IMAGE_DATA
ZC102MMT0005 (원자재창고)
- BATNO (배치번호) — ZC102E_MM_BATNO — Primary key
- STLNO (창고번호) — ZC102E_MM_STLNO — Foreign key → ZC102MMT0008.STLNO — NOT NULL
- STLTYPE (창고유형) — ZC102E_MM_STLTYPE — Foreign key → ZC102MMT0008.STLTYPE — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102MMT0008.WERKS — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- LABST (실재고) — ZC102E_MM_LABST
- RABST (가용재고) — ZC102E_MM_RABST
- EISBE (안전재고) — ZC102E_MM_EISBE
- MEINS (재고단위) — MEINS
- LFDAT (입고일) — DATUM
- TEMPE (온도) — ZC102E_MM_TEMP
- T_UNIT (온도단위) — ZC102E_MM_TEMPUNIT
- HUMID (습도) — ZC102E_MM_HUMID
- H_UNIT (습도단위) — ZC102E_MM_HUNIT
- VFDAT (유통기한) — DATUM
ZC102MMT0006 (신선 완제품창고)
- STLNO (창고번호) — ZC102E_MM_STLNO — Primary key — NOT NULL
- STLTYPE (창고유형) — ZC102E_MM_STLTYPE — Primary key — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Primary key — NOT NULL
- BATNO (배치번호) — ZC102E_MM_BATNO — Primary key
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- LABST (가용재고) — ZC102E_MM_LABST
- MEINS (단위) — MEINS
- LFDAT (입고일) — ZC102E_MM_LFDAT
- TEMPE (온도) — ZC102E_MM_TEMP
- T_UNIT (온도단위) — ZC102E_MM_TEMPUNIT
- HUMID (습도) — ZC102E_MM_HUMID
- H_UNIT (습도단위) — ZC102E_MM_HUNIT
- VFDAT (유통기한) — ZC102E_MM_VFDAT
ZC102MMT0007 (기타(포장)창고)
- STLNO (창고번호) — ZC102E_MM_STLNO — Foreign key → ZC102MMT0008.STLNO — NOT NULL
- STLTYPE (창고유형) — ZC102E_MM_STLTYPE — Foreign key → ZC102MMT0008.STLTYPE — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102MMT0008.WERKS — NOT NULL
- RABST (실재고량) — ZC102E_MM_RABST
- EISBE (안전재고량) — ZC102E_MM_EISBE
- LABST (가용재고) — ZC102E_MM_LABST
- MEINS (단위) — MEINS
- LFDAT (입고일) — ZC102E_MM_LFDAT
ZC102MMT0008 (창고 마스터)
- STLNO (창고번호) — ZC102E_MM_STLNO — Primary key — NOT NULL
- STLTYPE (창고유형) — ZC102E_MM_STLTYPE — Primary key — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102PPT0002.WERKS — NOT NULL
- STLNAME (창고명) — ZC102E_MM_STLNAME
- NAME1 (거래처명) — ZC102E_MM_NAME1
- DEL_STATE (삭재플래그) — ZC102E_MM_STATE
- LOCATION (위치) — TXT20
- REGNO (지역코드) — ZC102E_PP_REGNO
ZC102MMT0009 (구매계획)
- PPLAN (구매계획번호) — ZC102E_MM_PPLAN — Primary key — NOT NULL
- PPLDAT (구매계획일자) — ZC102E_MM_PPLDAT
- DEPNO (구매요청부서) — ZC102E_MM_DEPNO
- MATNR (자재번호) — ZC102E_MM_MATNR
- NETPR (단가) — ZC102E_MM_NETPR
- NETWR (구매총액) — WRBTR
- WAERS (통화키) — WAERS
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- DZEIT (배송리드타임) — ZC102E_PP_LEATI
- DEL_STATE (삭제플래그) — ZC102E_MM_STATE
ZC102MMT0011 (구매오더)
- EBELN (구매오더번호) — ZC102E_MM_EBELN — Primary key
- PRNO (구매요청번호) — ZC102E_MM_PRNO — Foreign key → ZC102MMT0017.PRNO — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0017.MATNR
- STLNO (창고번호) — ZC102E_MM_STLNO — Foreign key → ZC102MMT0008.STLNO — NOT NULL
- PODAT (구매오더일자) — ZC102E_MM_PODAT
- STPRS (구매가) — ZC102E_MM_STPRS
- WAERS (통화키) — WAERS
- PARTNER (비즈니스 파트너) — ZC102E_BP_PARTNER
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- DZEIT (배송리드타임) — ZC102E_PP_LEATI
- GREDAT (입고예정일자) — ZC102E_MM_GREDAT
- ENDIT (납기일) — ZC102E_MM_ENDIT
- CHECK_IV (송장 검증확정) — ZC102E_MM_CHECK_IV
- GR_STATE (삭제 Flag) — ZC102E_MM_STATE
- REORDER (구매오더 유형) — ZC102E_MM_ORDER
ZC102MMT0012 (자재문서(H))
- MBLNR (자재문서번호) — ZC102E_MM_BELNR — Primary key
- RYEAR (회계연도) — GJAHR — Primary key — NOT NULL
- BWART (자재이동유형) — ZC102E_MM_BWART
- CPUDT (생성일자) — ZC102E_MM_CREDAT
- USNAM (담당자명) — ZC102E_MM_USNAM
- WERKS (Plnat 번호) — ZC102E_PP_WERKS
- STLNO (창고번호) — ZC102E_MM_STLNO
- REFNO (참조번호) — ZC102E_MM_REFNO
ZC102MMT0013 (자재문서(I))
- MBLNR (자재문서번호) — ZC102E_MM_MBLNR — Foreign key → ZC102MMT0012.MBLNR
- BATNO (배치번호) — ZC102E_MM_BATNO — Foreign key → ZC102MMT0012.RYEAR — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0001.MATNR — NOT NULL
- MENGE (수량) — ZC102E_MM_MENGE
- MEINS (단위) — MEINS
ZC102MMT0014 (숙성창고)
- STLNO (창고번호) — ZC102E_MM_STLNO — Foreign key → ZC102MMT0008.STLNO — NOT NULL
- STLTYPE (창고유형) — ZC102E_MM_STLTYPE — Foreign key → ZC102MMT0008.STLTYPE — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_PLANT — Foreign key → ZC102MMT0008.WERKS — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- DATBI (유통기한) — DATBI
- PDONO (생산 오더 번호) — ZC102E_PP_PDONO
- MENGE (수량) — MENGE_D
- MEINS (수량단위) — MEINS
- TEMPE (온도) — ZC102E_MM_TEMP
- T_UNIT (온도단위) — ZC102E_MM_TEMPUNIT
- HUMID (습도) — ZC102E_MM_HUMID
- H_UNIT (습도단위) — ZC102E_MM_HUNIT
- BATNO (배치 번호) — ZC102E_MM_BATNO
- DPOSE (폐기수량) — ZC102E_MM_DPOSE
- TEMPTIME (숙성시간) — UZEIT
ZC102MMT0015 (송장검증)
- VBELN_BIL (송장번호) — ZC102E_MM_VBELNB — Primary key — NOT NULL
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- EBELN (구매오더번호) — ZC102E_MM_EBELN — Foreign key → ZC102MMT0011.EBELN
- MATNR (자재번호) — ZC102E_MM_MATNR — NOT NULL
- ODRQU (주문수량) — ZC102E_MM_ODRQU
- GRQTY (실입고수량) — ERFMG
- MEINS (단위) — MEINS
- QCHECK (검수 결과) — ZC102E_MM_STATE
- WRBTR (금액) — WRBTR
- WAERS (통화) — WAERS
- PAYCO (지불방식) — ZC102E_SD_PAYCO
- PRDAT (구매요청일자) — DATUM
- GREDAT (입고예정일자) — DATUM
- LFDAT (실입고일자) — DATUM
- CKDAT (검토날짜) — DATUM
- NAME1 (검토담당자) — ZC102E_MM_NAME1
- BELNR (전표번호) — BELNR_D
- REORDER (구매오더 유형) — ZC102E_MM_ORDER
- STATE (상태) — ZC102E_PP_STATUS
- CHECK_IV (송장 검증 확정 여부) — ZC102E_MM_CHECK_IV
- Key — Foreign key — NOT NULL
- Key (Key2) — Foreign key — NOT NULL
- MATNR (자재번호2) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0011.MATNR
- PRNO (구매요청번호2) — ZC102E_MM_PRNO — Foreign key → ZC102MMT0011.PRNO — NOT NULL
ZC102MMT0016 (구매요청(H))
- PRNO (구매요청번호) — ZC102E_MM_PRNO — Primary key — NOT NULL
- DEPNO (구매요청부서) — ZC102E_MM_DEPNO — Primary key
- TOLCO (구매총액) — ZC102E_MM_TOLCO
- WAERS (통화키) — WAERS
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- REDAT (요청일자) — ZC102E_MM_REDAT
ZC102MMT0017 (구매요청(ITEM))
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key
- PRNO (구매요청번호) — ZC102E_MM_PRNO — Foreign key → ZC102MMT0016.PRNO — NOT NULL
- DEPNO (구매요청부서) — ZC102E_MM_DEPNO — Foreign key → ZC102MMT0016.DEPNO
- STPRS (구매가) — ZC102E_MM_STPRS
- WAERS (통화키) — WAERS
- PARTNER (비즈니스 파트너) — ZC102E_BP_PARTNER
- PEQUAN (주문 수량) — ZC102E_MM_PEQUAN
- MEINS (단위) — MEINS
- STLNO (창고번호) — ZC102E_MM_STLNO
- RGTIME (입고 리드타임) — ZC102E_MM_RGTIME
- STATE (구매요청 상태) — ZC102E_MM_STATUS
- EBELN (구매오더번호) — ZC102E_MM_EBELN — Foreign key → ZC102MMT0011.EBELN
ZC102MMT0018 ([MM] 폐기/반품)
- DISNO (폐기번호) — ZC102E_MM_DISNO — Primary key — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key — NOT NULL
- BATNO (배치번호) — ZC102E_MM_BATNO — Primary key — NOT NULL
- DISDA (폐기/반품 등록일) — ZC102E_MM_DISDA — Primary key
- DISTYPE (폐기/반품 유형) — ZC102E_MM_DISTYPE — Primary key — NOT NULL
- DISME (폐기/반품 수량) — ZC102E_MM_DISME
- MEINS (단위) — MEINS
- PERDI (불량률) — ZC102E_MM_PERDI
- REASO (폐기사유(코드)) — ZC102E_MM_REASO
- REFNO (참조번호) — ZC102E_MM_REFNO
ZC102MMT0019 (비즈니스파트너-자재 연결)
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key — NOT NULL
- PARTNER (비즈니스 파트너) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- STPRS (구매가) — ZC102E_MM_STPRS
- WAERS (통화키) — WAERS
- YEAR_SD (연도) — ZC102E_SD_YEAR
- MONTH01 (월 별 수량 1) — ZC102E_MM_MONTH
- MONTH02 (월 별 수량 2) — ZC102E_MM_MONTH
- MONTH03 (월 별 수량 3) — ZC102E_MM_MONTH
- MONTH04 (월 별 수량4) — ZC102E_MM_MONTH
- MONTH05 (월 별 수량5) — ZC102E_MM_MONTH
- MONTH06 (월 별 수량6) — ZC102E_MM_MONTH
- MONTH07 (월 별 수량7) — ZC102E_MM_MONTH
- MONTH08 (월 별 수량8) — ZC102E_MM_MONTH
- MONTH09 (월 별 수량9) — ZC102E_MM_MONTH
- MONTH10 (월 별 수량10) — ZC102E_MM_MONTH
- MONTH11 (월 별 수량 11) — ZC102E_MM_MONTH
- MONTH12D (월 별 수량12) — ZC102E_MM_MONTH
- MENGE_YEAR (연 총 수량) — ZC102E_MM_MENGE_YEAR
- MEINS (단위) — MEINS
- MONAT (Fiscal Period) — MONAT
- CONTYPE (거래타입) — ZC102E_BP_CONTYPE
ZC102PPT0001 (생산계획)
- PPLNO (생산계획번호) — ZC102E_PP_PPLNO — Primary key — NOT NULL
- YEAR_PP (년) — ZC102E_SD_NUMC — Foreign key → ZC102SDT0008.YEAR_SD
- MONTH_PP (월) — ZC102E_SD_NUMC — Foreign key → ZC102SDT0008.MONTH_SD
- MATNR_PP (자재번호) — ZC102E_SD_NUMC — Foreign key → ZC102SDT0008.MATNR — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102SDT0008.WERKS — NOT NULL
- WEMNG (생산량) — MENGE_D
- MEINS (단위) — MEINS
- STATE (납품 상태) — ZC102E_SD_STATE
ZC102PPT0002 (PLANT)
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Primary key — NOT NULL
- WKCNO (work center) — ZC102E_PP_WKCNO
- REGNO (지역번호) — ZC102E_PP_REGNO
- STLNO (S/L) — ZC102E_MM_STLNO
- KOSTL (Cost Center) — KOSTL — Foreign key → ZC102COT0003.KOSTL
- KOKRS (Controlling Area) — KOKRS — Foreign key → ZC102COT0003.KOKRS — NOT NULL
ZC102PPT0003 (BOM (H))
- BOMNO (BOM번호) — ZC102E_PP_BOMNO — Primary key — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- STLNO (S/L) — ZC102E_MM_STLNO
- USABLE (Status) — ZC102E_PP_STATUS
- DAUNO (생산리드타임) — ZC102E_PP_DAUNO — NOT NULL
- DATUV (유효시작기간) — DATUM
- DATUB (유효종료기간) — DATUM
ZC102PPT0004 (BOM(ITEM))
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key — NOT NULL
- BOMNO (BOM번호) — ZC102E_PP_BOMNO — Foreign key → ZC102PPT0003.BOMNO — NOT NULL
- BOM_H (BOM Header) — ZC102E_PP_BOM_H
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- USABLE (Status) — ZC102E_PP_STATUS
- DAUNO (생산리드타임) — ZC102E_PP_DAUNO
- MTART (자재유형) — ZC102E_MM_MTART
ZC102PPT0005 (배치로그)
- BATNO — ZC102E_PP_BATNO — Primary key — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- MTART (자재유형) — ZC102E_MM_MTART
- LFDAT (입고일) — DATUM
- WDAT (출고일) — DATUM
- BSTAT (Status) — ZC102E_PP_BSTAT
- STLNO (S/L) — ZC102E_PP_STLNO
- HSDAT (자재별 생산일) — DATUM
- BWART (이동유형) — ZC102E_MM_BWART
ZC102PPT0006 (계획오더)
- PLONO (계획번호) — ZC102E_PP_PLONO — Primary key — NOT NULL
- WERKS (Plant 번호2) — ZC102E_PP_WERKS — Foreign key — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- WKCNO (Work Center번호) — ZC102E_PP_WKCNO
- REF_NO (Ref. Num) — ZC102E_SD_VBELNS
- STLNO (S/L) — ZC102E_MM_STLNO
- PSTTR (계획생산일) — ZC102E_MM_PSTTR
- PEDTR (계획종료일) — ZC102E_MM_PEDTR
- STATUS (Status) — ZC102E_PP_STATUS
- REASON_TEXT (반려 사유 상세) — ZC102E_PP_TXT50
ZC102PPT0007 (생산완료)
- BOMNO (BOM 번호) — ZC102E_PP_BOMNO — Primary key — NOT NULL
- PDONO (생산오더번호) — ZC102E_PP_PDONO — Foreign key → ZC102PPT0012.PDONO — NOT NULL
- WCTNO (Workcenter 번호) — ZC102E_PP_WKCNO — Foreign key → ZC102PPT0012.MATNR — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102PPT0012.WERKS — NOT NULL
- PLONO (계획번호) — ZC102E_PP_PLONO — Foreign key → ZC102PPT0012.PLONO — NOT NULL
- BATNO (배치번호) — ZC102E_PP_BATNO — Foreign key → ZC102PPT0005.BATNO — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102PPT0005.MATNR — NOT NULL
- STATUS (Status) — ZC102E_PP_STATUS
- STLNO (S/L) — ZC102E_MM_STLNO
- QCHECK (품질검사) — ZC102E_PP_QCHECK
- WADAT (출고날짜) — ZC102E_PP_WADAT
- NAME1 (책임사원) — ZC102E_PP_PERNR
- LTIME (배송리드타임) — ZC102E_PP_LEATI
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
ZC102PPT0008 (MRP 라인)
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key
- BOMNO (BOM번호) — ZC102E_PP_BOMNO — Foreign key → ZC102PPT0013.MATNR — NOT NULL
- DATBI (효력 종료일) — DATBI — Foreign key
- WERKS (Plant 번호2) — ZC102E_PP_WERKS — Foreign key — NOT NULL
- PPLNO (생산 계획 번호) — ZC102E_PP_PPLNO
- MTART (자재유형) — ZC102E_MM_MTART
- REQ_QTY (요구수량) — MENGE_D
- MENGE (수량) — MENGE
- MEINS (단위) — MEINS
- DAT00 (요구일자) — ZC102E_PP_DAT00
ZC102PPT0009 (라우팅 마스터)
- PDONO (생산 오더 번호) — ZC102E_PP_PDONO — Primary key — NOT NULL
- ROUNO (라우팅 번호) — ZC102E_PP_ROUNO — Primary key — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS
- WCTNO (WorkCenter 번호) — ZC102E_PP_WCTNO
ZC102PPT0010 (라우팅)
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key — NOT NULL
- WCTNO (Workcenter 번호) — ZC102E_PP_WCTNO — Foreign key → ZC102PPT0011.WKCNO — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WEKRS — Foreign key → ZC102PPT0011.WERKS — NOT NULL
- ROUNO (라우팅 번호) — ZC102E_PP_ROUNO — Foreign key → ZC102PPT0009.ROUNO — NOT NULL
- PDONO (생산 오더 번호) — ZC102E_PP_PDONO — Foreign key → ZC102PPT0009.PDONO — NOT NULL
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- RSTDA (라우팅 시작일) — ZC102E_PP_RSTDA
- RENDA (라우팅 종료일) — ZC102E_PP_RENDA
- REMAN (필요인원수) — ZC102E_PP_REMAN
- REMAC (필요기계수) — ZC102E_PP_REMAC
- STATUS (Status) — ZC102E_PP_STATUS
- PROG (진행률) — ZC102E_PP_PROG
- P_UNIT (진행률 단위) — ZC102E_PP_PUNIT
ZC102PPT0011 (WORK CENTER)
- WKCNO (Workcenter 번호) — ZC102E_PP_WKCNO — Primary key — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WKCNO — Foreign key → ZC102PPT0002.WERKS — NOT NULL
- MANZT (필요인력수) — ZC102E_PP_MANZT
- PERNR (담당사원) — ZC102E_PP_PERNR
ZC102PPT0012 (생산오더)
- PDONO (생산오더번호) — ZC102E_PP_PDONO — Primary key — NOT NULL
- WKCNO (Workcenter 번호) — ZC102E_PP_WKCNO — Primary key
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102PPT0011.WKCNO — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102PPT0011.WERKS — NOT NULL
- PLONO (계획번호) — ZC102E_PP_PLONO — Foreign key → ZC102PPT0006.PLONO — NOT NULL
- ROUNO (라우팅 번호) — ZC102E_PP_ROUNO
- MENGE (수량) — ZC102E_MM_MENGE
- MEINS (단위) — MEINS
- PDSTT (생산 시작일) — ZC102E_PP_PDSTT
- PDFNS (생산 종료일) — ZC102E_PP_PDFNS
- MKSTA (생산진행상태) — ZC102E_PP_MKSTA
- PROG (진행률) — ZC102E_PP_PROG
- P_UNIT (진행 단위) — ZC102E_PP_PUNIT
- STLNO (창고번호) — ZC102E_MM_STLNO
ZC102PPT0013 (MRP)
- MRPDT (MRP 수행날짜) — ZC102E_PP_MRPNO — Primary key — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102PPT0003.BOMNO — NOT NULL
- PPLNO (생산계획번호) — ZC102E_PP_PPLNO — Foreign key → ZC102PPT0001.PPLNO — NOT NULL
- VBELN_SO (판매오더 번호) — ZC102E_SD_VBELNS
- PLONO (계획오더 번호) — ZC102E_PP_PLONO
- RFQ_QTY (필요수량) — ZC102E_PP_REQTY
- MEINS (단위) — MEINS
- MRPEL (MRP 유형) — ZC102E_PP_MRPEL
- DISPO (MRP Controller) — ZC102E_PP_DISPO
- WKCNO (Workcenter 번호) — ZC102E_PP_WKCNO — Foreign key → ZC102PPT0011.WKCNO — NOT NULL
- STATUS (상태) — ZC102E_PP_STATUS — NOT NULL
- MTART (자재유형) — ZC102E_MM_MTART
ZC102PPT0014 (사료 생산오더)
- PDONO (생산오더번호) — ZC102E_PP_PDONO — Primary key — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key — NOT NULL
- WKCNO (WORK CENTER 번호) — ZC102E_PP_WKCNO — Primary key — NOT NULL
- WERKS (PLANT 번호) — ZC102E_PP_WERKS — Primary key — NOT NULL
- ROUNO (라우팅 번호) — ZC102E_PP_ROUNO
- MENGE (수량) — ZC102E_MM_MENGE
- MEINS (단위) — MEINS
- BOMNO (BOM번호) — ZC102E_PP_BOMNO
- PDSTT (생산 시작일) — ZC102E_PP_PDSTT
- PDFNS (생산 종료일) — ZC102E_PP_PDFNS
- MKSTA (생산 진행 상태) — ZC102E_PP_MKSTA
- PROG (진행률) — ZC102E_PP_PROG
- P_UNIT (진행 단위) — ZC102E_PP_PUNIT
- STLNO (창고번호) — ZC102E_MM_STLNO
ZC102PPT0015 (계획오더 (I) 긴급 판매용)
- PLONO (계획오더번호) — ZC102E_PP_PLONO — Primary key — NOT NULL
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key
- MENGE (수량) — ZC102E_MM_MENGE
- MEINS (단위) — MEINS
- STLNO (창고번호) — ZC102E_MM_STLNO
- DATUM (날짜) — DATUM
ZC102SDT0001 (고객 마스터)
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Foreign key → ZC102SDT0002.CUSNO
- CTLZL (신용평가2) — ZC102E_SD_CTLZL — Foreign key → ZC102SDT0002.CTLZL
- NAME1 (고객명) — ZC102E_SD_NAME1
- TELF1 (연락처) — ZC102E_SD_TELF1
- EMAIL (이메일 주소) — ZC102E_MM_EMAIL
- STRAS (주소) — ZC102E_SD_STRAS
- KNKLI (고객 등급) — ZC102E_SD_KNKLI
- WAERS (통화키) — WAERS
- CTLZL (신용평가) — ZC102E_SD_CTLZL
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
ZC102SDT0002 (고객 등급 마스터)
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Primary key
- KNKLI (고객등급) — ZC102E_SD_KNKLI — Foreign key → ZC102SDT0003.KNKLI
- CTLZL (신용평가) — ZC102E_SD_CTLZL — Foreign key → ZC102SDT0003.CTLZL
- EVADA (등급 평가일) — ZC102E_SD_EVADA
- DISMO (할인가) — ZC102E_SD_DISMO
- WAERS (통화키) — WAERS
- KBETR (할인율) — ZC102E_SD_KBETR
ZC102SDT0003 (고객 정책)
- KNKLI (고객등급) — ZC102E_SD_KNKLI — Primary key
- CTLZL (신용평가) — ZC102E_SD_CTLZL — Primary key
- KBETR (할인율) — ZC102E_SD_KBETR
ZC102SDT0004 (납품 헤더)
- VBELN_DEL (납품오더 번호) — ZC102E_SD_VBELND — Primary key
- VBELN_SO (판매오더 번호) — ZC102E_SD_VBELNS — Foreign key → ZC102SDT0006.VBELN_SO
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102SDT0006.PARTNER — NOT NULL
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Foreign key → ZC102SDT0006.CUSNO
- FINALSP (금액) — ZC102E_FI_AWRBTR
- WAERS (통화키) — WAERS
- DREAL (배송실시작일) — ZC102E_SD_DREAL
- DDONE (납품완료일) — ZC102E_SD_DDONE
- VDATU (납품예정일) — ZC102E_SD_VDATU
- WADAT_IST (배송 시작예정일) — ZC102E_SD_WADAT_IST
- GBSTK (배송 상태) — ZC102E_SD_GBSTK
- ISEME (납품 유형) — ZC102E_SD_ISEME
- STATE (납품 상태) — ZC102E_SD_STATE
- VBELN_BIL (송장번호) — ZC102E_SD_VBELNB
ZC102SDT0005 (납품 아이템)
- VBELN_DEL (납품오더 번호) — ZC102E_SD_VBELND — Foreign key → ZC102SDT0004.VBELN_DEL
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0001.MATNR — NOT NULL
- STLNO (창고번호) — ZC102E_MM_STLNO — Foreign key → ZC102MMT0001.STLNO — NOT NULL
- VBELN_SO (판매오더 번호) — ZC102E_SD_VBELNS — Foreign key → ZC102SDT0004.VBELN_SO
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102SDT0004.PARTNER — NOT NULL
- STPRS (제품 원가) — ZC102E_SD_STPRS
- WAERS (통화키) — WAERS
- MENGE (수량) — MENGE_D
- MEINS (단위) — MEINS
- BWART (자재 이동 유형) — ZC102E_SD_BWART
ZC102SDT0006 (판매오더 헤더)
- VBELN_SO (판매오더 번호) — ZC102E_SD_VBELNS — Primary key
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Foreign key → ZC102SDT0001.CUSNO
- ORTYPE (판매오더 유형) — ZC102E_SD_ORTYPE
- MENGE (총 주문수량) — ZC102E_SD_MENGE
- AUDAT (주문 일자) — ZC102E_SD_AUDAT
- NETWR (총 판매가) — ZC102E_SD_NETWR
- WAERS (통화키) — WAERS
- DELID (납품일) — ZC102E_SD_DELID
- RDATE (생산 요청일) — ZC102E_SD_RDATE
- STATE (판매오더 처리상태) — ZC102E_SD_CHECK
- FINALSP (금액) — ZC102E_FI_AWRBTR
- KBETR (할인율) — ZC102E_SD_KBETR
- DISMO (할인가) — ZC102E_SD_DISMO
- MRP_ST (MRP 상태) — ZC102E_SD_MRP_ST
- STAX (부가세) — ZC102E_FI_AWRBTR
- ISREG (정기/비정기적 주문) — ZC102E_SD_ISREG
ZC102SDT0007 (판매오더 아이템)
- MATNR (자재번호) — ZC102E_MM_MATNR — Primary key
- VBELN_SO (판매오더 번호) — ZC102E_SD_VBELNS — Foreign key → ZC102SDT0006.VBELN_SO
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102SDT0006.PARTNER — NOT NULL
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Foreign key → ZC102SDT0006.CUSNO
- PEQUAN (주문 수량) — ZC102E_MM_PEQUAN
- PPMEN (생산 필요 수량) — ZC102E_SD_PPMEN
- MEINS (BUM) — MEINS
- STPRS (제품 원가) — ZC102E_SD_STPRS
- SCOST (판매가) — ZC102E_SD_SCOST
- NETWR (총 판매가) — ZC102E_SD_NETWR
- WAERS (통화키) — WAERS
- STATUS (긴급판매오더 승인 상태) — ZC102E_SD_ESTATUS
ZC102SDT0008 (수요 예측 및 평가)
- YEAR_SD (연도) — ZC102E_SD_YEAR — Primary key
- QUART_SD (분기) — ZC102E_SD_NUMC — Primary key
- MONTH_SD (월) — ZC102E_SD_MONTH — Primary key
- MATNR (자재번호) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0004.MATNR — NOT NULL
- WERKS (Plant 번호) — ZC102E_PP_WERKS — Foreign key → ZC102MMT0008.WERKS — NOT NULL
- MPPOS (예상 판매량) — ZC102E_SD_MPPOS
- KWMENG (실제 판매량) — ZC102E_SD_KWMENG
- ERROR (오차율) — ZC102E_SD_ERROR
- WEMNG (생산량) — ZC102E_PP_WEMNG
- KNUMV (총 매출액) — ZC102E_SD_KNUMV
- KWERT (총 매출원가) — ZC102E_SD_KWERT
- MEINS (단위) — MEINS
- WAERS (통화키) — WAERS
ZC102SDT0009 (대금청구)
- BELNR (전표번호) — ZC102E_SD_BELNR — Primary key — NOT NULL
- VBELN_BIL (송장번호) — ZECL102VBELNB — Foreign key → ZC102MMT0015.VBELN_BIL — NOT NULL
- MATNR (자재번호2) — ZC102E_MM_MATNR — Foreign key → ZC102MMT0015.MATNR
- PRNO (구매요청번호2) — ZC102E_MM_PRNO — Foreign key → ZC102MMT0015.PRNO — NOT NULL
- PAYCO (지불 방식) — ZC102E_SD_PAYCO
- NETWR (총 판매가) — ZC102E_SD_NETWR
- WAERS (통화키) — WAERS
- PRCTR (프로핏 센터) — ZC102E_CO_PRCTR — Foreign key → ZC102COT0004.PRCTR — NOT NULL
- KOKRS (관리 회계 영역) — ZC102E_CO_KOKRS — Foreign key → ZC102COT0004.KOKRS — NOT NULL
ZC102SDT0010 (고객 완제품 출고 창고)
- MTYPE (신선/가공) — ZC102E_MM_MTYPE — Primary key — NOT NULL
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102BPT0001.PARTNER — NOT NULL
- CUSNO (고객번호) — ZC102E_SD_KUNNR — Foreign key → ZC102SDT0001.CUSNO
- STRAS (주소) — ZC102E_SD_STRAS
- WERKS (Plant 번호) — ZC102E_PP_WERKS
- WKCNO (Work Center 번호) — ZC102E_PP_WKCNO
- STLNO (창고 번호) — ZC102E_MM_STLNO
ZC102SDT0011 (배송 정보 관리)
- VBELN_DEL (납품오더 번호) — ZC102E_SD_VBELND — Foreign key → ZC102SDT0004.VBELN_DEL
- PARTNER (BP 번호) — ZC102E_BP_PARTNER — Foreign key → ZC102SDT0004.PARTNER — NOT NULL
- ADRNR (배송지) — ZC102E_SD_ADRNR
- DEL_CHAR (배송 담당) — ZC102E_SD_DEL_CHAR
- VSBED (배송 방법) — ZC102E_SD_VSBED
- TELF1 (연락처) — ZC102E_SD_TELF1
- LEATI (배송리드타임) — ZC102E_PP_LEATI
and 3 more tables