FI ERD
Tables (20)
ZTC1F10002
- KTOPL — VARCHAR(4) — Primary key — NOT NULL — KTOPL: Chart of Accounts
- SAKNR — VARCHAR(10) — Primary key — NOT NULL — SAKNR: G/L Account Number
- GJAHR — VARCHAR(4) — Primary key — NOT NULL — GJAHR: Fiscal Year
- BELNR — VARCHAR(10) — Primary key — NOT NULL — BELNR_D: Accounting Document Number
- BUKRS — VARCHAR(4) — Primary key — NOT NULL — BUKRS: Company Code
- GJAHR — VARCHAR(4) — Primary key — NOT NULL — GJAHR: Fiscal Year
- BELNR — VARCHAR(10) — Primary key — NOT NULL — BELNR_D: Accounting Document Number
- BUZEI — VARCHAR(3) — Primary key — NOT NULL — BUZEI: Line Item Number
- BUKRS — VARCHAR(4) — Primary key — NOT NULL — BUKRS: Company Code
- ZAPRNO — VARCHAR(10) — Primary key — NOT NULL — ZEC1_FI_APPNO: 상신번호
- BUKRS — VARCHAR(4) — Primary key — NOT NULL — BUKRS: Company Code
- ZAPRNO — VARCHAR(10) — Primary key — NOT NULL — ZEC1_FI_APPNO: 상신번호
- ZSEQ — VARCHAR(3) — Primary key — NOT NULL — ZEC1_FI_SEQ: 라인 순번
- MANDT — VARCHAR(3) — Foreign key → ZTC1F10002.MANDT — NOT NULL — MANDT: Client
- BUKRS — VARCHAR(4) — Foreign key → ZTC1F10002.BUKRS — NOT NULL — BUKRS: Company Code
- BUKRS — VARCHAR(4) — Foreign key → ZTC1F10002.BUKRS — NOT NULL — BUKRS: Company Code
- BUTXT — VARCHAR(25) — BUTXT: Name of Company Code
- TXT20 — VARCHAR(20) — TXT20: G/L Account Short Text
- BLART — VARCHAR(2) — BLART: Document Type
- BUDAT — VARCHAR(8) — BUDAT: Posting Date
- HKONT — VARCHAR(10) — SAKNR: G/L Account Number
- WRBTR — DECIMAL(23, 2) — WRBTR: Amount in Doc Currency
- KOSTL — VARCHAR(10) — KOSTL: Cost Center
- ZSTATUS — VARCHAR(2) — ZEC1_FI_APST: 상신 상태
- BELNR — VARCHAR(10) — BELNR_D: 참조 전표번호
ZTC1FI0001
- KTOPL — CHAR(4) — Primary key — NOT NULL
- SAKNR — CHAR(10) — Primary key — NOT NULL
- MANDT — CHAR(3)
- TXT20 — VARCHAR(20)
- TXT50 — VARCHAR(50)
- FX_VAL_REL — CHAR(1)
- FX_VAL_TYPE — CHAR(1)
ZTC1FI0002
- BUKRS — CHAR(4) — Primary key — NOT NULL
- MANDT — CHAR(3)
- BUTXT — VARCHAR(25)
- ORT01 — VARCHAR(25)
- LAND1 — CHAR(3)
- PSTLZ — CHAR(10)
- STRAS — VARCHAR(35)
- WAERS — CHAR(5)
- KTOPL — CHAR(4) — Foreign key → ZTC1FI0001.KTOPL
- PERIV — CHAR(2)
- KOKFI — CHAR(1)
- KKBER — CHAR(4)
- RCOMP — CHAR(6)
- STCEG — CHAR(20)
- XVATDATE — CHAR(1)
ZTC1FI0005
- BLART — CHAR(2) — Primary key — NOT NULL
- MANDT — CHAR(3)
- NUMKR — CHAR(2)
- STBLA — CHAR(2) — Foreign key → ZTC1FI0005.BLART
ZTC1FI0006
- GJAHR — CHAR(4) — Primary key — NOT NULL
- BELNR — CHAR(10) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- BLART — CHAR(2)
- BUDAT — CHAR(8)
- BLDAT — CHAR(8)
- MONAT — CHAR(2)
- WAERS — CHAR(5)
- XBLNR — CHAR(16)
- BKTXT — VARCHAR(25)
- AWTYP — CHAR(5)
- AWKEY — CHAR(20)
- KURSF — DECIMAL(9,5)
- BSTAT — CHAR(1)
- HBKID — CHAR(5)
- HKTID — CHAR(5)
- STBLG — CHAR(10)
- STJAH — CHAR(4)
- STGRD — CHAR(2)
ZTC1FI0007
- BUZEI — CHAR(3) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0006.BUKRS — NOT NULL
- GJAHR — CHAR(4) — Foreign key → ZTC1FI0006.GJAHR — NOT NULL
- BELNR — CHAR(10) — Foreign key → ZTC1FI0006.BELNR — NOT NULL
- MANDT — CHAR(3)
- BSCHL — CHAR(2)
- SHKZG — CHAR(1)
- HKONT — CHAR(10)
- KUNNR — CHAR(5)
- LIFNR — CHAR(5)
- WRBTR — DECIMAL(23,2)
- WAERS — CHAR(5)
- DMBTR — DECIMAL(23,2)
- HWAER — CHAR(5)
- PRCTR — CHAR(10)
- SGTXT — VARCHAR(50)
- ZTERM — CHAR(4)
- AUGBL — CHAR(10)
- AUGDT — CHAR(8)
- KOART — CHAR(1)
- KOSTL — CHAR(10)
- AUFNR — CHAR(12)
- MWSKZ — CHAR(2)
- GSBER — CHAR(4)
- BUDAT — CHAR(8)
- ZFBDT — CHAR(8)
- REBZG — CHAR(10)
- RSTGR — CHAR(3)
ZTC1FI0008
- HBKID — CHAR(5) — Primary key — NOT NULL
- HKTID — CHAR(5) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- BANKS — CHAR(3)
- BANKA — VARCHAR(60)
- BANKL — CHAR(15)
- BANKN — CHAR(18)
- WAERS — CHAR(5)
- HKONT — CHAR(10)
ZTC1FI0020
- KTOPL — CHAR(4) — Primary key — NOT NULL
- ZMODULE — CHAR(2) — Primary key — NOT NULL
- MM_EVENT — CHAR(2) — Primary key — NOT NULL
- BWART — CHAR(3) — Primary key — NOT NULL
- ZLINE_SEQ — CHAR(3) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- KTOSL — CHAR(3)
- SHKZG — CHAR(1)
ZTC1FI0021
- KTOPL — CHAR(4) — Primary key — NOT NULL
- KTOSL — CHAR(3) — Primary key — NOT NULL
- BKLAS — CHAR(4) — Primary key — NOT NULL
- WERKS — CHAR(4) — Primary key — NOT NULL
- KOMOK — CHAR(3) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- SAKNR — CHAR(10)
- ZGL_ROLE — VARCHAR(20)
ZTC1FI0022
- KTOPL — CHAR(4) — Primary key — NOT NULL
- ZMODULE — CHAR(2) — Primary key — NOT NULL
- SD_EVENT — CHAR(4) — Primary key — NOT NULL
- ACCOUNT_KEY — CHAR(4) — Primary key — NOT NULL
- ZLINE_SEQ — CHAR(3) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- KTOSL — CHAR(3)
- SHKZG — CHAR(1)
ZTC1FI0023
- KTOPL — CHAR(4) — Primary key — NOT NULL
- KTOSL — CHAR(3) — Primary key — NOT NULL
- VKORG — CHAR(4) — Primary key — NOT NULL
- KTGRD — CHAR(2) — Primary key — NOT NULL
- KTGRM — CHAR(2) — Primary key — NOT NULL
- SHKZG — CHAR(1) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- SAKNR — CHAR(10)
- ZGL_ROLE — VARCHAR(20)
ZTC1FI0024
- DUN_NO — CHAR(10) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- KUNNR — CHAR(5)
- DUN_DATE — CHAR(8)
- DUN_TIME — CHAR(6)
- DUN_LEVEL — CHAR(1)
- DUN_STATUS — CHAR(2)
- CHANNEL — VARCHAR(10)
- TOTAL_AMT — DECIMAL(23,2)
- WAERS — CHAR(5)
- INTEREST_RATE — DECIMAL(5,2)
- INTEREST_AMT — DECIMAL(23,2)
- APPROVE_DATE — CHAR(8)
- APPROVAL_STATUS — CHAR(1)
- APPROVER — CHAR(12)
- DUE_DATE — CHAR(8)
- LAST_DUN_NO — CHAR(10)
ZTC1FI0025
- SEQ — CHAR(3) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0024.BUKRS — NOT NULL
- DUN_NO — CHAR(10) — Foreign key → ZTC1FI0024.DUN_NO — NOT NULL
- MANDT — CHAR(3)
- REF_GJAHR — CHAR(4)
- REF_BELNR — CHAR(10)
- REF_BUZEI — CHAR(3)
- WRBTR — DECIMAL(23,2)
- WAERS — CHAR(5)
- DMBTR — DECIMAL(23,2)
- HWAER — CHAR(5)
- ZFBDT — CHAR(8)
- OVERDUE_DAYS — INT
ZTC1FI0026
- DUN_LEVEL — CHAR(1) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- LEVEL_NAME — VARCHAR(30)
- DAYS_FROM — INT
- DAYS_TO — INT
- INTEREST_RATE — DECIMAL(5,2)
- APPROVER_ROLE — VARCHAR(30)
- CHANNEL_DEFAULT — VARCHAR(10)
- TEMPLATE_TITLE — VARCHAR(100)
ZTC1FI0027
- KUNNR — CHAR(10) — Primary key — NOT NULL
- MEMO_NO — CHAR(5) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- MEMO_TYPE — CHAR(1)
- MEMO_TEXT — VARCHAR(255)
ZTC1FI0028
- FSV — CHAR(4) — Primary key — NOT NULL
- NODE_KEY — CHAR(20) — Primary key — NOT NULL
- HKONT — CHAR(10) — Foreign key → ZTC1FI0001.SAKNR — NOT NULL
- MANDT — CHAR(3)
- PARENT_NODE — CHAR(20)
- NODE_LEVEL — TINYINT
- NODE_TYPE — CHAR(1)
- NODE_TEXT — VARCHAR(60)
- STMT_TYPE — CHAR(2)
- FI_SECTION — CHAR(1)
- DC_IND — CHAR(1)
- CF_ACT — CHAR(1)
- SCE_COMP — CHAR(2)
- SORT_ORD — CHAR(8)
ZTC1FI0029
- ZAPRNO — CHAR(10) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- ZAPTYPE — CHAR(2)
- LIFNR — CHAR(5)
- WAERS — CHAR(5)
- ZAMT_TOT — DECIMAL(23,2)
- ZSTATUS — CHAR(2)
- ZREQ_USER — CHAR(12)
- ZREQ_DATE — CHAR(8)
- HBKID — CHAR(5)
- HKTID — CHAR(5)
- ZPAY_BELNR — CHAR(10)
- ZPAY_GJAHR — CHAR(4)
ZTC1FI0030
- ZSEQ — CHAR(3) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0029.BUKRS — NOT NULL
- ZAPRNO — CHAR(10) — Foreign key → ZTC1FI0029.ZAPRNO — NOT NULL
- MANDT — CHAR(3)
- GJAHR — CHAR(4)
- BELNR — CHAR(10)
- BUZEI — CHAR(3)
- LIFNR — CHAR(5)
- WRBTR — DECIMAL(23,2)
- WAERS — CHAR(5)
ZTC1FI0031
- ZSTEP — CHAR(2) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0029.BUKRS — NOT NULL
- ZAPRNO — CHAR(10) — Foreign key → ZTC1FI0029.ZAPRNO — NOT NULL
- MANDT — CHAR(3)
- ZGRADE — VARCHAR(10)
- ZAPPROVER — CHAR(12)
- ZAPPR_NAME — VARCHAR(20)
- ZSTEP_STAT — CHAR(1)
- ZSTEP_DATE — CHAR(8)
ZTC1FI0032
- ZAPTYPE — CHAR(2) — Primary key — NOT NULL
- ZAMT_FROM — DECIMAL(23,2) — Primary key — NOT NULL
- ZSTEP — CHAR(2) — Primary key — NOT NULL
- BUKRS — CHAR(4) — Foreign key → ZTC1FI0002.BUKRS — NOT NULL
- MANDT — CHAR(3)
- ZAMT_TO — DECIMAL(23,2)
- ZGRADE — VARCHAR(10)
- ZDEPT — VARCHAR(20)
- WAERS — CHAR(5)