P_RU_ExtNumByDefault2

DDL: P_RU_EXTNUMBYDEFAULT2 SQL: PRUEXTNUMBYDEF2 Type: view COMPOSITE

P_RU_ExtNumByDefault2 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AccountingDocumentType, I_CompanyCode, P_RU_ExtNumByDefault1) and exposes 6 fields.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_AccountingDocumentType AccDocType inner
I_CompanyCode CompCode inner
P_RU_ExtNumByDefault1 ExtNumByDefault from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PRUEXTNUMBYDEF2 view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
CustCompanyCode P_RU_ExtNumByDefault1 CompanyCode
CustAccountingDocumentType P_RU_ExtNumByDefault1 AccountingDocumentType
CompanyCode I_CompanyCode CompanyCode
AccountingDocumentType I_AccountingDocumentType AccountingDocumentType
ExtDocNmbrAndDteAreFilled P_RU_ExtNumByDefault1 ExtDocNmbrAndDteAreFilled
Rank P_RU_ExtNumByDefault1 Rank 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PRUEXTNUMBYDEF2'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_ExtNumByDefault2
  as select from P_RU_ExtNumByDefault1    as ExtNumByDefault

    inner join   I_AccountingDocumentType as AccDocType on  AccDocType.AccountingDocumentType      =  ExtNumByDefault.AccountingDocumentType
                                                        and ExtNumByDefault.AccountingDocumentType <> ''
                                                        or  ExtNumByDefault.AccountingDocumentType =  ''

    inner join   I_CompanyCode            as CompCode   on  CompCode.CompanyCode        =  ExtNumByDefault.CompanyCode
                                                        and ExtNumByDefault.CompanyCode <> ''
                                                        or  ExtNumByDefault.CompanyCode =  ''

{
  ExtNumByDefault.CompanyCode            as CustCompanyCode,
  ExtNumByDefault.AccountingDocumentType as CustAccountingDocumentType,

  CompCode.CompanyCode,
  AccDocType.AccountingDocumentType,
  ExtNumByDefault.ExtDocNmbrAndDteAreFilled,
  ExtNumByDefault.Rank
}

Learn More