P_SI_AddNonResidentDocument

DDL: P_SI_ADDNONRESIDENTDOCUMENT Type: view_entity COMPOSITE

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 2 data sources (I_OperationalAcctgDocItem, P_SI_GLLineItmBPAssignment) and exposes 7 fields with key fields CompanyCode, FiscalYear, AccountingDocument.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem GLRawData inner
P_SI_GLLineItmBPAssignment remove from

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 I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
Customer
Supplier
DocumentIsAdded
SI_IntlInstitutionCode 
@EndUserText.label: 'Merged additional documents added by RAP - SI BST'
@VDM.viewType: #COMPOSITE
//@Metadata.allowExtensions:true

//@Analytics: { dataCategory: #CUBE }

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
//@Analytics.internalName:#LOCAL

@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true

define view entity P_SI_AddNonResidentDocument as select from  P_SI_GLLineItmBPAssignment as remove
inner join I_OperationalAcctgDocItem as GLRawData               on  GLRawData.CompanyCode    = remove.CompanyCode
                                                                and GLRawData.AccountingDocument     = remove.AccountingDocument
                                                                and GLRawData.FiscalYear             = remove.FiscalYear
{
key GLRawData.CompanyCode,
key GLRawData.FiscalYear,
key GLRawData.AccountingDocument,
max ( remove.Customer ) as Customer,
max ( remove.Supplier ) as Supplier,
//min will ensure that once BP belonging to the manually added document 'X' it will not consider this as a manually added document but as a document coming from customizaiton

min ( remove.DocumentIsAdded ) as DocumentIsAdded,
max ( remove.SI_IntlInstitutionCode ) as SI_IntlInstitutionCode
}
group by GLRawData.CompanyCode, GLRawData.FiscalYear, GLRawData.AccountingDocument

Learn More