P_PromiseToPay1

DDL: P_PROMISETOPAY1 SQL: PPROMISETOPAY1 Type: view COMPOSITE

P_PromiseToPay1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_PromiseToPay0, I_CustomerContactAttribute) and exposes 21 fields with key field case_guid.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
P_PromiseToPay0 p2p0 from
I_CustomerContactAttribute udm_cct_attr left_outer

Parameters (6)

NameTypeDefault
P_KeyDate sydate
P_DisplayCurrency vdm_v_display_currency
P_ExchangeRateType kurst_curr
P_NetDueInterval1InDays farp_due_interval1
P_NetDueInterval2InDays farp_due_interval2
P_NetDueInterval3InDays farp_due_interval3

Annotations (5)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY case_guid P_PromiseToPay0 case_guid
CustomerContactUUID P_PromiseToPay0 CustomerContactUUID
GroupCurrency P_PromiseToPay0 GroupCurrency
CompanyCode P_PromiseToPay0 CompanyCode
Customer P_PromiseToPay0 Customer
PromisedAmount P_PromiseToPay0 PromisedAmount
PaidAmount P_PromiseToPay0 PaidAmount
SourceCurrency P_PromiseToPay0 SourceCurrency
DueDate P_PromiseToPay0 DueDate
CreationDate P_PromiseToPay0 CreationDate
Status P_PromiseToPay0 Status
CaseSystemStatus P_PromiseToPay0 CaseSystemStatus
CustomerCntctFollowUpObjStatus P_PromiseToPay0 CustomerCntctFollowUpObjStatus
CollectionSpecialistUserName I_CustomerContactAttribute CollectionSpecialist
CollectionSegment I_CustomerContactAttribute CollectionSegment
PromiseToPayDueDays
DisplayCurrency
ExchangeRateType
NetDueInterval1InDays
NetDueInterval2InDays
NetDueInterval3InDays 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PPROMISETOPAY1'
//@EndUserText.label: 'Promise To Pay 1'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_PromiseToPay1
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate,
    P_DisplayCurrency: vdm_v_display_currency,         
    @Consumption.defaultValue: 'M'
    P_ExchangeRateType : kurst_curr, 

    @Consumption.defaultValue: 10
    P_NetDueInterval1InDays : farp_due_interval1,
    @Consumption.defaultValue: 20       
    P_NetDueInterval2InDays : farp_due_interval2,
    @Consumption.defaultValue: 30    
    P_NetDueInterval3InDays : farp_due_interval3

as select from P_PromiseToPay0 as p2p0 
 
left outer join I_CustomerContactAttribute as udm_cct_attr
  on udm_cct_attr.CustomerContactUUID = p2p0.CustomerContactUUID  
{
   key p2p0.case_guid  
  ,p2p0.CustomerContactUUID
  ,p2p0.GroupCurrency 
  ,p2p0.CompanyCode 
  ,p2p0.Customer 
  ,p2p0.PromisedAmount
  ,p2p0.PaidAmount
  ,p2p0.SourceCurrency
  ,p2p0.DueDate
  ,p2p0.CreationDate
  ,p2p0.Status
  ,p2p0.CaseSystemStatus
  ,p2p0.CustomerCntctFollowUpObjStatus   
  ,udm_cct_attr.CollectionSpecialist  as CollectionSpecialistUserName
  ,udm_cct_attr.CollectionSegment

  ,dats_days_between(cast( :P_KeyDate as abap.dats(8)), p2p0.DueDate) as PromiseToPayDueDays

  ,:P_DisplayCurrency as DisplayCurrency  
  ,:P_ExchangeRateType as ExchangeRateType

  ,:P_NetDueInterval1InDays as NetDueInterval1InDays
  ,:P_NetDueInterval2InDays as NetDueInterval2InDays
  ,:P_NetDueInterval3InDays as NetDueInterval3InDays  
}

Learn More