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