P_FicaToBOPFormItm13

DDL: P_FICATOBOPFORMITM13 SQL: PBOPFICA13 Type: view COMPOSITE
19 Fields 1 Data Sources

P_FicaToBOPFormItm13 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_FicaToBOPFormItm12) and exposes 19 fields with key fields CompanyCode, CADocumentNumber, FiscalYear, BOPRptgCntry, BOPForm.

Data Sources (1)

SourceAliasJoin Type
P_FicaToBOPFormItm12 m12 from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PBOPFICA13 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 (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_FicaToBOPFormItm12 CompanyCode Receiver Company Code
KEY CADocumentNumber P_FicaToBOPFormItm12 CADocumentNumber Document Number
KEY FiscalYear P_FicaToBOPFormItm12 FiscalYear G/L Fiscal Year
KEY BOPRptgCntry P_FicaToBOPFormItm12 BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm P_FicaToBOPFormItm12 BOPForm Form
KEY CASubItemNumber P_FicaToBOPFormItm12 CASubItemNumber Subitem
KEY CABPItemNumber P_FicaToBOPFormItm12 CABPItemNumber Item
KEY CAGLItemNumber P_FicaToBOPFormItm12 CAGLItemNumber Item
CAPostingDate P_FicaToBOPFormItm12 CAPostingDate Posting Date
CAReversedDocumentNumber P_FicaToBOPFormItm12 CAReversedDocumentNumber Rev. Doc. For
CAReconciliationKey P_FicaToBOPFormItm12 CAReconciliationKey Reconcil. Key
CompanyCodeCountry P_FicaToBOPFormItm12 CompanyCodeCountry Reporting Ctry/Reg.
BOPPartnerCntry P_FicaToBOPFormItm12 BOPPartnerCntry Country/Reg.
ChartOfAccounts P_FicaToBOPFormItm12 ChartOfAccounts Node Class
GLAccount P_FicaToBOPFormItm12 GLAccount General Ledger
TaxCode P_FicaToBOPFormItm12 TaxCode Tax Code
UniqueAcctgDocClrgDate P_FicaToBOPFormItm12 UniqueAcctgDocClrgDate
HasUniqueClrgDate P_FicaToBOPFormItm12 HasUniqueClrgDate
FinancialAccountType P_FicaToBOPFormItm12 FinancialAccountType Fin. Account Type

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_FicaToBOPFormItm13.
-- 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: PBOPFICA13

CREATE VIEW P_FicaToBOPFormItm13 AS
SELECT
  m12.CompanyCode AS CompanyCode,
  m12.CADocumentNumber AS CADocumentNumber,
  m12.FiscalYear AS FiscalYear,
  m12.BOPRptgCntry AS BOPRptgCntry,
  m12.BOPForm AS BOPForm,
  m12.CASubItemNumber AS CASubItemNumber,
  m12.CABPItemNumber AS CABPItemNumber,
  m12.CAGLItemNumber AS CAGLItemNumber,
  m12.CAPostingDate AS CAPostingDate,
  m12.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  m12.CAReconciliationKey AS CAReconciliationKey,
  m12.CompanyCodeCountry AS CompanyCodeCountry,
  m12.BOPPartnerCntry AS BOPPartnerCntry,
  m12.ChartOfAccounts AS ChartOfAccounts,
  m12.GLAccount AS GLAccount,
  m12.TaxCode AS TaxCode,
  m12.UniqueAcctgDocClrgDate AS UniqueAcctgDocClrgDate,
  m12.HasUniqueClrgDate AS HasUniqueClrgDate,
  m12.FinancialAccountType AS FinancialAccountType
FROM P_FicaToBOPFormItm12 AS m12
;

Learn More