P_BOPFICA_BP_RESULT

DDL: P_BOPFICA_BP_RESULT Type: view_entity COMPOSITE
32 Fields 2 Data Sources

FI-CA BP Result

P_BOPFICA_BP_RESULT is a Composite CDS View that provides data about "FI-CA BP Result" in SAP S/4HANA. It reads from 2 data sources (P_BOPFICA_BP_ITEM_2, I_BOPContractAccountFormRule) and exposes 32 fields with key fields CompanyCode, CADocumentNumber, FiscalYear, CASubItemNumber, CABPItemNumber.

Data Sources (2)

SourceAliasJoin Type
P_BOPFICA_BP_ITEM_2 bp_item from
I_BOPContractAccountFormRule fir inner

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label FI-CA BP Result view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_BOPFICA_BP_ITEM_2 CompanyCode Receiver Company Code
KEY CADocumentNumber P_BOPFICA_BP_ITEM_2 CADocumentNumber Document Number
KEY FiscalYear P_BOPFICA_BP_ITEM_2 FiscalYear G/L Fiscal Year
KEY CASubItemNumber P_BOPFICA_BP_ITEM_2 CASubItemNumber Subitem
KEY CABPItemNumber P_BOPFICA_BP_ITEM_2 CABPItemNumber Item
KEY BOPRptgCntry P_BOPFICA_BP_ITEM_2 BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm P_BOPFICA_BP_ITEM_2 BOPForm Form
KEY BOPFormItem I_BOPContractAccountFormRule BOPFormItem Form Item
KEY StatryRptCategory log StatryRptCategory Report ID
KEY StatryRptgEntity log StatryRptgEntity Reporting Entity
KEY StatryRptRunID log StatryRptRunID Report Run ID
CAReconciliationKey P_BOPFICA_BP_ITEM_2 CAReconciliationKey Reconcil. Key
AccountingDocument
CompanyCodeCountry P_BOPFICA_BP_ITEM_2 CompanyCodeCountry Reporting Ctry/Reg.
BOPPartnerCntry P_BOPFICA_BP_ITEM_2 BOPPartnerCntry Country/Reg.
FinancialAccountType P_BOPFICA_BP_ITEM_2 FinancialAccountType Fin. Account Type
PostingDate P_BOPFICA_BP_ITEM_2 CAPostingDate Posting Date
ChartOfAccounts P_BOPFICA_BP_ITEM_2 ChartOfAccounts Node Class
GLAccount P_BOPFICA_BP_ITEM_2 GLAccount General Ledger
TaxCode P_BOPFICA_BP_ITEM_2 TaxCode Tax Code
CADocumentType P_BOPFICA_BP_ITEM_2 CADocumentType Document Type
AccountingDocumentType
SpecialGLCode
TransactionCurrency P_BOPFICA_BP_ITEM_2 TransactionCurrency Transaction Currency
AmountInTransactionCurrency P_BOPFICA_BP_ITEM_2 CAAmountInTransactionCurrency Amount
CompanyCodeCurrency P_BOPFICA_BP_ITEM_2 CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_BOPFICA_BP_ITEM_2 CAAmountInLocalCurrency Local Crcy Amt
ClearingDate P_BOPFICA_BP_ITEM_2 CAClearingDate Clearing
CAClearingAccountingDocument P_BOPFICA_BP_ITEM_2 CAClearingDocumentNumber Clearing Doc.
BusinessPartner P_BOPFICA_BP_ITEM_2 BusinessPartner Issuing Authority
OffsettingAccountType P_BOPFICA_BP_ITEM_2 FinancialAccountType Fin. Account Type
PartnerCompany P_BOPFICA_BP_ITEM_2 PartnerCompany Trading Partner

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_BOPFICA_BP_RESULT.
-- 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.

CREATE VIEW P_BOPFICA_BP_RESULT AS
SELECT
  bp_item.CompanyCode AS CompanyCode,
  bp_item.CADocumentNumber AS CADocumentNumber,
  bp_item.FiscalYear AS FiscalYear,
  bp_item.CASubItemNumber AS CASubItemNumber,
  bp_item.CABPItemNumber AS CABPItemNumber,
  bp_item.BOPRptgCntry AS BOPRptgCntry,
  bp_item.BOPForm AS BOPForm,
  fir.BOPFormItem AS BOPFormItem,
  log.StatryRptCategory AS StatryRptCategory,
  log.StatryRptgEntity AS StatryRptgEntity,
  log.StatryRptRunID AS StatryRptRunID,
  bp_item.CAReconciliationKey AS CAReconciliationKey,
  cast('' as belnr_d) AS AccountingDocument,
  bp_item.CompanyCodeCountry AS CompanyCodeCountry,
  bp_item.BOPPartnerCntry AS BOPPartnerCntry,
  bp_item.FinancialAccountType AS FinancialAccountType,
  bp_item.CAPostingDate AS PostingDate,
  bp_item.ChartOfAccounts AS ChartOfAccounts,
  bp_item.GLAccount AS GLAccount,
  bp_item.TaxCode AS TaxCode,
  bp_item.CADocumentType AS CADocumentType,
  cast('' as blart) AS AccountingDocumentType,
  cast('' as umskz) AS SpecialGLCode,
  bp_item.TransactionCurrency AS TransactionCurrency,
  bp_item.CAAmountInTransactionCurrency AS AmountInTransactionCurrency,
  bp_item.CompanyCodeCurrency AS CompanyCodeCurrency,
  bp_item.CAAmountInLocalCurrency AS AmountInCompanyCodeCurrency,
  bp_item.CAClearingDate AS ClearingDate,
  bp_item.CAClearingDocumentNumber AS CAClearingAccountingDocument,
  bp_item.BusinessPartner AS BusinessPartner,
  bp_item.FinancialAccountType AS OffsettingAccountType,
  bp_item.PartnerCompany AS PartnerCompany
FROM P_BOPFICA_BP_ITEM_2 AS bp_item
INNER JOIN I_BOPContractAccountFormRule AS fir ON /* join condition not captured in parsed metadata */
;

Learn More