FDC_D_GLITM_DRFT

Hold Data Persistence for GLITEMS | #masterdata | Component: Posting/Clearing
Column Name Description
MANDT Client
BUKRS_AV Company Code
KOART_AV Payment Advice Account Type Show values
KONTO_AV Account Number
AVSID_AV Payment Advice Number
AVSPO_AV Payment Advice Item
Column Name Description
WSKTO Cash Discount Amount in Document Currency
SKNTO Cash Discount Amount in Local Currency
SKFBT Amount Eligible for Cash Discount in Document Currency
PYAMT Amount in Payment Currency
QSSHB Withholding Tax Base Amount
QBSHB Withholding Tax Amount (in Document Currency)
QSFBT Withholding Tax-Exempt Amount (in Document Currency)
WMWST Tax Amount in Document Currency
MWSTS Tax Amount in Local Currency
DMBTR Local Currency Amount
WRBTR Document Currency Amount
DMBE2 Amount in Second Local Currency or Global Currency
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency
DMBE4 Amount in Freely Defined Currency 2
DMBE5 Amount in Freely Defined Currency 3
DMBE6 Amount in Freely Defined Currency 4
DMBE7 Amount in Freely Defined Currency 5
DMBE8 Amount in Freely Defined Currency 6
DMBE9 Amount in Freely Defined Currency 7
DMBE10 Amount in Freely Defined Currency 8
TXBFW Original Tax Base Amount in Document Currency
HWBAS Local Currency Base Amount
FWBAS Tax Base Amount in Document Currency
GBETR Hedged Amount in Foreign Currency
NAVFW Non-Deductible Input Tax (in Document Currency)
NAVHW Non-Deductible Input Tax (in Document Currency)
NAVH2 Non-Deductible Input Tax (in Document Currency)
NAVH3 Non-Deductible Input Tax (in Document Currency)
SKNT2 Cash Discount Amount in Second Local Currency
SKNT3 Cash Discount Amount in Third Local Currency
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts)
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts)
💲 Update Currency for General Ledger Transaction Figures (PSWSL):
PSWBT Amount for Updating in General Ledger
💲 Currency Key (WAERS):
NEBTR Payment Amount
💲 Currency Key of Second Local Currency (HWAE2):
MWST2 Tax Amount in Second Local Currency
💲 Currency Key of Third Local Currency (HWAE3):
MWST3 Tax Amount in Third Local Currency
Column Name Description
MENGE Quantity
Column Name Description
ZFBDT Baseline Date for Due Date Calculation
FDTAG Planning Date
MADAT Date of Last Dunning Notice
VRSDT Insurance Date
ZOLLD Customs Date
NETDT Net Due Date
SK1DT Due Date for Cash Discount 1
SK2DT Due Date for Cash Discount 2
TXDAT Date for Determining Tax Rates
TXDAT_FROM Valid-From Date of the Tax Rate
BZDAT Asset Value Date
DABRZ Reference date for settlement
PRODPER Production Month (Date to find period and year)
PEROP_BEG Billing Period of Performance Start Date
PEROP_END Billing Period of Performance End Date
VALUT Value Date
AUGDT Clearing Date
AUGCP Clearing Entry Date
Column Name Description
KOART_AV Payment Advice Account Type Show values
ZBFIX Fixed Payment Terms Show values
XCPDD Indicator: Address and Bank Data Set Individually Show values
VERTT Contract Type Show values
ZINKZ Exempted from Interest Calculation Show values
XINVE Indicator: Capital Goods Affected? Show values
KOART Account Type Show values
SHKZG Debit/Credit Indicator Show values
XNEGP Indicator: Negative Posting Show values
XSKRL Is Not Cash Discount Liable Show values
HWMET Method with Which the Local Currency Amount Was Determined Show values
XEGDR Is EU Triangular Deal Show values
GMVKZ Item is in Execution Show values
SRTYPE Type of Additional Receivable Show values
ERLKZ Completion Indicator for Line Item Show values
MWART_FILTER Tax Type Show values
XPYPR Indicator: Items from Payment Program Blocked Show values
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? Show values
XUMSW Indicator: Sales-Related Item ? Show values
XOPVW Indicator: Open Item Management? Show values
XLGCLR Open Item Management by Ledger Group Show values
XANET Indicator: Down Payment in Net Procedure? Show values
MWART Tax Type Show values
GLACCT_MODE Mode for input into field GLACCT Show values
XBILK Indicator: Account is a balance sheet account? Show values
Column Name Description Domain name
LIFNR Account Number of Supplier LIFNR
KUNNR Customer Number KUNNR
FILKD Account Number of the Branch MAXKK
UMSKZ Special G/L Indicator UMSKZ
UMSKS Special G/L Transaction Type UMSKS
ZUMSK Target Special G/L Indicator UMSKZ
HZUON Assignment Number for Special G/L Accounts ZUONR
ZTERM Terms of Payment Key ZTERM
ZBD1P Cash Discount Percentage 1 PRZ23
ZBD1T Cash discount days 1 ZBDXT
ZBD2P Cash Discount Percentage 2 PRZ23
ZBD2T Cash discount days 2 ZBDXT
ZBD3T Net Payment Terms Period ZBDXT
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZZ Line Item in the Relevant Invoice BUZEI
REBZT Follow-On Document Type REBZT
FDLEV Planning Level FDLEV
EMPFB Account number of the alternative payer or payee MAXKK
BVTYP Partner Bank Type BVTYP
SAKNR G/L Account Number SAKNR
DIEKZ Service Indicator (Foreign Payment) DIEKZ
SAMNR Collective Invoice List Number SAMNR
VERTN Contract Number RANL
VBEWA Flow Type SBEWART
DTWS1 Instruction Key 1 DTWSX
DTWS2 Instruction Key 2 DTWSX
DTWS3 Instruction key 3 DTWSX
DTWS4 Instruction key 4 DTWSX
MNDID Unique Reference to Mandate for each Payee ID035
SECCO Section Code SECCO
MANST Dunning Level MAHNS
ESRNR ISR subscriber number ESRNR
ESRRE ISR/QR Reference Number ESRRE
ESRPZ POR check digit CHAR2
QSZNR Certificate Number of the Withholding Tax Exemption CHAR10
VRSKZ Insurance Indicator CHAR1
ANFBN Document Number of the Bill of Exchange Payment Request BELNR
ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted BUKRS
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document GJAHR
ZOLLT Customs Tariff Number ZOLLT
PAYT_RSN Payment Reason FARP_PAYT_RSN
BUKRS Company Code BUKRS
BELNR Journal Entry BELNR
BUZEI Line Item BUZEI
HKONT G/L Account SAKNR
SGTXT Item Text TEXT50
ZUONR Assignment number ZUONR
TAX_COUNTRY Tax Reporting Country/Region LAND1
MWSKZ Tax on sales/purchases code MWSKZ
TAXCODE_TXT Tax rates for a tax code TEXT50
TXJCD Tax Jurisdiction TXJCD
KURSR Hedged Exchange Rate KURSP
STCEG VAT Registration Number STCEG
EGBLD Country/Region of Destination for Delivery of Goods LAND1
HBKID Short Key for a House Bank HBKID
HKTID House Bank Account HKTID
CCBTC Payment cards: Settlement run CCBTC
KIDNO Payment Reference CHAR30
VBUND Company ID of Trading Partner RCOMP
RSTGR Reason Code for Payments RSTGR
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
XREF3 Reference key for line item CHAR20
PRCTR Profit Center PRCTR
PPRCTR Partner Profit Center PRCTR
SEGMENT Segment for Segmental Reporting FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting FB_SEGMENT
GSBER Business Area GSBER
PARGB Partner Business Area GSBER
KDAUF Sales Order Number VBELN
KDPOS Sales Order Item NUM06
KDEIN Sales Order Schedule NUM04
ZEKKN Sequential Number of Account Assignment NUM02
SERVICE_DOC_TYPE Service Document Type CRM_PROCESS_TYPE
SERVICE_DOC_ID Service Document ID CRM_OBJECT_ID
SERVICE_DOC_ITEM_ID Service Document Item ID FCO_SRVDOC_ITEM_ID
PERNR Personnel Number PERNR
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
ANBWA Transaction Type BWASL
ABPER Settlement Period BUPER
WERKS Plant WERKS
MATNR Material Number MATNR
RMVCT Financial Transaction Type RMVCT
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
NPLNR Network Number for Account Assignment AUFNR
VORNR Operation/Activity Number VORNR
VORNR_AUF Operation Number VORNR
AUFPL Task List Number for Operations in Order AUFPL
APLZL General Counter for Order CO_APLZL
KOSTL Cost Center KOSTL
KSTRG Cost Object KSTRG
LSTAR Activity Type LSTAR
PRZNR Business Process CO_PRZNR
AUFNR Order Number AUFNR
IMKEY Internal Key for Real Estate Object IMKEY
FIPOS Commitment Item FIPOS
FIPEX Commitment Item FM_FIPEX
FISTL Funds Center FISTL
GEBER Fund BP_GEBER
PGEBER Partner Fund BP_GEBER
GRANT_NBR Grant GM_GRANT_NBR
PGRANT_NBR Partner Grant GM_GRANT_NBR
FKBER Functional Area FKBER
PFKBER Partner Functional Area FKBER
KBLNR Document Number for Earmarked Funds KBLNR
KBLPOS Earmarked Funds: Document Item KBLPOS
BUDGET_PD Budget Period FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period FM_BUDGET_PERIOD
MEASURE Funded Program FM_MEASURE
VNAME Joint venture JV_NAME
RECID Recovery Indicator JV_RECIND
EGRUP Equity group JV_EGROUP
VPTNR Partner account number KUNNR
BTYPE Billing Indicator JV_BILIND
ETYPE Equity type JV_ETYPE
GITYP Distribution Type for Employment Tax J_1ADTYP
GRICD Activity Code for Gross Income Tax J_1AGICD2
GRIRG Region (State, Province, County) REGIO
IDXSP Inflation Index J_1AINDXP
KTOSL Transaction Key CHAR3
TXJCD_EXT Tax Jurisdiction TXJCD
J_1TPBUPL Branch Code BCODE
VALOBJTYPE Type of the Financial Valuation Object VAL_OBJ_TYPE
VALOBJ_ID Identifier of the Financial Valuation Object VAL_OBJ_ID
VALSOBJ_ID Identifier of the Financial Valuation Subobject VAL_SUBOBJ_ID
RISK_CLASS Risk Class UKM_RISK_CLASS
RE_BUKRS Cash Origin Company Code BUKRS
RE_ACCOUNT Cash Origin Account SAKNR
BDGT_ACCOUNT Budget Account SAKNR
BDGT_ACCOUNT_COCODE Budget Account Company Code BUKRS
RSPONSORED_PROG Sponsored Program GM_SPONSORED_PROG
RSPONSORED_CLASS Sponsored Class GM_SPONSORED_CLASS
RBDGT_VLDTY_NBR Budget Validity Number GM_BDGT_VLDTY_NBR
SWENR Business Entity Number REBDBENO
SGRNR Number of Land REBDPRNO
SGENR Number of Building REBDBUNO
SMENR Number of Rental Object REBDRONO
SNKSL Service Charge Key RESCSCKEY
SEMPSL Settlement Unit RESCSUID
RECNNR Contract Number RECNNUMBER
SBERI Correction item number SBERI
GLO_REF1 Country/Region Specific Reference 1 on line item FAC_GLO_REF1
WORK_ITEM_ID Work Item ID /CPD/PFP_WORKITEM_ID
UXFC_DUMMY Single-Character Flag CHAR1
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
GJAHR Fiscal Year GJAHR
TAXPS Tax document item number NUM6
KOKRS Controlling Area CACCD
FIKRS Financial Management Area FIKRS
FDGRP Planning Group FDGRP
LOKKT G/L Account SAKNR
HKONT_TXT GL Account Description TEXT20
BUKRS_TXT Name of Company Code or Company TEXT25
LOKKT_TXT GL Account Description TEXT20
FKBER_TXT Name of the functional area TEXT25
KOSTL_TXT General Name TEXT20
KUNNR_TXT Name 1 NAME
MATNR_EXT_TXT Material Description TEXT40
MATNR_TXT Material Description TEXT40
PRCTR_TXT Long Text TEXT40
SEGMENT_TXT Text Field TEXT50
PSEGMENT_TXT Text Field TEXT50
VBUND_TXT Company name TEXT30
HWMET_TXT Explanatory Short Text DDTEXT
LIFNR_TXT Name TEXT30
PLANT_TXT Name TEXT30
WERKS_TXT Name TEXT30
PPRCT_TXT General Name TEXT20
PPRCTR_TXT General Name TEXT20
TXJCD_TXT Text TEXT50
MWSKZ_TXT Text TEXT50
QSSKZ_TXT Text TEXT50
GSBER_TXT Business area description TEXT30
PARGB_TXT Business area description TEXT30
UMSKZ_TXT Long Text for Special G/L Indicators TEXT30
ZTERM_TXT Description of terms of payment TEXT30
ZLSCH_TXT Text TEXT50
ZLSPR_TXT Explanation of the Reason for Payment Block TEXT20
KTOPL Chart of Accounts KTOPL
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
GEBER_TXT Name TEXT20
PGEBER_TXT Name TEXT20
BUDGET_PD_TXT Budget Period Name NAME
PBUDGET_PD_TXT Budget Period Name NAME
FISTL_TXT Name TEXT20
MEASURE_TXT Name TEXT20
GRANT_NBR_TXT Name TEXT20
PGRANT_NBR_TXT Name TEXT20
RSPONSORED_CLASS_TXT Sponsored Class Name TEXT20
RSPONSORED_PROG_TXT Sponsored Program Name TEXT24
RBDGT_VLDTY_NBR_TXT null
FIPEX_TXT Name TEXT20
WT_KEY Grouping Key for Withholding Tax Information NUMC06
SLALITTYPE Subledger-Specific Line Item Type SLALITTYPE
SUBTA Partial Document to Be Balanced to Zero
PAYT_RSN_TXT Payment Reason Description CHAR130
GLO_REF1_LBL Medium Field Label SCRTEXT_M
GLO_RE1_OT_LBL Medium Field Label SCRTEXT_M
BSCHL Posting Key BSCHL
AUGBL Document Number of the Clearing Document BELNR
AUGGJ Fiscal Year of Clearing Document GJAHR
AGZEI Clearing Item AGZEI
ALTKT Group Account Number SAKNR
GVTYP P&L statement account type CHAR2
INTRENO Internal Key of Real Estate Object RECAINTRENO
BUZEI_SENDER Item Number Within Accounting Document in Sender System BUZEI
RACCT_SENDER General Ledger Account in Sender System CHAR10
ACCASTY_SENDER Account Assignment Type in Sender System J_OBART
ACCAS_SENDER Account Assignment in Sender System ACCAS
ACDOC_EEW_DUMMY Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Business Place
  • Company Code
  • Business Place
  • Client
  • ?
  • FDC_D_GLITM_DRFT.BUKRS == J_1BBRANCH.BUKRS
  • FDC_D_GLITM_DRFT.BUPLA == J_1BBRANCH.BRANCH
  • FDC_D_GLITM_DRFT.MANDT == J_1BBRANCH.MANDT
  • FDC_D_GLITM_DRFT.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
