P_SI_GLLineItmBPAssignment

DDL: P_SI_GLLINEITMBPASSIGNMENT Type: view_entity COMPOSITE
15 Fields 4 Data Sources

Assigned BP to GL Line Items

P_SI_GLLineItmBPAssignment is a Composite CDS View that provides data about "Assigned BP to GL Line Items" in SAP S/4HANA. It reads from 4 data sources (I_SI_CntrlBkRptgPrtnAssignment, I_GLAccountLineItemRawData, I_GLAccountLineItemRawData, I_SI_TradeIdentifierCodeLog) and exposes 15 fields with key fields CompanyCode, FiscalYear, AccountingDocument, FiscalYear, AccountingDocument.

Data Sources (4)

SourceAliasJoin Type
I_SI_CntrlBkRptgPrtnAssignment BP from
I_GLAccountLineItemRawData GLAcnt inner
I_GLAccountLineItemRawData GLAcnt inner
I_SI_TradeIdentifierCodeLog uni union

Annotations (9)

NameValueLevelField
EndUserText.label Assigned BP to GL Line Items view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
Customer I_SI_CntrlBkRptgPrtnAssignment Customer Sold-to Party
Supplier I_SI_CntrlBkRptgPrtnAssignment Supplier Supplier
DocumentIsAdded
SI_IntlInstitutionCode I_SI_CntrlBkRptgPrtnAssignment SI_IntlInstitutionCode Venue: Ctry/Reg
CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
Customer I_GLAccountLineItemRawData Customer Sold-to Party
Supplier I_GLAccountLineItemRawData Supplier Supplier
XasDocumentIsAdded
SI_IntlInstitutionCode I_SI_TradeIdentifierCodeLog Country Venue: Ctry/Reg
CountryendasCountry

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_SI_GLLineItmBPAssignment.
-- 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_SI_GLLineItmBPAssignment AS
SELECT
  GLAcnt.CompanyCode AS CompanyCode,
  GLAcnt.FiscalYear AS FiscalYear,
  GLAcnt.AccountingDocument AS AccountingDocument,
  BP.Customer AS Customer,
  BP.Supplier AS Supplier,
  cast( '' as glo_fin_si_added_document ) AS DocumentIsAdded,
  BP.SI_IntlInstitutionCode AS SI_IntlInstitutionCode,
  'X'as DocumentIsAdded AS XasDocumentIsAdded,
  case when GLAcnt.Supplier is not initial then GLAcnt._Supplier.Country else GLAcnt._Customer.Country end as Country AS CountryendasCountry
FROM I_SI_CntrlBkRptgPrtnAssignment AS BP
INNER JOIN I_GLAccountLineItemRawData AS GLAcnt ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_SI_TradeIdentifierCodeLog
;

Learn More