SAP ERD 4
Tables (66)
ZTG4CM0001
- KUNNR — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0005.MANDT — NOT NULL
- VKORG — VARCHAR(4) — Foreign key → ZTG4CM0005.VKORG
- C_NAME — VARCHAR(40)
- KUKLA — VARCHAR(2)
- STCD1 — VARCHAR(10)
- REPNM — VARCHAR(20)
- BTYPC — VARCHAR(10)
- BIZTP — VARCHAR(15)
- LAND1 — VARCHAR(3)
- ORT01 — VARCHAR(30)
- STRAS — VARCHAR(80)
- LATITUDE — DECIMAL(9,6)
- LONGITUDE — DECIMAL(10,6)
- TELF1 — VARCHAR(20)
- EMAIL — VARCHAR(60)
- WAERS — VARCHAR(5)
- C_GRADE — VARCHAR(4)
ZTG4CM0002
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- MATNR — VARCHAR(18) — Primary key — NOT NULL
- MAKTX — VARCHAR(40)
- MTART — VARCHAR(4)
- MEINS — VARCHAR(3)
ZTG4CM0003
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- DATUM — DATE — Primary key — NOT NULL
- DUBAI_P — DECIMAL(13,2)
- BRENT_P — DECIMAL(13,2)
- WTI_P — DECIMAL(13,2)
- WAERS — VARCHAR(5)
- MEINS — VARCHAR(3)
ZTG4CM0005
- VKORG — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0009.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS
- VTWEG — VARCHAR(6)
- SPART — VARCHAR(8)
- VTEXT — VARCHAR(40)
- WAERS — VARCHAR(5)
ZTG4CM0006
- PERNR — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0010.MANDT — NOT NULL
- ENAME — VARCHAR(40)
- ORGEH — VARCHAR(10) — Foreign key → ZTG4CM0010.ORGEH
- PLANS — VARCHAR(3)
- EMAIL — VARCHAR(60)
- TELF1 — VARCHAR(20)
- ERDAT — DATE
- SALRY — DECIMAL(15,2)
- WAERS — VARCHAR(5)
ZTG4CM0007
- LIFNR — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- CSNR — VARCHAR(50)
- STCD1 — VARCHAR(10)
- REPNM — VARCHAR(20)
- BTYPC — VARCHAR(10)
- BIZTP — VARCHAR(15)
- LAND1 — VARCHAR(3)
- ORT01 — VARCHAR(30)
- STRAS — VARCHAR(80)
- LATITUDE — DECIMAL(9,6)
- LONGITUDE — DECIMAL(10,6)
- TELF1 — VARCHAR(20)
- EMAIL — VARCHAR(60)
- WAERS — VARCHAR(5)
- BANKL — VARCHAR(15)
- BANKN — VARCHAR(18)
ZTG4CM0008
- WERKS — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0009.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS
- P_NAME — VARCHAR(50)
- LAND1 — VARCHAR(3)
- ORT01 — VARCHAR(30)
- STRAS — VARCHAR(80)
- LATITUDE — DECIMAL(9,6)
- LONGITUDE — DECIMAL(10,6)
ZTG4CM0009
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- BUKRS — VARCHAR(4) — Primary key — NOT NULL
- BUTXT — VARCHAR(8)
- LAND1 — VARCHAR(3)
- STCD1 — VARCHAR(10)
- REPNM — VARCHAR(20)
- BTYPC — VARCHAR(10)
- BIZTP — VARCHAR(15)
- ORT01 — VARCHAR(30)
- STRAS — VARCHAR(80)
- WAERS — VARCHAR(5)
ZTG4CM0010
- ORGEH — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0009.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS
- ORGTX — VARCHAR(10)
- TELF1 — VARCHAR(20)
ZTG4CM0011
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- GDATU — DATE — Primary key — NOT NULL
- UKURS — DECIMAL(15,2)
- FCURR — VARCHAR(5)
- TCURR — VARCHAR(5)
ZTG4CM0012
- ERRDT — DATE — Primary key — NOT NULL
- ERRTM — TIME — Primary key — NOT NULL
- SEQNO — VARCHAR(3) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0011.MANDT — NOT NULL
- GDATU — DATE — Foreign key → ZTG4CM0011.GDATU
- ERR_TYPE — VARCHAR(20)
- ERR_MSG — VARCHAR(255)
- ERRNM — VARCHAR(12)
ZTG4CO0001
- KSTAR — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4FI0005.MANDT — NOT NULL
- COST_TYPE — VARCHAR(4)
- SAKNR — VARCHAR(6) — Foreign key → ZTG4FI0005.SAKNR
- KSTAR_NAME — VARCHAR(40)
- COST_BHV — VARCHAR(1)
ZTG4CO0002
- KOSTL — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0008.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS — NOT NULL
- ORGEH — VARCHAR(10) — Foreign key → ZTG4CM0010.ORGEH
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- KOSTL_NAME — VARCHAR(40)
ZTG4CO0003
- PRCTR — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- PRCTR_NAME — VARCHAR(40)
ZTG4CO0004
- DIST_ID — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0009.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS
- GJAHR — VARCHAR(4)
- HALFY — VARCHAR(2)
- AUART — VARCHAR(4)
- YWEIGHT — DECIMAL(7,2)
- NWEIGHT — DECIMAL(7,2)
- LOSS_RATE — DECIMAL(7,2)
ZTG4CO0005
- COST_DA_NO — VARCHAR(10) — Primary key — NOT NULL
- COST_DA_ITEM — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CO0002.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CO0002.BUKRS — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS — NOT NULL
- KSTAR — VARCHAR(10) — Foreign key → ZTG4CO0001.KSTAR
- KSTAR_NAME — VARCHAR(40)
- KOSTL — VARCHAR(10) — Foreign key → ZTG4CO0002.KOSTL
- KOSTL_NAME — VARCHAR(40)
- GJAHR — VARCHAR(4)
- MONAT — VARCHAR(2)
- DMBTR — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- XBLNR — VARCHAR(20)
ZTG4CO0006
- PA_DOC_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CO0007.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- COST_DA_NO — VARCHAR(10)
- PRCTR — VARCHAR(10)
- ALLOC_NO — VARCHAR(10) — Foreign key → ZTG4CO0007.ALLOC_NO
- HALFY — VARCHAR(2)
- GJAHR — VARCHAR(4)
- NETPR — DECIMAL(13,2)
- REVENUE — DECIMAL(15,2)
- UNIT_COST — DECIMAL(15,2)
- VAR_COST — DECIMAL(15,2)
- FIXED_COST — DECIMAL(15,2)
- COGS_AMT — DECIMAL(15,2)
- GP_AMT — DECIMAL(15,2)
- CM_AMT — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- MENGE — DECIMAL(13,3)
- MEINS — VARCHAR(3)
ZTG4CO0007
- ALLOC_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0006.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- GJAHR — VARCHAR(4)
- HALFY — VARCHAR(2)
- SUM_COST — DECIMAL(15,2)
- TOT_PCOST — DECIMAL(15,2)
- NON_ACOST — DECIMAL(15,2)
- TOT_ACOST — DECIMAL(15,2)
- DIFF_AMT — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- PERNR — VARCHAR(10) — Foreign key → ZTG4CM0006.PERNR
ZTG4CO0008
- ALLOC_ITEM — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- ALLOC_NO — VARCHAR(10) — Foreign key → ZTG4CO0007.ALLOC_NO — NOT NULL
- COST_DA_NO — VARCHAR(10)
- DIST_ID — VARCHAR(10) — Foreign key → ZTG4CO0004.DIST_ID
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- MAKTX — VARCHAR(40)
- PRCTR — VARCHAR(10)
- PRCTR_NAME — VARCHAR(40)
- ALLOC_RATE — DECIMAL(5,2)
- YIELD_RATE — DECIMAL(5,2)
- NRV_AMT — DECIMAL(15,2)
- ITM_ACOST — DECIMAL(15,2)
- MENGE — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- UNIT_COST — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- LOSS_RATE — DECIMAL(7,2)
ZTG4CO0009
- PLAN_ID — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CO0007.MANDT — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- GJAHR — VARCHAR(4)
- HALFY — VARCHAR(2)
- PLAN_QTY — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- PLAN_UCOST — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- STD_DATE — DATE
- ALLOC_NO — VARCHAR(10) — Foreign key → ZTG4CO0007.ALLOC_NO
ZTG4CO0010
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- AUART — VARCHAR(4) — Primary key — NOT NULL
- MAT_TYPE — VARCHAR(4) — Primary key — NOT NULL
- ROLE_TYPE — VARCHAR(4) — Primary key — NOT NULL
- ALLOC_YN — VARCHAR(1)
ZTG4FI0001
- BELNR — VARCHAR(10) — Primary key — NOT NULL
- GJAHR — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0006.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CM0009.BUKRS — NOT NULL
- BLART — VARCHAR(2) — Foreign key → ZTG4FI0003.BLART
- MONAT — VARCHAR(2)
- BLDAT — DATE
- BUDAT — DATE
- STATUS — VARCHAR(4)
- BKTXT — VARCHAR(2)
- WAERS — VARCHAR(50)
- XBLNR — VARCHAR(5)
- XBLNR_TYPE — VARCHAR(20)
- STBLG — VARCHAR(4)
- STJAH — VARCHAR(10)
- ZREASON_ID — VARCHAR(4) — Foreign key → ZTG4FI0007.ZREASON_ID
- ZREASON_ID2 — VARCHAR(4)
- PERNR1 — VARCHAR(10) — Foreign key → ZTG4CM0006.PERNR
- PERNR2 — VARCHAR(10) — Foreign key → ZTG4CM0006.PERNR
- PROC_TYPE — VARCHAR(4)
ZTG4FI0002
- BELNR_ITEM — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0011.MANDT — NOT NULL
- BELNR — VARCHAR(10) — Foreign key → ZTG4FI0001.BELNR — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4CO0003.BUKRS — NOT NULL
- GJAHR — VARCHAR(4) — Foreign key → ZTG4FI0001.GJAHR — NOT NULL
- SAKNR — VARCHAR(6) — Foreign key → ZTG4FI0005.SAKNR
- MWSKZ — VARCHAR(2) — Foreign key → ZTG4FI0004.MWSKZ
- KUNNR — VARCHAR(10) — Foreign key → ZTG4CM0001.KUNNR
- LIFNR — VARCHAR(10) — Foreign key → ZTG4CM0007.LIFNR
- KOSTL — VARCHAR(10) — Foreign key → ZTG4CO0002.KOSTL
- PRCTR — VARCHAR(10) — Foreign key → ZTG4CO0003.PRCTR
- GDATU — DATE — Foreign key → ZTG4CM0011.GDATU
- UKURS — DECIMAL(15,2)
- SHKZG — VARCHAR(1)
- WAERS1 — VARCHAR(5)
- DMBTR — DECIMAL(15,2)
- WAERS2 — VARCHAR(5)
- WRBTR — DECIMAL(15,2)
- AUGBL — VARCHAR(10)
- AUGDT — DATE
- SGTXT — VARCHAR(50)
ZTG4FI0003
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- BLART — VARCHAR(2) — Primary key — NOT NULL
- LTEXT — VARCHAR(20)
- XXBLNR — VARCHAR(1)
ZTG4FI0004
- MWSKZ — VARCHAR(2) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4FI0005.MANDT — NOT NULL
- SAKNR — VARCHAR(6) — Foreign key → ZTG4FI0005.SAKNR
- MWSKZ_NAME — VARCHAR(20)
- MWSKZ_TYPE — VARCHAR(1)
- KBETR — DECIMAL(5,2)
ZTG4FI0005
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- SAKNR — VARCHAR(6) — Primary key — NOT NULL
- SAKNR_NAME — VARCHAR(40)
- ACCOUNT_TYPE — VARCHAR(1)
- KTOKS — VARCHAR(4)
- KTOKS_NM — VARCHAR(20)
- KTOKS_MID — VARCHAR(4)
- KTOMID_NM — VARCHAR(40)
- TAX_REQ — VARCHAR(1)
ZTG4FI0006
- TAX_ID — VARCHAR(24) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4SD0007.MANDT — NOT NULL
- BUKRS — VARCHAR(4) — Foreign key → ZTG4FI0001.BUKRS
- BELNR — VARCHAR(10) — Foreign key → ZTG4FI0001.BELNR
- KUNNR — VARCHAR(10) — Foreign key → ZTG4CM0001.KUNNR
- BILLING_NO — VARCHAR(10) — Foreign key → ZTG4SD0007.BILLING_NO
- GJAHR — VARCHAR(4) — Foreign key → ZTG4FI0001.GJAHR — NOT NULL
- TAX_TYPE — VARCHAR(2)
- SUPPLY_AMT — DECIMAL(15,2)
- MWSBP — DECIMAL(15,2)
- ISSUE_DAT — DATE
- WAERS — VARCHAR(5)
ZTG4FI0007
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- ZREASON_ID — VARCHAR(4) — Primary key — NOT NULL
- ZR_TYPE — VARCHAR(2)
- ZR_NAME — VARCHAR(25)
ZTG4MM0001
- TANK_ID — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- T_NAME — VARCHAR(20)
- TANK_TYPE — VARCHAR(10)
- MAX_CAPACITY — DECIMAL(13,3)
- MIN_CAPACITY — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- WARN_CAPACITY — DECIMAL(13,3)
ZTG4MM0002
- INSP_ID — VARCHAR(8) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR — NOT NULL
- INSP_NM — VARCHAR(40)
- INSP_TYPE — VARCHAR(2)
- SOLLWERT — DECIMAL(5,4)
- TOLERANZ_L — DECIMAL(5,4)
- TOLERANZ_U — DECIMAL(5,4)
- MSEHI — VARCHAR(3)
ZTG4MM0003
- EBELN — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0007.MANDT — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- LIFNR — VARCHAR(10) — Foreign key → ZTG4CM0007.LIFNR
- PO_MONTH — VARCHAR(6)
- BEDAT — DATE
- PO_STATUS — VARCHAR(4)
- TOTAL_QTY — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- TOTAL_AMT — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- REJ_REASON — VARCHAR(4)
- REJ_TXT — VARCHAR(30)
- PERNR1 — VARCHAR(10)
- PERNR2 — VARCHAR(10)
ZTG4MM0004
- EBELP — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- EBELN — VARCHAR(10) — Foreign key → ZTG4MM0003.EBELN — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- LFDAT — DATE
- REG_QTY — DECIMAL(13,3)
- ADD_QTY — DECIMAL(13,3)
- MENGE — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- NETPR — DECIMAL(15,2)
- NETWR — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- PRICE_DATE — DATE
ZTG4MM0005
- STOCK_ID — VARCHAR(12) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0008.MANDT — NOT NULL
- TANK_ID — VARCHAR(10) — Foreign key → ZTG4MM0001.TANK_ID — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- BUCHM — DECIMAL(13,3)
- ERFMG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- LABST — DECIMAL(13,3)
- INSME — DECIMAL(13,3)
- SPEME — DECIMAL(13,3)
ZTG4MM0006
- INFNR — VARCHAR(10) — Primary key — NOT NULL
- PRDAT — DATE — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- LIFNR — VARCHAR(10) — Foreign key → ZTG4CM0007.LIFNR — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR — NOT NULL
- NETPR — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- MIN_AMT — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- LEADTIME — VARCHAR(3)
- DUTY_RATE — DECIMAL(5,2)
- IMPORT_AMT — DECIMAL(4,2)
- IMPORT_UNIT — VARCHAR(10)
- VAT_RATE — DECIMAL(5,2)
- ZTERM — VARCHAR(4)
ZTG4MM0007
- STORE_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4MM0003.MANDT — NOT NULL
- LIFNR — VARCHAR(10) — Foreign key → ZTG4CM0007.LIFNR
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- EBELN — VARCHAR(10) — Foreign key → ZTG4MM0003.EBELN
- STORE_DATE — DATE
- STORE_STATUS — VARCHAR(4)
- MENGE_AMT — DECIMAL(13,3)
- GAMNG_AMT — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- PERNR1 — VARCHAR(10)
ZTG4MM0008
- STORE_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4MM0001.MANDT — NOT NULL
- STORE_NO — VARCHAR(10) — Foreign key → ZTG4MM0007.STORE_NO — NOT NULL
- EBELN — VARCHAR(10) — Foreign key → ZTG4MM0004.EBELN
- EBELP — VARCHAR(10) — Foreign key → ZTG4MM0004.EBELP
- STOCK_ID — VARCHAR(12)
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- TANK_ID — VARCHAR(10) — Foreign key → ZTG4MM0001.TANK_ID
- MENGE — DECIMAL(13,3)
- GAMNG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- SITEM_DAT — DATE
- SITEM_ST — VARCHAR(4)
ZTG4MM0009
- XBLNR — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0007.MANDT — NOT NULL
- EBELN — VARCHAR(10) — Foreign key → ZTG4MM0003.EBELN
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- LIFNR — VARCHAR(10) — Foreign key → ZTG4CM0007.LIFNR
- POST_STATUS — VARCHAR(1)
- BLDAT — DATE
- BUDAT — DATE
- TOTAL_QTY — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- TOTAL_AMT — DECIMAL(15,2)
- WAERS — VARCHAR(5)
ZTG4MM0011
- PRUEFLOS — VARCHAR(12) — Primary key — NOT NULL
- STORE_ITEM — VARCHAR(6) — Primary key — NOT NULL
- INSP_ID — VARCHAR(8) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0008.MANDT — NOT NULL
- STORE_NO — VARCHAR(10) — Foreign key → ZTG4MM0007.STORE_NO
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- TANK_ID — VARCHAR(10) — Foreign key → ZTG4MM0001.TANK_ID
- STOCK_ID — VARCHAR(12)
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- PASTRTERM — DATE
- VBEWERT — VARCHAR(4)
- STATUS — VARCHAR(1)
- ZRESULT — DECIMAL(13,2)
- MSEHI — VARCHAR(3)
ZTG4MM0012
- MDOCM — VARCHAR(10) — Primary key — NOT NULL
- REF_TYPE — VARCHAR(2) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0008.MANDT — NOT NULL
- REF_NO — VARCHAR(10)
- REF_ITEM — VARCHAR(6)
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- STOCK_ID — VARCHAR(12)
- ACTQT — DECIMAL(13,3)
- LOSQT — DECIMAL(13,3)
- LOSRT — DECIMAL(5,2)
- TEMPER — DECIMAL(5,2)
- DENSITY — DECIMAL(13,2)
- STDQT — DECIMAL(13,3)
- DIFFQT — DECIMAL(13,2)
- DIFFRT — DECIMAL(5,2)
- MEINS — VARCHAR(3)
- MDATE — DATE
ZTG4MM0013
- MANDT — VARCHAR(3) — Foreign key → ZTG4PP0004.MANDT — NOT NULL
- EBELN — VARCHAR(10) — Foreign key → ZTG4MM0004.EBELN — NOT NULL
- EBELP — VARCHAR(10) — Foreign key → ZTG4MM0004.EBELP — NOT NULL
- BANFN — VARCHAR(10) — Foreign key → ZTG4PP0004.BANFN — NOT NULL
- BANFN_ITEM — VARCHAR(6) — Foreign key → ZTG4PP0004.BANFN_ITEM — NOT NULL
- MATNR — VARCHAR(18)
- REQ_TYPE — DECIMAL(13,3)
- MAP_QTY — DECIMAL(13,3)
- MEINS — VARCHAR(3)
ZTG4PP0001
- ARBPL — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0008.MANDT — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS — NOT NULL
- W_NAME — VARCHAR(40)
- VERWE — VARCHAR(2)
- KAPAZ — DECIMAL(13,3)
- MEINS — VARCHAR(3)
ZTG4PP0002
- ROUTING_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- ROUTIN_NM — VARCHAR(40)
- MATNR_IN — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
ZTG4PP0003
- BANFN — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0006.MANDT — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- PERNR — VARCHAR(10) — Foreign key → ZTG4CM0006.PERNR
- ARBPL — VARCHAR(4)
- BADAT — DATE
- REQ_STATUS — VARCHAR(4)
- PLDAT — DATE
- REQ_TYPE — VARCHAR(1)
ZTG4PP0004
- BANFN_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- BANFN — VARCHAR(10) — Foreign key → ZTG4PP0003.BANFN — NOT NULL
- PPLAN_NO — VARCHAR(10)
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- PORDER_NO — VARCHAR(10)
- MAKTX — VARCHAR(40)
- MENGE — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- LFDAT — DATE
ZTG4PP0005
- PPLAN_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4PP0002.MANDT — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- ARBPL — VARCHAR(4)
- STOCK_ID — VARCHAR(12)
- DATUM — DATE
- GJAHR — VARCHAR(4)
- MONAT — VARCHAR(2)
- ROUTING_NO — VARCHAR(10) — Foreign key → ZTG4PP0002.ROUTING_NO
- PERNR1 — VARCHAR(10)
- PERNR2 — VARCHAR(10)
ZTG4PP0006
- PPLAN_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- PPLAN_NO — VARCHAR(10) — Foreign key → ZTG4PP0005.PPLAN_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- PLNMG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- INPUT_QTY — DECIMAL(13,3)
- ROUTING_ITEM — VARCHAR(4)
ZTG4PP0007
- PORDER_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4PP0002.MANDT — NOT NULL
- STOCK_ID — VARCHAR(12)
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- ARBPL — VARCHAR(4)
- PREQ_NO — VARCHAR(10)
- PPLAN_NO — VARCHAR(10) — Foreign key → ZTG4PP0005.PPLAN_NO
- PRUEFLOS — VARCHAR(10)
- ROUTING_NO — VARCHAR(10) — Foreign key → ZTG4PP0002.ROUTING_NO
- AUART — VARCHAR(4)
- BSTRS — DATE
- GSTRI — DATE
- BLTRS — DATE
- GLTRI — DATE
- OR_STATUS — VARCHAR(5)
- REJ_REASON — VARCHAR(4)
- REJ_TXT — VARCHAR(30)
- GAMNG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- REQ_TYPE — VARCHAR(1)
- PERNR1 — VARCHAR(10)
- PERNR2 — VARCHAR(10)
ZTG4PP0008
- PORDER_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- PORDER_NO — VARCHAR(10) — Foreign key → ZTG4PP0007.PORDER_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- STOCK_ID — VARCHAR(12)
- TANK_ID — VARCHAR(10)
- EXP_QTY — DECIMAL(13,3)
- MEINS — VARCHAR(3)
ZTG4PP0009
- PRODUCE_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0008.MANDT — NOT NULL
- PORDER_NO — VARCHAR(10) — Foreign key → ZTG4PP0007.PORDER_NO
- ROUTING_NO — VARCHAR(10) — Foreign key → ZTG4PP0002.ROUTING_NO
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- ARBPL — VARCHAR(4)
- GSTRP — DATE
- GLTRP — DATE
- INPUT_QTY — DECIMAL(13,3)
- INPUT_UOM — VARCHAR(3)
ZTG4PP0010
- PRODUCE_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- PRODUCE_NO — VARCHAR(10) — Foreign key → ZTG4PP0009.PRODUCE_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- TANK_ID — VARCHAR(10)
- STOCK_ID — VARCHAR(12)
- YIELD_RATE — DECIMAL(5,2)
- MENGE — DECIMAL(13,3)
- MEINS — VARCHAR(3)
ZTG4PP0011
- INSP_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- PORDER_NO — VARCHAR(10) — Foreign key → ZTG4PP0007.PORDER_NO
- PRODUCE_NO — VARCHAR(10) — Foreign key → ZTG4PP0009.PRODUCE_NO
- PRODUCE_ITEM — VARCHAR(6)
- STOCK_ID — VARCHAR(12)
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- ARBPL — VARCHAR(4)
- INSP_ID — VARCHAR(8)
- QRESVAL — DECIMAL(5,2)
- MEINS — VARCHAR(3)
- MBEWERTG — VARCHAR(2)
- PASTRTERM — DATE
- INSP_STATUS — VARCHAR(2)
ZTG4PP0012
- ROUTING_ITEM — VARCHAR(4) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- ROUTING_NO — VARCHAR(10) — Foreign key → ZTG4PP0002.ROUTING_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- YIELD_RATE — DECIMAL(5,2)
- MEINS — VARCHAR(3)
ZTG4SD0001
- MANDT — VARCHAR(3) — Primary key — NOT NULL
- SPLAN_NO — VARCHAR(10) — Primary key — NOT NULL
- GJAHR — VARCHAR(4)
- HALF_PERIOD — VARCHAR(2)
- PERNR1 — VARCHAR(10)
- PERNR2 — VARCHAR(10)
- PLNPR_SUM — DECIMAL(15,2)
- WAERS — VARCHAR(5)
ZTG4SD0002
- SPLAN_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- SPLAN_NO — VARCHAR(10) — Foreign key → ZTG4SD0001.SPLAN_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- SPTYP — VARCHAR(2)
- MONAT — VARCHAR(2)
- BDMNG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- NETPR — DECIMAL(13,2)
- PLNPR — DECIMAL(15,2)
- WAERS — VARCHAR(5)
ZTG4SD0003
- SORDER_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0006.MANDT — NOT NULL
- KUNNR — VARCHAR(10) — Foreign key → ZTG4CM0001.KUNNR
- VKORG — VARCHAR(4) — Foreign key → ZTG4CM0005.VKORG
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- PERNR1 — VARCHAR(10) — Foreign key → ZTG4CM0006.PERNR
- PERNR2 — VARCHAR(10)
- AUART — VARCHAR(3)
- AUDAT — DATE
- VDATU — DATE
- ZTERM — VARCHAR(4)
- SO_STATUS — VARCHAR(4)
- REJ_REASON — VARCHAR(4)
- REJ_TXT — VARCHAR(30)
ZTG4SD0004
- SORDER_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- SORDER_NO — VARCHAR(10) — Foreign key → ZTG4SD0003.SORDER_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- STOCK_ID — VARCHAR(12)
- KWMENG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- NETPR — DECIMAL(13,2)
- WAERS — VARCHAR(5)
- SOI_STATUS — VARCHAR(4)
ZTG4SD0005
- DELIVERY_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0008.MANDT — NOT NULL
- SORDER_NO — VARCHAR(10) — Foreign key → ZTG4SD0003.SORDER_NO
- KUNNR — VARCHAR(10) — Foreign key → ZTG4CM0001.KUNNR
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- WADAT — DATE
- WADAT_IST — DATE
- AUART — VARCHAR(2)
- WBSTK — VARCHAR(4)
- BILL_STATUS — VARCHAR(1)
- PERNR1 — VARCHAR(10)
- PERNR2 — VARCHAR(10)
ZTG4SD0006
- DELIVERY_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4MM0001.MANDT — NOT NULL
- DELIVERY_NO — VARCHAR(10) — Foreign key → ZTG4SD0005.DELIVERY_NO — NOT NULL
- STOCK_ID — VARCHAR(12)
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- LFIMG — DECIMAL(13,3)
- ERFMG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- WBSTK_IT — VARCHAR(4)
- TANK_ID — VARCHAR(10) — Foreign key → ZTG4MM0001.TANK_ID
ZTG4SD0007
- BILLING_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4FI0004.MANDT — NOT NULL
- SORDER_NO — VARCHAR(10) — Foreign key → ZTG4SD0003.SORDER_NO
- DELIVERY_NO — VARCHAR(10) — Foreign key → ZTG4SD0005.DELIVERY_NO
- KUNNR — VARCHAR(10) — Foreign key → ZTG4CM0001.KUNNR
- MWSKZ — VARCHAR(2) — Foreign key → ZTG4FI0004.MWSKZ
- FKDAT — DATE
- DUE_DATE — DATE
- PERNR1 — VARCHAR(10)
- DELIVERY_FEE — DECIMAL(15,2)
- WAERS — VARCHAR(5)
ZTG4SD0008
- BILLING_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- BILLING_NO — VARCHAR(10) — Foreign key → ZTG4SD0007.BILLING_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- FKIMG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- NETPR — DECIMAL(13,2)
- NETWR — DECIMAL(15,2)
- MWSBP — DECIMAL(15,2)
- FUEL_TAX — DECIMAL(15,2)
- ITEM_AMT — DECIMAL(15,2)
- WAERS — VARCHAR(5)
ZTG4SD0009
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0005.MANDT — NOT NULL
- KUNNR — VARCHAR(10) — Foreign key → ZTG4CM0001.KUNNR — NOT NULL
- VKORG — VARCHAR(4) — Foreign key → ZTG4CM0005.VKORG
- KBETR — DECIMAL(5,2)
- DELIVERY_FEE — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- MEINS — VARCHAR(3)
- DELIVERY_PERIOD — VARCHAR(4)
ZTG4SD0010
- PDATU — DATE — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR — NOT NULL
- NETPR — DECIMAL(13,2)
- KOGOS — DECIMAL(13,2)
- SGAVP — DECIMAL(13,2)
- MRGRT — DECIMAL(5,2)
- MWSBP — DECIMAL(15,2)
- FUEL_TAX — DECIMAL(15,2)
- WAERS — VARCHAR(5)
- MEINS — VARCHAR(3)
ZTG4SD0011
- REQ_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4SD0003.MANDT — NOT NULL
- KUNNR — VARCHAR(10) — Foreign key → ZTG4CM0001.KUNNR
- AUART — VARCHAR(2)
- AUDAT — DATE
- VDATU — DATE
- ZTERM — VARCHAR(4)
- REQ_STATUS — VARCHAR(4)
- SORDER_NO — VARCHAR(10) — Foreign key → ZTG4SD0003.SORDER_NO
ZTG4SD0012
- REQ_ITEM — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0002.MANDT — NOT NULL
- REQ_NO — VARCHAR(10) — Foreign key → ZTG4SD0011.REQ_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- KWMENG — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- NETPR — DECIMAL(13,2)
- WAERS — VARCHAR(5)
ZTG4SD0013
- PREQ_NO — VARCHAR(10) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4CM0006.MANDT — NOT NULL
- SORDER_NO — VARCHAR(10) — Foreign key → ZTG4SD0003.SORDER_NO — NOT NULL
- WERKS — VARCHAR(4) — Foreign key → ZTG4CM0008.WERKS
- PERNR — VARCHAR(10) — Foreign key → ZTG4CM0006.PERNR
- BADAT — DATE
- LFDAT — DATE
- REQ_STATUS — VARCHAR(4)
- PERNR1 — VARCHAR(10)
- PERNR2 — VARCHAR(10)
ZTG4SD0014
- ITEM_NO — VARCHAR(6) — Primary key — NOT NULL
- MANDT — VARCHAR(3) — Foreign key → ZTG4PP0002.MANDT — NOT NULL
- PREQ_NO — VARCHAR(10) — Foreign key → ZTG4SD0013.PREQ_NO — NOT NULL
- MATNR — VARCHAR(18) — Foreign key → ZTG4CM0002.MATNR
- STOCK_ID — VARCHAR(12)
- ROUTING_NO — VARCHAR(10) — Foreign key → ZTG4PP0002.ROUTING_NO
- KWMENG — DECIMAL(13,3)
- LABST — DECIMAL(13,3)
- MEINS — VARCHAR(3)
- LOWST — DECIMAL(13,3)
- YIELD_RATE — DECIMAL(5,2)
- MATNR_IN — VARCHAR(18)
- MENGE — DECIMAL(13,3)
- MEINS2 — VARCHAR(3)