C_RFDYSalesOrder
Release for Delivery Sales Order
C_RFDYSalesOrder is a Consumption CDS View that provides data about "Release for Delivery Sales Order" in SAP S/4HANA. It reads from 1 data source (I_SalesOrder) and exposes 23 fields with key field SalesOrder. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesOrder | I_SalesOrder | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..*] | C_RFDYSalesOrderItem | _RFDYSalesOrderItem | $projection.SalesOrder = _RFDYSalesOrderItem.SalesOrder |
| [0..1] | I_Customer | _ShipToParty | $projection.ShipToParty = _ShipToParty.Customer |
| [0..*] | I_SalesDocumentTypeText | _SalesOrderTypeText | $projection.SalesOrderType = _SalesOrderTypeText.SalesDocumentType |
| [0..*] | I_SalesOrganizationText | _SalesOrganizationText | $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization |
| [0..*] | I_DistributionChannelText | _DistributionChannelText | $projection.DistributionChannel = _DistributionChannelText.DistributionChannel |
| [0..*] | I_DivisionText | _OrganizationDivisionText | $projection.OrganizationDivision = _OrganizationDivisionText.Division |
| [0..*] | I_ShippingConditionText | _ShippingConditionText | $projection.ShippingCondition = _ShippingConditionText.ShippingCondition |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #CONSUMPTION | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | CRFDYSO | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| EndUserText.label | Release for Delivery Sales Order | view |
Fields (23)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesOrder | SalesOrder | ||
| SalesOrderType | SalesOrderType | |||
| SalesOrganization | SalesOrganization | |||
| DistributionChannel | DistributionChannel | |||
| OrganizationDivision | OrganizationDivision | |||
| SalesOrderDate | SalesOrderDate | |||
| SoldToParty | SoldToParty | |||
| ShipToParty | ||||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | |||
| ShippingCondition | ShippingCondition | |||
| _RFDYSalesOrderItem | _RFDYSalesOrderItem | |||
| _SalesOrderType | _SalesOrderType | |||
| _SalesOrderTypeText | _SalesOrderTypeText | |||
| _SalesOrganization | _SalesOrganization | |||
| _SalesOrganizationText | _SalesOrganizationText | |||
| _DistributionChannel | _DistributionChannel | |||
| _DistributionChannelText | _DistributionChannelText | |||
| _OrganizationDivision | _OrganizationDivision | |||
| _OrganizationDivisionText | _OrganizationDivisionText | |||
| _SoldToParty | _SoldToParty | |||
| _ShipToParty | _ShipToParty | |||
| _ShippingCondition | _ShippingCondition | |||
| _ShippingConditionText | _ShippingConditionText |
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CRFDYSO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AccessControl.privilegedAssociations: [ '_RFDYSalesOrderItem', '_SoldToParty', '_ShipToParty' ]
@ObjectModel.usageType: {
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
@EndUserText.label: 'Release for Delivery Sales Order'
define view C_RFDYSalesOrder
as select from I_SalesOrder
association [1..*] to C_RFDYSalesOrderItem as _RFDYSalesOrderItem on $projection.SalesOrder = _RFDYSalesOrderItem.SalesOrder
association [0..1] to I_Customer as _ShipToParty on $projection.ShipToParty = _ShipToParty.Customer
association [0..*] to I_SalesDocumentTypeText as _SalesOrderTypeText on $projection.SalesOrderType = _SalesOrderTypeText.SalesDocumentType
association [0..*] to I_SalesOrganizationText as _SalesOrganizationText on $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization
association [0..*] to I_DistributionChannelText as _DistributionChannelText on $projection.DistributionChannel = _DistributionChannelText.DistributionChannel
association [0..*] to I_DivisionText as _OrganizationDivisionText on $projection.OrganizationDivision = _OrganizationDivisionText.Division
association [0..*] to I_ShippingConditionText as _ShippingConditionText on $projection.ShippingCondition = _ShippingConditionText.ShippingCondition
// association [1..1] to C_RFDYSalesOrderConfirmation as _RFDYSalesOrderConfirmation on $projection.RFDYRequirementUUID = _RFDYSalesOrderConfirmation.RFDYRequirementUUID
{
key SalesOrder,
@ObjectModel.text.association: '_SalesOrderTypeText'
SalesOrderType,
// Sales Area
@ObjectModel.text.association: '_SalesOrganizationText'
SalesOrganization,
@ObjectModel.text.association: '_DistributionChannelText'
DistributionChannel,
@ObjectModel.text.association: '_OrganizationDivisionText'
OrganizationDivision,
SalesOrderDate,
@Consumption.valueHelpDefinition: null
@ObjectModel.text.association: '_SoldToParty'
SoldToParty,
@ObjectModel.readOnly: true
@ObjectModel.text.association: '_ShipToParty'
_Partner[PartnerFunction='WE'].Customer as ShipToParty,
PurchaseOrderByCustomer,
@ObjectModel.text.association: '_ShippingConditionText'
ShippingCondition,
_RFDYSalesOrderItem,
_SalesOrderType,
_SalesOrderTypeText,
_SalesOrganization,
_SalesOrganizationText,
_DistributionChannel,
_DistributionChannelText,
_OrganizationDivision,
_OrganizationDivisionText,
_SoldToParty,
_ShipToParty,
_ShippingCondition,
_ShippingConditionText
// _RFDYSalesOrderConfirmation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESORDER",
"I_SALESORDERPARTNER"
],
"ASSOCIATED":
[
"C_RFDYSALESORDERITEM",
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISION",
"I_DIVISIONTEXT",
"I_SALESDOCUMENTTYPETEXT",
"I_SALESORDERTYPE",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"I_SHIPPINGCONDITION",
"I_SHIPPINGCONDITIONTEXT"
],
"BASE":
[
"I_SALESORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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