P_DCD4_2

DDL: P_DCD4_2 Type: view_entity COMPOSITE Package: UKM_DCD_ANALYTICS

Credit Decision Document 4 - V2

P_DCD4_2 is a Composite CDS View that provides data about "Credit Decision Document 4 - V2" in SAP S/4HANA. It reads from 2 data sources (I_SalesOrder, P_DCD3_2) and exposes 14 fields with key field SalesOrder. It has 1 association to related views. Part of development package UKM_DCD_ANALYTICS.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesOrder I_SalesOrder from
P_DCD3_2 P_DCD3_2 left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CreditControlArea2Segment _CreditControlArea2Segment $projection.CreditControlArea = _CreditControlArea2Segment.CreditControlArea

Annotations (5)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrder SalesOrder
SalesOrderType I_SalesOrder SalesOrderType
OrganizationDivision I_SalesOrder OrganizationDivision
SalesOrganization I_SalesOrder SalesOrganization
DistributionChannel I_SalesOrder DistributionChannel
CreationDate I_SalesOrder CreationDate
SoldToParty I_SalesOrder SoldToParty
BusinessPartner
CreditControlArea I_SalesOrder CreditControlArea
CreditSegment _CreditControlArea2Segment CreditSegment
SalesOrderHasCreditDecisionDoc P_DCD3_2 SalesOrderHasCreditDecisionDoc
_SalesOrderType I_SalesOrder _SalesOrderType
_SoldToParty I_SalesOrder _SoldToParty
_CreditControlArea I_SalesOrder _CreditControlArea 
@VDM: { viewType: #COMPOSITE, 
        private: true  }       
@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData:       { blocking: #REQUIRED } }
@Metadata: { ignorePropagatedAnnotations: true }

define view entity P_DCD4_2
  as select from    I_SalesOrder
    left outer join P_DCD3_2 on I_SalesOrder.SalesOrder = P_DCD3_2.CreditDecisionReferenceDoc
  association [0..1] to I_CreditControlArea2Segment as _CreditControlArea2Segment on $projection.CreditControlArea = _CreditControlArea2Segment.CreditControlArea
{
  key I_SalesOrder.SalesOrder                  as SalesOrder,
      I_SalesOrder.SalesOrderType,
      I_SalesOrder.OrganizationDivision,
      I_SalesOrder.SalesOrganization,
      I_SalesOrder.DistributionChannel,
      I_SalesOrder.CreationDate,
      I_SalesOrder.SoldToParty,
      I_SalesOrder._SoldToParty._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
      I_SalesOrder.CreditControlArea,
      _CreditControlArea2Segment.CreditSegment as CreditSegment,
      P_DCD3_2.SalesOrderHasCreditDecisionDoc,

      case when P_DCD3_2.SalesOrderHasCreditDecisionDoc = 'X'
       then 1
       else 0
      end                                      as NumberOfCreditDecisionDocs,

      I_SalesOrder._SalesOrderType,
      I_SalesOrder._SoldToParty,
      I_SalesOrder._CreditControlArea
}

Learn More