Accounts Receivable Pledging Indicator
  • Accounts Receivable Pledging Indicator
  • Client
  • Company Code
  • FDC_D_GLITM_DRFT.CESSION_KZ == TCESSION.CESSION_KZ
  • FDC_D_GLITM_DRFT.MANDT == TCESSION.CLIENT
  • FDC_D_GLITM_DRFT.BUKRS == TCESSION.COMPANY
Credit control area
  • FDC_D_GLITM_DRFT.MANDT == T014.MANDT
  • FDC_D_GLITM_DRFT.KKBER == T014.KKBER
Dunning Area
  • Dunning Area
  • Company Code in Which Bill of Exch.Payment Request Is Posted
  • FDC_D_GLITM_DRFT.MANDT == T047M.MANDT
  • FDC_D_GLITM_DRFT.MABER == T047M.MABER
  • FDC_D_GLITM_DRFT.ANFBU == T047M.BUKRS
Dunning Block
  • FDC_D_GLITM_DRFT.MANDT == T040S.MANDT
  • FDC_D_GLITM_DRFT.MANSP == T040S.MANSP
Dunning Key
  • FDC_D_GLITM_DRFT.MANDT == T040.MANDT
  • FDC_D_GLITM_DRFT.MSCHL == T040.MSCHL
Withholding Tax Code
  • ?
  • Client
  • Withholding Tax Code
  • FDC_D_GLITM_DRFT.[column in domain "LAND1"] == T059Q.LAND1
  • FDC_D_GLITM_DRFT.MANDT == T059Q.MANDT
  • FDC_D_GLITM_DRFT.QSSKZ == T059Q.QSSKZ
Payment Method
  • Payment Method
  • ?
  • FDC_D_GLITM_DRFT.MANDT == T042Z.MANDT
  • FDC_D_GLITM_DRFT.ZLSCH == T042Z.ZLSCH
  • FDC_D_GLITM_DRFT.[column in domain "LAND1"] == T042Z.LAND1
Payment Block on Item
  • Payment Block on Item
  • Client
  • FDC_D_GLITM_DRFT.ZLSPR == T008.ZAHLS
  • FDC_D_GLITM_DRFT.MANDT == T008.MANDT