P_SalesOrderDateCalc

DDL: P_SALESORDERDATECALC Type: view CONSUMPTION

P_SalesOrderDateCalc is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesOrder) and exposes 16 fields with key field SalesOrder. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrder I_SalesOrder from

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PSDDTCALC 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.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder
SalesOrderDate SalesOrderDate
TodaysDate
SalesOrderType SalesOrderType
IncomingSalesOrdersNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
CreationDate CreationDate
SoldToParty SoldToParty
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesOffice SalesOffice
SalesGroup SalesGroup
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
_SalesOrderDate _SalesOrderDate 
@AbapCatalog:{ sqlViewName: 'PSDDTCALC',
               compiler.compareFilter: true,
               preserveKey: true

              }

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

@ObjectModel: { usageType.dataClass: #TRANSACTIONAL,
                usageType.serviceQuality: #P,
                usageType.sizeCategory: #L
              }

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view P_SalesOrderDateCalc
  as select from I_SalesOrder

  association [1..1] to I_CalendarDate as _SalesOrderDate on _SalesOrderDate.CalendarDate = $projection.CreationDate

{

  key SalesOrder,
      SalesOrderDate,
      $session.system_date              as  TodaysDate,
      SalesOrderType,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount                    as  IncomingSalesOrdersNetAmount,

      @Semantics.currencyCode: true
      TransactionCurrency,
      
      CreationDate, 

      /* Filters */
      SoldToParty,
      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,
      SalesOffice,
      SalesGroup,
      CreatedByUser,
      LastChangedByUser,

      /* Associations */
      _SalesOrderDate


}
where
  SalesOrderProcessingType <> 'P'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESORDER"
],
"ASSOCIATED":
[
"I_CALENDARDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More