P_SalesOrderWithHeaderIssue

DDL: P_SALESORDERWITHHEADERISSUE Type: view_entity COMPOSITE Package: VDM_SD_SOF

Sales Order With Header Issue

P_SalesOrderWithHeaderIssue is a Composite CDS View that provides data about "Sales Order With Header Issue" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 1 field with key field SalesOrder. Part of development package VDM_SD_SOF.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic SOH inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SOI_ISSUE SalesOrder 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Sales Order With Header Issue'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_SalesOrderWithHeaderIssue
  as select distinct from P_SlsDocFlfmtRelatedSalesOrder as SOI_ISSUE
    inner join            I_SalesDocumentBasic           as SOH on SOI_ISSUE.SalesOrder = SOH.SalesDocument
{
  key SOI_ISSUE.SalesOrder
}
where // SO01

      (    ( SOH.OverallTotalDeliveryStatus    = 'A' or SOH.OverallTotalDeliveryStatus    = 'B' )
       and ( SOH.HeaderDelivIncompletionStatus = 'A' or SOH.HeaderDelivIncompletionStatus = 'B' )
      )
   or (    ( SOH.HeaderBillgIncompletionStatus = 'A' or SOH.HeaderBillgIncompletionStatus = 'B' )
        or ( SOH.OverallPricingIncompletionSts = 'A' or SOH.OverallPricingIncompletionSts = 'B' )
      )
     // SO02

   or (    SOH.OverallDeliveryBlockStatus =  'C'
       and ( SOH.DeliveryBlockReason        <> ''  or SOH.ControllingObject          <> '' )
       and ( SOH.OverallTotalDeliveryStatus =  'A' or SOH.OverallTotalDeliveryStatus =  'B' )
      )
    // SO03

   or ( SOH.TotalCreditCheckStatus  =  'B' and ( SOH.OverallTotalDeliveryStatus <> 'C' or SOH.OverallOrdReltdBillgStatus = '' ) )
    // SO04

   or (       SOH.OverallBillingBlockStatus =  'C'
        and ( SOH.HeaderBillingBlockReason  != '' or SOH.ControllingObject         != '' )
      )

Learn More