P_DCD_4

DDL: P_DCD_4 SQL: PDCD4 Type: view COMPOSITE

P_DCD_4 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SalesOrder, P_DCD_3) and exposes 14 fields with key field SalesOrder. It has 1 association to related views.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesOrder I_SalesOrder from
P_DCD_3 P_DCD_3 left_outer

Associations (1)

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

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PDCD4 view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrder SalesOrder
SalesOrderType SalesOrderType
OrganizationDivision OrganizationDivision
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
CreationDate CreationDate
SoldToParty SoldToParty
BusinessPartner
CreditControlArea CreditControlArea
CreditSegment _CreditControlArea2Segment CreditSegment
SalesOrderHasCreditDecisionDoc P_DCD_3 SalesOrderHasCreditDecisionDoc
_SalesOrderType _SalesOrderType
_SoldToParty _SoldToParty
_CreditControlArea _CreditControlArea 
//@EndUserText.label: 'Documented Credit Decision 4'

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PDCD4'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@ObjectModel.representativeKey: ['SalesOrder' ]
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
define view P_DCD_4
  as select from    I_SalesOrder
    left outer join P_DCD_3 on I_SalesOrder.SalesOrder = P_DCD_3.CreditDecisionSalesDocument
  association [0..1] to I_CreditControlArea2Segment as _CreditControlArea2Segment on $projection.CreditControlArea = _CreditControlArea2Segment.CreditControlArea
{
  key I_SalesOrder.SalesOrder                  as SalesOrder,
      SalesOrderType,
      OrganizationDivision,
      SalesOrganization,
      DistributionChannel,
      CreationDate,
      SoldToParty,
      I_SalesOrder._SoldToParty._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
      CreditControlArea,
      _CreditControlArea2Segment.CreditSegment as CreditSegment,
      P_DCD_3.SalesOrderHasCreditDecisionDoc,

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

      _SalesOrderType,
      _SoldToParty,
      _CreditControlArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CREDITCONTROLAREA2SEGMENT",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_SALESORDER",
"P_DCD_3"
],
"ASSOCIATED":
[
"I_CREDITCONTROLAREA",
"I_CREDITCONTROLAREA2SEGMENT",
"I_CUSTOMER",
"I_SALESORDERTYPE"
],
"BASE":
[
"I_SALESORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More