A_SlsOrdScheduleLineSimln_2
Sales Order Schedule Line Simulation
A_SlsOrdScheduleLineSimln_2 is a Consumption CDS View that provides data about "Sales Order Schedule Line Simulation" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderScheduleLine) and exposes 26 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 1 association to related views. It is exposed through 1 OData service (API_SALESORDERSIMULATION). Part of development package ODATA_SD_SALESORDER_API.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesOrderScheduleLine | SalesOrderScheduleLine | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | A_SalesOrderSimulation_2 | _SalesOrder | $projection.SalesOrder = _SalesOrder.SalesOrder |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Sales Order Schedule Line Simulation | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.query.implementedBy | ABAP:CL_SD_SO_SIMLN_RAP_V4_QRY | view | |
| OData.entityType.name | SalesOrderScheduleLine_Type | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| VDM.viewType | #CONSUMPTION | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| API_SALESORDERSIMULATION | API_SALESORDERSIMULATION | V4 | C2 | C1 |
Fields (26)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesOrder | I_SalesOrderScheduleLine | SalesOrder | |
| KEY | SalesOrderItem | I_SalesOrderScheduleLine | SalesOrderItem | |
| KEY | ScheduleLine | I_SalesOrderScheduleLine | ScheduleLine | |
| ScheduleLineCategory | I_SalesOrderScheduleLine | ScheduleLineCategory | ||
| ScheduleLineOrderQuantity_H | ||||
| ScheduleLineOrderQuantity | ScheduleLineOrderQuantity | |||
| OrderQuantitySAPUnit | OrderQuantityUnit | |||
| OrderQuantityISOUnit | ||||
| RequestedDeliveryDate | RequestedDeliveryDate | |||
| ConfirmedDeliveryDate | ConfirmedDeliveryDate | |||
| ConfdOrdQtyByMatlAvailCheck_H | ||||
| ConfdOrderQtyByMatlAvailCheck | ConfdOrderQtyByMatlAvailCheck | |||
| DeliveredQtyInOrderQtyUnit | DeliveredQtyInOrderQtyUnit | |||
| OpenConfdDelivQtyInOrdQtyUnit | OpenConfdDelivQtyInOrdQtyUnit | |||
| CorrectedQtyInOrderQtyUnit | CorrectedQtyInOrderQtyUnit | |||
| DelivBlockReasonForSchedLine | DelivBlockReasonForSchedLine | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem_H | ||||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| GoodsMovementType | I_SalesOrderScheduleLine | GoodsMovementType | ||
| _Item | _Item | |||
| _SalesOrder | _SalesOrder | |||
| SalesOrderType | _SalesOrder | SalesOrderType | ||
| OrganizationDivision | _SalesOrder | OrganizationDivision | ||
| SalesOrganization | _SalesOrder | SalesOrganization | ||
| DistributionChannel | _SalesOrder | DistributionChannel |
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@EndUserText.label: 'Sales Order Schedule Line Simulation'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
semanticKey: ['SalesOrder','SalesOrderItem', 'ScheduleLine'],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XL
},
query.implementedBy: 'ABAP:CL_SD_SO_SIMLN_RAP_V4_QRY'
}
@OData: {
entityType.name: 'SalesOrderScheduleLine_Type'
}
@VDM: {
lifecycle.contract.type: #PUBLIC_REMOTE_API,
viewType: #CONSUMPTION,
usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
define view entity A_SlsOrdScheduleLineSimln_2
as select from I_SalesOrderScheduleLine as SalesOrderScheduleLine
association to parent A_SalesOrderItemSimulation_2 as _Item on $projection.SalesOrder = _Item.SalesOrder
and $projection.SalesOrderItem = _Item.SalesOrderItem
association [1..1] to A_SalesOrderSimulation_2 as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder
{
key SalesOrderScheduleLine.SalesOrder,
key SalesOrderScheduleLine.SalesOrderItem,
key SalesOrderScheduleLine.ScheduleLine,
@ObjectModel.sapObjectNodeTypeReference: 'SalesDocScheduleLineCategory'
SalesOrderScheduleLine.ScheduleLineCategory,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'ScheduleLineOrderQuantity'
cast( '' as rap_null_value_indicator ) as ScheduleLineOrderQuantity_H,
@Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
ScheduleLineOrderQuantity,
OrderQuantityUnit as OrderQuantitySAPUnit,
cast(_OrderQuantityUnit.UnitOfMeasureISOCode as sd_ord_qty_isounit preserving type) as OrderQuantityISOUnit,
RequestedDeliveryDate,
ConfirmedDeliveryDate,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'ConfdOrderQtyByMatlAvailCheck'
cast( '' as rap_null_value_indicator ) as ConfdOrdQtyByMatlAvailCheck_H,
@Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
ConfdOrderQtyByMatlAvailCheck,
@Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
DeliveredQtyInOrderQtyUnit,
@Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
OpenConfdDelivQtyInOrdQtyUnit,
@Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
@Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
CorrectedQtyInOrderQtyUnit,
@ObjectModel.sapObjectNodeTypeReference: 'DeliveryBlockReason'
DelivBlockReasonForSchedLine,
PurchaseRequisition,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'PurchaseRequisitionItem'
cast( '' as rap_null_value_indicator ) as PurchaseRequisitionItem_H,
PurchaseRequisitionItem,
@ObjectModel.sapObjectNodeTypeReference: 'GoodsMovementType'
SalesOrderScheduleLine.GoodsMovementType,
//Parent
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
_Item,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
_SalesOrder,
// For Access control
@Consumption.hidden: true
_SalesOrder.SalesOrderType,
@Consumption.hidden: true
_SalesOrder.OrganizationDivision,
@Consumption.hidden: true
_SalesOrder.SalesOrganization,
@Consumption.hidden: true
_SalesOrder.DistributionChannel
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA