P_MLCOLL_DIRECTPAYERS5

CDS View

ML Collections Direct Payers 5

P_MLCOLL_DIRECTPAYERS5 is a CDS View in S/4HANA. ML Collections Direct Payers 5. 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 ML Collections Acctg Doc Items Cleared
P_MLColl_AcctgDocItemOpen view inner COMPOSITE ML Collections Accounting Doc Items Open 
@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

Learn More