P_PROMISETOPAY0

CDS View

P_PROMISETOPAY0 is a CDS View in S/4HANA. It contains 13 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 13 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ARPromisesToPayOvw view inner COMPOSITE
P_PromiseToPay1 view from COMPOSITE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY case_guid case_guid 1
CaseSystemStatus CaseSystemStatus 1
CompanyCode CompanyCode 1
CreationDate CreationDate 1
Customer Customer 1
CustomerCntctFollowUpObjStatus CustomerCntctFollowUpObjStatus 1
CustomerContactUUID CustomerContactUUID 1
DueDate DueDate 1
GroupCurrency GroupCurrency 1
PaidAmount PaidAmount 1
PromisedAmount PromisedAmount 1
SourceCurrency SourceCurrency 1
Status Status 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PPROMISETOPAY0'
//@EndUserText.label: 'Promise To Pay 0'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_PromiseToPay0
  as select from    I_PromiseToPay            as udm_p2p_attr

    left outer join I_CustomerContactRelation as udm_cct_rel on udm_p2p_attr.DisputeCaseUUID = udm_cct_rel.CaseUUID

  association [0..1] to I_SAPClient     as _SapClient     on udm_p2p_attr.mandt = _SapClient.sapclient

  association [0..1] to I_CaseAttribute as _CaseAttribute on udm_p2p_attr.DisputeCaseUUID = _CaseAttribute.CaseUniqueID

{
  key udm_p2p_attr.DisputeCaseUUID as case_guid,
      udm_cct_rel.CustomerContactUUID,
      _SapClient.GroupCurrency,
      udm_p2p_attr.CompanyCode,
      udm_p2p_attr.Customer,
      udm_p2p_attr.PromisedAmount,
      udm_p2p_attr.PaidAmount,
      udm_p2p_attr.Currency        as SourceCurrency,
      udm_p2p_attr.DueDate,
      udm_p2p_attr.CreationDate,
      udm_p2p_attr.Status,
      udm_cct_rel.CustomerCntctFollowUpObjStatus,
      _CaseAttribute.CaseSystemStatus
}
where
  (
       udm_p2p_attr.Status = '0' //Open

    or udm_p2p_attr.Status = '1' //Broken

    //     or udm_p2p_attr.Status = '2' )  //Part. kept

  )
  and  udm_p2p_attr.Status != '4'
  //and  not ( udm_cct_rel.CustomerCntctFollowUpObjStatus = '1'

  //        or udm_cct_rel.CustomerCntctFollowUpObjStatus = '2'

  //        or udm_cct_rel.CustomerCntctFollowUpObjStatus = '3'

  //        or udm_cct_rel.CustomerCntctFollowUpObjStatus = '4' )

  //and udm_cct_rel.CustomerCntctFollowUpObjType = 'P2P'

  and(
       //        _CaseAttribute.CaseSystemStatus != '008' //"Confirmed". We keep these entries!

       _CaseAttribute.CaseSystemStatus != '009' //"Void"

  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASEATTRIBUTE",
"I_CUSTOMERCONTACTRELATION",
"I_PROMISETOPAY",
"I_SAPCLIENT"
],
"ASSOCIATED":
[
"I_CASEATTRIBUTE",
"I_SAPCLIENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More