P_SI_AddNonResidentDocument

DDL: P_SI_ADDNONRESIDENTDOCUMENT Type: view_entity COMPOSITE Package: GLO_FIN_IS_SI_CBR_BST
7 Fields 1 Data Sources 1 Associations

Merged additional documents added by RAP - SI BST

P_SI_AddNonResidentDocument is a Composite CDS View that provides data about "Merged additional documents added by RAP - SI BST" in SAP S/4HANA. It reads from 1 data source (P_SI_GLLineItmBPAssignment) and exposes 7 fields with key fields CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views. Part of development package GLO_FIN_IS_SI_CBR_BST.

Data Sources (1)

SourceAliasJoin Type
P_SI_GLLineItmBPAssignment GLRawData from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Country intcn GLRawData.Country = intcn.Country and GLRawData.SI_IntlInstitutionCode is initial

Annotations (9)

NameValueLevelField
EndUserText.label Merged additional documents added by RAP - SI BST 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 (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SI_GLLineItmBPAssignment CompanyCode Receiver Company Code
KEY FiscalYear P_SI_GLLineItmBPAssignment FiscalYear G/L Fiscal Year
KEY AccountingDocument P_SI_GLLineItmBPAssignment AccountingDocument Journal Entry
Customer
Supplier
Country
DocumentIsAdded

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_AddNonResidentDocument.
-- 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_AddNonResidentDocument AS
SELECT
  GLRawData.CompanyCode AS CompanyCode,
  GLRawData.FiscalYear AS FiscalYear,
  GLRawData.AccountingDocument AS AccountingDocument,
  max( GLRawData.Customer ) AS Customer,
  max( GLRawData.Supplier ) AS Supplier,
  max( coalesce( intcn.CountryThreeDigitISOCode, GLRawData.SI_IntlInstitutionCode ) ) AS Country,
  min ( GLRawData.DocumentIsAdded ) AS DocumentIsAdded
FROM P_SI_GLLineItmBPAssignment AS GLRawData
LEFT OUTER JOIN I_Country AS intcn ON GLRawData.Country = intcn.Country AND GLRawData.SI_IntlInstitutionCode is initial  -- association [1..1]
;

Learn More