P_FicaToBOPFormItm14

DDL: P_FICATOBOPFORMITM14 SQL: PBOPFICA14 Type: view COMPOSITE Package: GLO_FIN_IS_BOP_GEN
18 Fields 1 Data Sources

FICA Item to BOP Form Item

P_FicaToBOPFormItm14 is a Composite CDS View that provides data about "FICA Item to BOP Form Item" in SAP S/4HANA. It reads from 1 data source (P_FicaToBOPFormItm13) and exposes 18 fields with key fields CompanyCode, CADocumentNumber, FiscalYear, BOPRptgCntry, BOPForm. Part of development package GLO_FIN_IS_BOP_GEN.

Data Sources (1)

SourceAliasJoin Type
P_FicaToBOPFormItm13 m13 from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PBOPFICA14 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 (18)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY CADocumentNumber CADocumentNumber Document Number
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY BOPRptgCntry P_FicaToBOPFormItm13 BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm P_FicaToBOPFormItm13 BOPForm Form
KEY BOPFormItem fir BOPFormItem Form Item
KEY CASubItemNumber P_FicaToBOPFormItm13 CASubItemNumber Subitem
KEY CABPItemNumber P_FicaToBOPFormItm13 CABPItemNumber Item
KEY CAGLItemNumber P_FicaToBOPFormItm13 CAGLItemNumber Item
CAPostingDate P_FicaToBOPFormItm13 CAPostingDate Posting Date
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
AccountingDocument AccountingDocument Journal Entry
CAReconciliationKey CAReconciliationKey Reconcil. Key
UniqueAcctgDocClrgDate P_FicaToBOPFormItm13 UniqueAcctgDocClrgDate
HasUniqueClrgDate P_FicaToBOPFormItm13 HasUniqueClrgDate
FinancialAccountType P_FicaToBOPFormItm13 FinancialAccountType Fin. Account Type
CompanyCodeCountry
BOPPartnerCntry

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_FicaToBOPFormItm14.
-- 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: PBOPFICA14

CREATE VIEW P_FicaToBOPFormItm14 AS
SELECT
  CompanyCode,
  CADocumentNumber,
  FiscalYear,
  m13.BOPRptgCntry AS BOPRptgCntry,
  m13.BOPForm AS BOPForm,
  fir.BOPFormItem AS BOPFormItem,
  m13.CASubItemNumber AS CASubItemNumber,
  m13.CABPItemNumber AS CABPItemNumber,
  m13.CAGLItemNumber AS CAGLItemNumber,
  m13.CAPostingDate AS CAPostingDate,
  CAReversedDocumentNumber,
  AccountingDocument,
  CAReconciliationKey,
  m13.UniqueAcctgDocClrgDate AS UniqueAcctgDocClrgDate,
  m13.HasUniqueClrgDate AS HasUniqueClrgDate,
  m13.FinancialAccountType AS FinancialAccountType,
  min (CompanyCodeCountry) AS CompanyCodeCountry,
  min (BOPPartnerCntry) AS BOPPartnerCntry
FROM P_FicaToBOPFormItm13 AS m13
;

Learn More