FACVD_GLMC_OIT

GL Open Items select to clearing | view: FACV_GLMC_OIT | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BKPF, BSEG, BSEG_ADD, REGUH, REGUT, ACDOCA, BKPF, SKA1, SKB1, T001, SKB1, T001, FINSC_LEDGER, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, T012K, FAGL_TLDGRP_MAP, FAGL_TLDGRP_MAP
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Reference Document Line Item
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransCrcy Amount in document currency
AmountInTransCrcyWithNoSign Amount in document currency
💲 Local Currency (CompanyCodeCurrency):
AmountInCoCodeCrcy Amount in local currency
AmountInCoCodeCrcyWithNoSign Amount in local currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
AmountInFunctCrcyWithNoSign Amount in Functional Currency
Column Name Description
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
ValueDate Value date
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
FinancialAccountType Account type Show values
AccountingDocumentCategory Document Status Show values
IsOpenItemManaged Indicator: Open Item Management? Show values
ClearingIsLedgerGroupSpecific Open Item Management by Ledger Group Show values
Column Name Description Domain name
buzei Number of Line Item Within Accounting Document BUZEI
tmpid Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
AssignmentReference Assignment number ZUONR
DocumentItemText Item Text TEXT50
FollowOnDocumentType Follow-On Document Type REBZT
FunctionalArea Functional Area FKBER_SHORT
InvoiceItemReference Line Item in the Relevant Invoice BUZEI
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceReferenceFiscalYear Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
ProfitCenter Profit Center PRCTR
Segment Segment for Segmental Reporting FB_SEGMENT
FiscalPeriod Fiscal period MONAT
CompanyCodeName Name of Company Code or Company TEXT25
Reference1IDByBusinessPartner Business Partner Reference Key CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key CHAR12
Reference3IDByBusinessPartner Reference key for line item CHAR20
DocumentReference Reference Document Number XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
GLAccountAuthorizationGroup Authorization Group BRGRU
Cheque Cheque Number CHCKN
PaymentReference null
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
RepresentativeLedger Ledger in General Ledger Accounting FINS_LEDGER
HouseBankAcctAuthznGroup Bank Account Authorization Group BANK_ACCOUNT_AUTH_GROUP
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • FACVD_GLMC_OIT.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • FACVD_GLMC_OIT.MANDT == T003.MANDT
Update Currency for General Ledger Transaction Figures
  • Update Currency for General Ledger Transaction Figures
  • Client
  • FACVD_GLMC_OIT.BALANCETRANSCRCY == TCURC.WAERS
  • FACVD_GLMC_OIT.MANDT == TCURC.MANDT
Business Area
  • Business Area
  • Client
  • FACVD_GLMC_OIT.BUSINESSAREA == TGSB.GSBER
  • FACVD_GLMC_OIT.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • FACVD_GLMC_OIT.COMPANYCODE == T001.BUKRS
  • FACVD_GLMC_OIT.MANDT == T001.MANDT
Equity group
  • Company Code
  • Equity group
  • Client
  • Joint venture
  • FACVD_GLMC_OIT.COMPANYCODE == T8JF.BUKRS
  • FACVD_GLMC_OIT.EQUITYGROUP == T8JF.EGRUP
  • FACVD_GLMC_OIT.MANDT == T8JF.MANDT
  • FACVD_GLMC_OIT.JOINTVENTURE == T8JF.VNAME
Transaction type
  • Transaction type
  • Client
  • FACVD_GLMC_OIT.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • FACVD_GLMC_OIT.MANDT == T856.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • FACVD_GLMC_OIT.COMPANYCODE == SKB1.BUKRS
  • FACVD_GLMC_OIT.GENERALLEDGERACCOUNT == SKB1.SAKNR
  • FACVD_GLMC_OIT.MANDT == SKB1.MANDT
Short Key for a House Bank
  • ?
  • Client
  • Short Key for a House Bank
  • FACVD_GLMC_OIT.[column in domain "BUKRS"] == T012.BUKRS
  • FACVD_GLMC_OIT.MANDT == T012.MANDT
  • FACVD_GLMC_OIT.HOUSEBANK == T012.HBKID
ID for Account Details
  • ?
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • FACVD_GLMC_OIT.[column in domain "BUKRS"] == T012K.BUKRS
  • FACVD_GLMC_OIT.HOUSEBANNKACCOUNT == T012K.HKTID
  • FACVD_GLMC_OIT.MANDT == T012K.MANDT
  • FACVD_GLMC_OIT.HOUSEBANK == T012K.HBKID
Joint venture
  • Company Code
  • Client
  • Joint venture
  • FACVD_GLMC_OIT.COMPANYCODE == T8JV.BUKRS
  • FACVD_GLMC_OIT.MANDT == T8JV.MANDT
  • FACVD_GLMC_OIT.JOINTVENTURE == T8JV.VNAME
Ledger Group
  • Ledger Group
  • Client
Order Number
  • Order Number
  • Client
  • FACVD_GLMC_OIT.ORDERS == AUFK.AUFNR
  • FACVD_GLMC_OIT.MANDT == AUFK.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FACVD_GLMC_OIT.MANDT == T880.MANDT
  • FACVD_GLMC_OIT.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • ?
  • ?
  • Client
  • Partner Profit Center
  • FACVD_GLMC_OIT.[column in domain "DATBI"] == CEPC.DATBI
  • FACVD_GLMC_OIT.[column in domain "KOKRS"] == CEPC.KOKRS
  • FACVD_GLMC_OIT.MANDT == CEPC.MANDT
  • FACVD_GLMC_OIT.PARTNERPROFITCENTER == CEPC.PRCTR
Plant
  • Client
  • Plant
  • FACVD_GLMC_OIT.MANDT == T001W.MANDT
  • FACVD_GLMC_OIT.PLANT == T001W.WERKS
Recovery Indicator
  • Company Code
  • Client
  • Recovery Indicator
  • FACVD_GLMC_OIT.COMPANYCODE == T8JJ.BUKRS
  • FACVD_GLMC_OIT.MANDT == T8JJ.MANDT
  • FACVD_GLMC_OIT.RECOVERYINDICATOR == T8JJ.RECID
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • FACVD_GLMC_OIT.[column in domain "KALSM_D"] == T007A.KALSM
  • FACVD_GLMC_OIT.MANDT == T007A.MANDT
  • FACVD_GLMC_OIT.TAXCODE == T007A.MWSKZ
Currency Key
  • Currency Key
  • Client
  • FACVD_GLMC_OIT.TRANSACTIONCURRENCY == TCURC.WAERS
  • FACVD_GLMC_OIT.MANDT == TCURC.MANDT