FCLM_FI_STAGING_AREA

FI Staging Area | view: VFCLMFISTG | Extraction: Not supported | Component: SAP Cash Management
Tables used: FCLM_FI_STAGING, BKPF, BSEG, T001, T014
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Currency Key (Currency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
AccountingDocumentCreationDate Accounting Document Entry Date
TaxReportingDate Tax Reporting Date
ParkingDate Day of Parking of Accounting Document
ParkingTime Time of Parking
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation Date
ValueDate Value date
SettlementReferenceDate Reference Date for Settlement
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
Column Name Description
staging One Exposure: Staging Show values
xflag Flow Builder 2.0: Error Flag Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
FixedCashDiscount Fixed Cash Discount Show values
MaterialPriceControl Price control indicator Show values
TreasuryContractType Treasury Contract Type Show values
CustomerIsInExecution Customer Is In Execution Show values
Column Name Description Domain name
retry_times Flow Builder 2.0: Retry Times INT1
xreason Flow Builder 2.0: Error Reason CHAR200
created_at UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
FiscalPeriod Fiscal Period POPER
TransactionCode Transaction Code TCODE
AccountingDocumentHeaderText Document Header Text TEXT25
ExchangeRate Exchange Rate UKURS
AccountingDocCreatedByUser User that created the journal entry
AccountingDocumentItemType Identification of the Line Item CHAR1
ClearingAccountingDocument Clearing Journal Entry BELNR
SpecialGLTransactionType Special G/L Transaction Type UMSKS
TaxCountry Tax Reporting Country/Region LAND1
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
CostCenter Cost Center KOSTL
BillingDocument Billing Document VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
VATRegistration VAT Registration STCEG
ProfitCenter Profit Center PRCTR
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
RealEstateObject Internal Key for Real Estate Object IMKEY
CommitmentItemShortID Commitment Item ShortID FIS_FIPOS_SHORTID
CostObject Cost Object KSTRG
ProjectNetwork Network Number for Account Assignment AUFNR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
Fund Fund BP_GEBER
BusinessProcess Business Process CO_PRZNR
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
FundedProgram Funded Program FM_MEASURE
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
Segment Segment for Segmental Reporting FB_SEGMENT
CostElement Cost Element KSTAR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • FCLM_FI_STAGING_AREA.MANDT == T003.MANDT
  • FCLM_FI_STAGING_AREA.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Client
  • Business Area
  • FCLM_FI_STAGING_AREA.MANDT == TGSB.MANDT
  • FCLM_FI_STAGING_AREA.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • FCLM_FI_STAGING_AREA.CHARTOFACCOUNTS == T004.KTOPL
  • FCLM_FI_STAGING_AREA.MANDT == T004.MANDT
Controlling Area
  • Client
  • Controlling Area
  • FCLM_FI_STAGING_AREA.MANDT == TKA01.MANDT
  • FCLM_FI_STAGING_AREA.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • FCLM_FI_STAGING_AREA.MANDT == TCURC.MANDT
  • FCLM_FI_STAGING_AREA.CURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • FCLM_FI_STAGING_AREA.CUSTOMER == KNA1.KUNNR
  • FCLM_FI_STAGING_AREA.MANDT == KNA1.MANDT
Country/Region of Destination for Delivery of Goods
  • Client
  • Country/Region of Destination for Delivery of Goods
  • FCLM_FI_STAGING_AREA.MANDT == T005.MANDT
  • FCLM_FI_STAGING_AREA.DELIVOFGOODSDESTCOUNTRY == T005.LAND1
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • FCLM_FI_STAGING_AREA.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • FCLM_FI_STAGING_AREA.MANDT == T856.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • FCLM_FI_STAGING_AREA.COMPANYCODE == SKB1.BUKRS
  • FCLM_FI_STAGING_AREA.GLACCOUNT == SKB1.SAKNR
  • FCLM_FI_STAGING_AREA.MANDT == SKB1.MANDT
House Bank Key
  • House Bank Key
  • Client
  • ?
  • FCLM_FI_STAGING_AREA.HOUSEBANK == T012.HBKID
  • FCLM_FI_STAGING_AREA.MANDT == T012.MANDT
  • FCLM_FI_STAGING_AREA.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • Client
  • House Bank Account
  • ?
  • FCLM_FI_STAGING_AREA.HOUSEBANK == T012K.HBKID
  • FCLM_FI_STAGING_AREA.MANDT == T012K.MANDT
  • FCLM_FI_STAGING_AREA.HOUSEBANKACCOUNT == T012K.HKTID
  • FCLM_FI_STAGING_AREA.[column in domain "BUKRS"] == T012K.BUKRS
Valuation Type
  • Client
  • Valuation Type
  • FCLM_FI_STAGING_AREA.MANDT == T149D.MANDT
  • FCLM_FI_STAGING_AREA.INVENTORYVALUATIONTYPE == T149D.BWTAR
Order ID
  • Order ID
  • Client
  • FCLM_FI_STAGING_AREA.ORDERID == AUFK.AUFNR
  • FCLM_FI_STAGING_AREA.MANDT == AUFK.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FCLM_FI_STAGING_AREA.MANDT == T880.MANDT
  • FCLM_FI_STAGING_AREA.PARTNERCOMPANY == T880.RCOMP
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • FCLM_FI_STAGING_AREA.MANDT == T008.MANDT
  • FCLM_FI_STAGING_AREA.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Difference Reason
  • Company Code
  • Client
  • Payment Difference Reason
  • FCLM_FI_STAGING_AREA.COMPANYCODE == T053R.BUKRS
  • FCLM_FI_STAGING_AREA.MANDT == T053R.MANDT
  • FCLM_FI_STAGING_AREA.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Payment Method
  • Payment Method
  • Client
  • ?
  • FCLM_FI_STAGING_AREA.PAYMENTMETHOD == T042Z.ZLSCH
  • FCLM_FI_STAGING_AREA.MANDT == T042Z.MANDT
  • FCLM_FI_STAGING_AREA.[column in domain "LAND1"] == T042Z.LAND1
Planning Level
  • Planning Level
  • Client
  • FCLM_FI_STAGING_AREA.PLANNINGLEVEL == T036.EBENE
  • FCLM_FI_STAGING_AREA.MANDT == T036.MANDT
Plant
  • Client
  • Plant
  • FCLM_FI_STAGING_AREA.MANDT == T001W.MANDT
  • FCLM_FI_STAGING_AREA.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • FCLM_FI_STAGING_AREA.POSTINGKEY == TBSL.BSCHL
  • FCLM_FI_STAGING_AREA.MANDT == TBSL.MANDT
Product Number
  • Client
  • Product Number
  • FCLM_FI_STAGING_AREA.MANDT == MARA.MANDT
  • FCLM_FI_STAGING_AREA.PRODUCT == MARA.MATNR
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • ?
  • FCLM_FI_STAGING_AREA.REGION == T005S.BLAND
  • FCLM_FI_STAGING_AREA.MANDT == T005S.MANDT
  • FCLM_FI_STAGING_AREA.[column in domain "LAND1"] == T005S.LAND1
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • FCLM_FI_STAGING_AREA.MANDT == T041C.MANDT
  • FCLM_FI_STAGING_AREA.REVERSALREASON == T041C.STGRD
Special G/L Indicator
  • Special G/L Indicator
  • Client
  • ?
  • FCLM_FI_STAGING_AREA.SPECIALGLCODE == T074U.UMSKZ
  • FCLM_FI_STAGING_AREA.MANDT == T074U.MANDT
  • FCLM_FI_STAGING_AREA.[column in domain "KOART"] == T074U.KOART
Supplier
  • Supplier
  • Client
  • FCLM_FI_STAGING_AREA.SUPPLIER == LFA1.LIFNR
  • FCLM_FI_STAGING_AREA.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • FCLM_FI_STAGING_AREA.[column in domain "KALSM_D"] == T007A.KALSM
  • FCLM_FI_STAGING_AREA.MANDT == T007A.MANDT
  • FCLM_FI_STAGING_AREA.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • FCLM_FI_STAGING_AREA.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FCLM_FI_STAGING_AREA.TAXJURISDICTION == TTXJ.TXJCD
  • FCLM_FI_STAGING_AREA.MANDT == TTXJ.MANDT
Valuation area
  • Valuation area
  • Client
  • FCLM_FI_STAGING_AREA.VALUATIONAREA == T001K.BWKEY
  • FCLM_FI_STAGING_AREA.MANDT == T001K.MANDT
Withholding Tax Code
  • Withholding Tax Code
  • Client
  • ?
  • FCLM_FI_STAGING_AREA.WITHHOLDINGTAXCODE == T059Q.QSSKZ
  • FCLM_FI_STAGING_AREA.MANDT == T059Q.MANDT
  • FCLM_FI_STAGING_AREA.[column in domain "LAND1"] == T059Q.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger
  • Company Code
  • Client
  • Ledger