C_OpenSalesOrder

DDL: C_OPENSALESORDER Type: view CONSUMPTION Package: ODATA_SD_CUSTOMER360

Open Sales Orders

C_OpenSalesOrder is a Consumption CDS View that provides data about "Open Sales Orders" in SAP S/4HANA. It reads from 1 data source (I_SalesOrder) and exposes 14 fields with key field SalesOrder. It has 1 association to related views. Part of development package ODATA_SD_CUSTOMER360.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrder I_SalesOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.SoldToParty = _Customer.Customer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName COPENSLSORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Open Sales Orders view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder
TransactionCurrency TransactionCurrency
TotalNetAmount TotalNetAmount
RequestedDeliveryDate RequestedDeliveryDate
OverallSDProcessStatus OverallSDProcessStatus
SoldToParty SoldToParty
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesOffice SalesOffice
SalesGroup SalesGroup
CustomerName _Customer CustomerName
SalesOrderType SalesOrderType
_Customer _Customer 
@AbapCatalog: {sqlViewName: 'COPENSLSORD',
                compiler.compareFilter: true,
                preserveKey: true
              }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #BLOCKED_DATA_EXCLUDED
                }
@VDM: {
  viewType: #CONSUMPTION
      }

@ObjectModel: { usageType.dataClass: #MIXED,
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #L
              }

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Open Sales Orders'

@Metadata:{ allowExtensions: true,
ignorePropagatedAnnotations: true
          }

//@UI.selectionVariant: [{qualifier: 'OpenSO', SelectOptions: [{ name: 'OverallSDProcessStatus' }] }]

define view C_OpenSalesOrder
  as select from I_SalesOrder
  
    association [0..1] to I_Customer as _Customer on $projection.SoldToParty = _Customer.Customer

{
  key SalesOrder,
  


      @Semantics.currencyCode: true
      TransactionCurrency,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,
      RequestedDeliveryDate,
      OverallSDProcessStatus,

      /* Filters */
      @ObjectModel.foreignKey.association: '_Customer'
      SoldToParty,
      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,
      SalesOffice,
      SalesGroup,
      _Customer.CustomerName,
      //commented as a part of UserStory:FXUBLR07-27, it could be added in the future release

      // _Customer.CustomerClassification,

      //CreatedByUser,

      //LastChangedByUser,


      /* Field added for DCL*/
      @Consumption.hidden: true
      SalesOrderType,

      @Consumption.filter.hidden: true
      _Customer
}
where
      SalesOrderProcessingType <> 'P'
  and OverallSDProcessStatus   <> 'C'

Learn More