P_RejectedSalesOrder

DDL: P_REJECTEDSALESORDER Type: view CONSUMPTION

Rejected Sales Order Date Calculation

P_RejectedSalesOrder is a Consumption CDS View that provides data about "Rejected Sales Order Date Calculation" in SAP S/4HANA. It reads from 1 data source (I_SalesOrder) and exposes 15 fields with key field SalesOrder. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrder I_SalesOrder from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CalendarDate _SalesOrderDate _SalesOrderDate.CalendarDate = $projection.CreationDate

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PREJCTDSLSORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Rejected Sales Order Date Calculation view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder
TodaysDate
CreationDate CreationDate
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts
SoldToParty SoldToParty
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesOffice SalesOffice
SalesGroup SalesGroup
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
SalesOrderType SalesOrderType
OvrlSDDocumentRejectionStsDesc
_SalesOrderDate _SalesOrderDate 
@AbapCatalog:{  sqlViewName: 'PREJCTDSLSORD',
                compiler.compareFilter: true,
                preserveKey: true
}

@AccessControl: { authorizationCheck: #PRIVILEGED_ONLY,
                  personalData.blocking: #NOT_REQUIRED
                }
@VDM: {
  viewType: #CONSUMPTION,
  private: true
      }

@ObjectModel.usageType.serviceQuality: #P
                          
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Rejected Sales Order Date Calculation'
@Metadata.ignorePropagatedAnnotations: true

@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: ''

define view P_RejectedSalesOrder 
 as select from I_SalesOrder
 
 association [1..1] to I_CalendarDate as _SalesOrderDate on _SalesOrderDate.CalendarDate = $projection.CreationDate
 
{
      key SalesOrder,
   
      $session.system_date              as  TodaysDate,
   
      CreationDate, 
   
      OverallSDDocumentRejectionSts,
   
      /* Filters */
      SoldToParty,
      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,
      SalesOffice,
      SalesGroup,
      CreatedByUser,
      LastChangedByUser,

      SalesOrderType,
      
      _OverallSDDocumentRejectionSts._Text[1: Language = $session.system_language ].OvrlSDDocumentRejectionStsDesc,
      
      /* Associations */
      _SalesOrderDate
      
}
where
       SalesOrderProcessingType      <> 'P'
  and(
       OverallSDDocumentRejectionSts =  'B'
    or OverallSDDocumentRejectionSts =  'C'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OVERALLSDDOCUMENTRJCNSTATUS",
"I_OVERALLSDDOCUMENTRJCNSTATUST",
"I_SALESORDER"
],
"ASSOCIATED":
[
"I_CALENDARDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More