P_FicaDocumentItems

DDL: P_FICADOCUMENTITEMS SQL: PBOPFICAITM Type: view COMPOSITE
47 Fields 1 Data Sources

P_FicaDocumentItems is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItemPhysical) and exposes 47 fields with key fields CompanyCode, CADocumentNumber, CAGLItemNumber, CASubItemNumber, CABPItemNumber.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItemPhysical fica_itm_bp inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PBOPFICAITM view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CADocumentBPItemPhysical CompanyCode Receiver Company Code
KEY CADocumentNumber I_CADocumentBPItemPhysical CADocumentNumber Document Number
KEY CAGLItemNumber Item
KEY CASubItemNumber I_CADocumentBPItemPhysical CASubItemNumber Subitem
KEY CABPItemNumber I_CADocumentBPItemPhysical CABPItemNumber Item
CAPostingDate I_CADocumentBPItemPhysical CAPostingDate Posting Date
ChartOfAccounts I_CADocumentBPItemPhysical ChartOfAccounts Node Class
GLAccount I_CADocumentBPItemPhysical CAReconciliationAccount General Ledger
TaxCode I_CADocumentBPItemPhysical TaxCode Tax Code
CADocumentType _DocType CADocumentType Document Type
CAAmountInTransactionCurrency I_CADocumentBPItemPhysical CAAmountInTransactionCurrency Amount
TransactionCurrency I_CADocumentBPItemPhysical TransactionCurrency Transaction Currency
CompanyCodeCurrency I_CADocumentBPItemPhysical CompanyCodeCurrency Local Currency
CAAmountInLocalCurrency I_CADocumentBPItemPhysical CAAmountInLocalCurrency Local Crcy Amt
CAClearingDate I_CADocumentBPItemPhysical CAClearingDate Clearing
CAClearingDocumentNumber I_CADocumentBPItemPhysical CAClearingDocumentNumber Clearing Doc.
ClearingDocFiscalYear
CAReversedDocumentNumber _DocHeader CAReversedDocumentNumber Rev. Doc. For
CAReversalDocumentNumber _DocHeader CAReversalDocumentNumber Revers.document
BusinessPartner I_CADocumentBPItemPhysical BusinessPartner Issuing Authority
Country
PartnerCompany I_CADocumentBPItemPhysical PartnerCompany Trading Partner
FinancialAccountType
CompanyCode Receiver Company Code
KEY CADocumentNumber fica_itm_gl CADocumentNumber Document Number
KEY CAGLItemNumber fica_itm_gl CAGLItemNumber Item
KEY CASubItemNumber Subitem
KEY CABPItemNumber Item
CAPostingDate I_CADocumentBPItemPhysical CAPostingDate Posting Date
ChartOfAccounts fica_itm_gl ChartOfAccounts Node Class
GLAccount fica_itm_gl GLAccount General Ledger
TaxCode fica_itm_gl TaxCode Tax Code
CADocumentType Document Type
CAAmountInTransactionCurrency fica_itm_gl CAAmountInTransactionCurrency Amount
TransactionCurrency fica_itm_gl TransactionCurrency Transaction Currency
CompanyCodeCurrency I_CADocumentBPItemPhysical CompanyCodeCurrency Local Currency
CAAmountInLocalCurrency fica_itm_gl CAAmountInLocalCurrency Local Crcy Amt
CAClearingDate I_CADocumentBPItemPhysical CAClearingDate Clearing
CAClearingDocumentNumber I_CADocumentBPItemPhysical CAClearingDocumentNumber Clearing Doc.
ClearingDocFiscalYear
CAReversedDocumentNumber Rev. Doc. For
CAReversalDocumentNumber Revers.document
BusinessPartner I_CADocumentBPItemPhysical BusinessPartner Issuing Authority
Country
PartnerCompany fica_itm_gl PartnerCompany Trading Partner
FinancialAccountType
LedgerGroup fica_itm_gl LedgerGroup Ledger Group

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_FicaDocumentItems.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PBOPFICAITM

CREATE VIEW P_FicaDocumentItems AS
SELECT
  fica_itm_bp.CompanyCode AS CompanyCode,
  fica_itm_bp.CADocumentNumber AS CADocumentNumber,
  cast( '0000' as opupk_kk) AS CAGLItemNumber,
  fica_itm_bp.CASubItemNumber AS CASubItemNumber,
  fica_itm_bp.CABPItemNumber AS CABPItemNumber,
  fica_itm_bp.CAPostingDate AS CAPostingDate,
  fica_itm_bp.ChartOfAccounts AS ChartOfAccounts,
  fica_itm_bp.CAReconciliationAccount AS GLAccount,
  fica_itm_bp.TaxCode AS TaxCode,
  _DocType.CADocumentType AS CADocumentType,
  fica_itm_bp.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  fica_itm_bp.TransactionCurrency AS TransactionCurrency,
  fica_itm_bp.CompanyCodeCurrency AS CompanyCodeCurrency,
  fica_itm_bp.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  fica_itm_bp.CAClearingDate AS CAClearingDate,
  fica_itm_bp.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  cast( '0000' as fis_auggj preserving type) AS ClearingDocFiscalYear,
  _DocHeader.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  _DocHeader.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  fica_itm_bp.BusinessPartner AS BusinessPartner,
  _BusinessPartner._CurrentDefaultAddress._Address.Country AS Country,
  fica_itm_bp.PartnerCompany AS PartnerCompany,
  cast('D' as farp_koart ) AS FinancialAccountType,
  fica_itm_gl.LedgerGroup AS LedgerGroup
INNER JOIN I_CADocumentBPItemPhysical AS fica_itm_bp ON /* join condition not captured in parsed metadata */
;

Learn More