P_CustomerReturnItemEnhanced
P_CustomerReturnItemEnhanced is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_CustomerReturnItem) and exposes 28 fields with key fields CustomerReturn, CustomerReturnItem. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CustomerReturnItem | Item | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_CustomerReturnEnhanced | _CustomerReturn | _CustomerReturn.CustomerReturn = $projection.CustomerReturn |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | PCRTITMENH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| VDM.private | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (28)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CustomerReturn | I_CustomerReturnItem | CustomerReturn | |
| KEY | CustomerReturnItem | I_CustomerReturnItem | CustomerReturnItem | |
| CustomerReturnItemCategory | I_CustomerReturnItem | CustomerReturnItemCategory | ||
| Product | I_CustomerReturnItem | Product | ||
| Batch | I_CustomerReturnItem | Batch | ||
| Plant | I_CustomerReturnItem | Plant | ||
| BillOfMaterial | I_CustomerReturnItem | BillOfMaterial | ||
| OrderQuantity | I_CustomerReturnItem | OrderQuantity | ||
| OrderQuantityUnit | I_CustomerReturnItem | OrderQuantityUnit | ||
| NetAmount | I_CustomerReturnItem | NetAmount | ||
| TransactionCurrency | I_CustomerReturnItem | TransactionCurrency | ||
| HigherLevelItem | I_CustomerReturnItem | HigherLevelItem | ||
| RetsMgmtProcess | I_CustomerReturnItem | RetsMgmtProcess | ||
| RetsMgmtProcessItem | AdvncdRetsMgmtProcessItem | RetsMgmtProcessItem | ||
| ReturnsRefundExtent | I_CustomerReturnItem | ReturnsRefundExtent | ||
| RetsMgmtProcessingBlock | I_CustomerReturnItem | RetsMgmtProcessingBlock | ||
| ReturnsRefundRjcnReason | AdvncdRetsMgmtProcessItem | ReturnsRefundRjcnReason | ||
| RetsMgmtProcItmQtySplit | AdvncdRetsMgmtProcessStep | RetsMgmtProcItmQtySplit | ||
| CustRetItmFollowUpActivity | AdvncdRetsMgmtProcessStep | CustRetItmFollowUpActivity | ||
| ReturnsRefundType | AdvncdRetsMgmtProcessStep | ReturnsRefundType | ||
| ReturnsRefundProcgMode | AdvncdRetsMgmtProcessStep | ReturnsRefundProcgMode | ||
| ReplacementMaterial | AdvncdRetsMgmtProcessStep | ReplacementMaterial | ||
| ReplacementMaterialQuantity | AdvncdRetsMgmtProcessStep | ReplacementMaterialQuantity | ||
| ReplacementMaterialQtyUnit | AdvncdRetsMgmtProcessStep | ReplacementMaterialQtyUnit | ||
| ReplacementMatlSupplyingPlant | AdvncdRetsMgmtProcessStep | ReplacementMatlSupplyingPlant | ||
| ItemGeneralIncompletionStatus | I_CustomerReturnItem | ItemGeneralIncompletionStatus | ||
| SDDocumentRejectionStatus | I_CustomerReturnItem | SDDocumentRejectionStatus | ||
| _CustomerReturn | _CustomerReturn |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PCRTITMENH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_CustomerReturnItemEnhanced
as select from I_CustomerReturnItem as Item
left outer to one join P_AdvncdReturnsMgmtProcessItem as AdvncdRetsMgmtProcessItem on AdvncdRetsMgmtProcessItem.RetsMgmtProcess = Item.RetsMgmtProcess
and AdvncdRetsMgmtProcessItem.RetsMgmtProcessItem = Item.CustomerReturnItem
and AdvncdRetsMgmtProcessItem.ReturnsDocument = Item.CustomerReturn
left outer to one join P_AdvncdReturnsMgmtProcessStep as AdvncdRetsMgmtProcessStep on AdvncdRetsMgmtProcessStep.RetsMgmtProcess = Item.RetsMgmtProcess
and AdvncdRetsMgmtProcessStep.RetsMgmtProcessItem = Item.CustomerReturnItem
and AdvncdRetsMgmtProcessStep.ReturnsDocument = Item.CustomerReturn
and AdvncdRetsMgmtProcessStep.RetsMgmtProcItmQtySplit = '000'
and AdvncdRetsMgmtProcessStep.RetsMgmtProcessStep = '0001'
and AdvncdRetsMgmtProcessStep.ReturnsDocumentType = '00' //
//Association
association [1..1] to I_CustomerReturnEnhanced as _CustomerReturn on _CustomerReturn.CustomerReturn = $projection.CustomerReturn
{
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CustomerReturnStdVH',
element: 'CustomerReturn' }
}]
@ObjectModel.foreignKey.association: '_CustomerReturn'
key Item.CustomerReturn,
key Item.CustomerReturnItem,
//Category
Item.CustomerReturnItemCategory,
// //Product
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'I_MaterialStdVH',
// element: 'Material' }
// }]
// @API.element.releaseState: #DEPRECATED
// @API.element.successor: 'Product'
// Item.Material,
@Analytics.internalName: #LOCAL
Item.Product,
Item.Batch,
Item.Plant,
Item.BillOfMaterial,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
Item.OrderQuantity,
@Semantics.unitOfMeasure: true
Item.OrderQuantityUnit,
//Pricing
@Semantics.amount.currencyCode: 'TransactionCurrency'
Item.NetAmount,
@Semantics.currencyCode: true
Item.TransactionCurrency,
Item.HigherLevelItem,
//Advanced Returns Management Process
Item.RetsMgmtProcess,
//Advanced Returns Management Process Item
AdvncdRetsMgmtProcessItem.RetsMgmtProcessItem,
Item.ReturnsRefundExtent,
Item.RetsMgmtProcessingBlock,
AdvncdRetsMgmtProcessItem.ReturnsRefundRjcnReason,
//Advanced Returns Management Process Step (Return Order)
AdvncdRetsMgmtProcessStep.RetsMgmtProcItmQtySplit,
AdvncdRetsMgmtProcessStep.CustRetItmFollowUpActivity,
AdvncdRetsMgmtProcessStep.ReturnsRefundType,
AdvncdRetsMgmtProcessStep.ReturnsRefundProcgMode,
AdvncdRetsMgmtProcessStep.ReplacementMaterial,
@Semantics.quantity.unitOfMeasure: 'ReplacementMaterialQtyUnit'
AdvncdRetsMgmtProcessStep.ReplacementMaterialQuantity,
//@Semantics.unitOfMeasure: true
AdvncdRetsMgmtProcessStep.ReplacementMaterialQtyUnit,
AdvncdRetsMgmtProcessStep.ReplacementMatlSupplyingPlant,
//Status
Item.ItemGeneralIncompletionStatus,
Item.SDDocumentRejectionStatus,
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
#TO_COMPOSITION_ROOT]
_CustomerReturn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERRETURNITEM",
"P_ADVNCDRETURNSMGMTPROCESSITEM",
"P_ADVNCDRETURNSMGMTPROCESSSTEP"
],
"ASSOCIATED":
[
"I_CUSTOMERRETURNENHANCED"
],
"BASE":
[],
"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