P_FicaDocumentItems

Fica Document Items | view: PBOPFICAITM | Extraction: Not supported | Component: Statutory Reporting
Column Name Description
CompanyCode Company Code
CADocumentNumber Number of a FI-CA Document
CAGLItemNumber Item Number in FI-CA Document
CASubItemNumber Subitem for a Partial Clearing in Document
CABPItemNumber Item Number in FI-CA Document
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
💲 Company Code Currency (CompanyCodeCurrency):
CAAmountInLocalCurrency Amount In Local Currency With +/- Signs
Column Name Description
Column Name Description
CAPostingDate Posting Date in the Document
CAClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
GLAccount General ledger account SAKNR
TaxCode Tax on Sales/Purchases Code MWSKZ
CADocumentType Document Type BLART_KK
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CAReversedDocumentNumber Number of Reversed Document OPBEL_KK
CAReversalDocumentNumber Reversal Document OPBEL_KK
BusinessPartner Business Partner Number BU_PARTNER
PartnerCompany Company ID of Trading Partner RCOMP
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_FICADOCUMENTITEMS.MANDT == T004.MANDT
  • P_FICADOCUMENTITEMS.CHARTOFACCOUNTS == T004.KTOPL
Company Code Currency
  • Client
  • Company Code Currency
  • Transaction Currency
  • P_FICADOCUMENTITEMS.MANDT == TCURC.MANDT
  • P_FICADOCUMENTITEMS.COMPANYCODECURRENCY == TCURC.WAERS
  • P_FICADOCUMENTITEMS.TRANSACTIONCURRENCY == TCURC.WAERS
Country key
  • Country/Region Key
  • Client
  • P_FICADOCUMENTITEMS.COUNTRY == T005.LAND1
  • P_FICADOCUMENTITEMS.MANDT == T005.MANDT