P_MLColl_DirectPayers5

DDL: P_MLCOLL_DIRECTPAYERS5 Type: view COMPOSITE

P_MLColl_DirectPayers5 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CustomerCompany) and exposes 2 fields.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerCompany I_CustomerCompany from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMLDIRECTPAYERS5 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
Customer I_CustomerCompany Customer
CompanyCode I_CustomerCompany CompanyCode 
@AbapCatalog: { sqlViewName: 'PMLDIRECTPAYERS5',
                compiler: { compareFilter: true },
                preserveKey: true }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@AccessControl: { authorizationCheck: #NOT_REQUIRED }
@VDM: { private:true,
        viewType: #COMPOSITE }

define view P_MLColl_DirectPayers5
  as select from           I_CustomerCompany
    left outer to one join P_MLColl_DirectPayers4 as DP4 on  I_CustomerCompany.Customer    = DP4.Customer
                                                         and I_CustomerCompany.CompanyCode = DP4.CompanyCode
{
  // VDM fields

  I_CustomerCompany.Customer,
  I_CustomerCompany.CompanyCode
}

where
  DP4.xNoDirectPayer_Result is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERCOMPANY",
"P_MLCOLL_DIRECTPAYERS4"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More