P_IntcoPostgRstrcn_0

DDL: P_INTCOPOSTGRSTRCN_0 SQL: PICORSTRCN0 Type: view COMPOSITE

P_IntcoPostgRstrcn_0 is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_CompanyCode, I_CompanyCode, P_IntcoPostgRstrcnRawData, P_IntcoPostgRstrcnRawData, P_IntcoPostgRstrcnRawData) and exposes 4 fields with key fields SenderCompanyCode, CompanyCodeasSenderCompanyCode, CompanyCodekeySenderCompanyCode, ReceiverCompanyCode.

5 data source(s) 4 fields

Data Sources (5)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner
I_CompanyCode _CompanyCode inner
P_IntcoPostgRstrcnRawData P_IntcoPostgRstrcnRawData from
P_IntcoPostgRstrcnRawData P_IntcoPostgRstrcnRawData union
P_IntcoPostgRstrcnRawData P_IntcoPostgRstrcnRawData union

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PICORSTRCN0 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SenderCompanyCode SenderCompanyCode
KEY CompanyCodeasSenderCompanyCode
KEY CompanyCodekeySenderCompanyCode
KEY ReceiverCompanyCode I_CompanyCode CompanyCode 
@AbapCatalog.sqlViewName: 'PICORSTRCN0'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {
        sizeCategory: #S,
        serviceQuality: #C,
        dataClass: #CUSTOMIZING
    }
define view P_IntcoPostgRstrcn_0
  as select from P_IntcoPostgRstrcnRawData
{

  key SenderCompanyCode,
  key ReceiverCompanyCode
}
where
      SenderCompanyCode   <> ''
  and ReceiverCompanyCode <> ''

union

select from  P_IntcoPostgRstrcnRawData
  inner join I_CompanyCode as _CompanyCode on _CompanyCode.CompanyCode = _CompanyCode.CompanyCode
{

  key _CompanyCode.CompanyCode as SenderCompanyCode,
  key ReceiverCompanyCode
}
where
      SenderCompanyCode   =  ''
  and ReceiverCompanyCode <> ''

union

select from  P_IntcoPostgRstrcnRawData
  inner join I_CompanyCode as _CompanyCode on _CompanyCode.CompanyCode = _CompanyCode.CompanyCode
{

  key SenderCompanyCode,
  key _CompanyCode.CompanyCode as ReceiverCompanyCode
}
where
      SenderCompanyCode   <> ''
  and ReceiverCompanyCode =  ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"P_INTCOPOSTGRSTRCNRAWDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More