P_MLCOLL_DIRECTPAYERS5

CDS View

P_MLCOLL_DIRECTPAYERS5 is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MLColl_AcctgDocItemCleared view inner COMPOSITE
P_MLColl_AcctgDocItemOpen view inner COMPOSITE 
@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