A_CustomerReturnItem
Returns Order Item
A_CustomerReturnItem is a Composite CDS View that provides data about "Returns Order Item" in SAP S/4HANA. It reads from 1 data source (I_CustomerReturnItemEnhanced) and exposes 95 fields with key fields CustomerReturn, CustomerReturnItem. It has 11 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CustomerReturnItemEnhanced | Item | from |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_SalesDocumentBasic | SalesDocumentBasic | SalesDocumentBasic.SalesDocument = $projection.CustomerReturn |
| [1..1] | A_CustomerReturn | _CustomerReturn | _CustomerReturn.CustomerReturn = $projection.CustomerReturn |
| [0..*] | A_CustomerReturnScheduleLine | _ScheduleLine | _ScheduleLine.CustomerReturn = $projection.CustomerReturn and _ScheduleLine.CustomerReturnItem = $projection.CustomerReturnItem |
| [0..*] | A_CustomerReturnSerialNumber | _SerialNumber | _SerialNumber.CustomerReturn = $projection.CustomerReturn and _SerialNumber.CustomerReturnItem = $projection.CustomerReturnItem |
| [0..*] | A_CustomerReturnItemPartner | _Partner | _Partner.CustomerReturn = $projection.CustomerReturn and _Partner.CustomerReturnItem = $projection.CustomerReturnItem |
| [0..*] | A_CustomerReturnItemText | _Text | _Text.CustomerReturn = $projection.CustomerReturn and _Text.CustomerReturnItem = $projection.CustomerReturnItem |
| [0..*] | A_CustomerReturnItemRelatedObj | _RelatedObject | _RelatedObject.CustomerReturn = $projection.CustomerReturn and _RelatedObject.CustomerReturnItem = $projection.CustomerReturnItem |
| [0..*] | A_CustomerReturnItemPrcgElmnt | _PricingElement | _PricingElement.CustomerReturn = $projection.CustomerReturn and _PricingElement.CustomerReturnItem = $projection.CustomerReturnItem |
| [0..*] | A_CustomerReturnProcessStep | _ProcessStep | _ProcessStep.RetsMgmtProcess = $projection.RetsMgmtProcess and _ProcessStep.RetsMgmtProcessItem = $projection.CustomerReturnItem |
| [0..*] | A_CustomerReturnValAddedSrvc | _ValueAddedService | _ValueAddedService.CustomerReturn = $projection.CustomerReturn and _ValueAddedService.CustomerReturnItem = $projection.CustomerReturnItem |
| [0..1] | E_SalesDocumentItemBasic | _Extension | $projection.CustomerReturn = _Extension.SalesDocument and $projection.CustomerReturnItem = _Extension.SalesDocumentItem |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Returns Order Item | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| AbapCatalog.sqlViewName | ACRITEM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (95)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CustomerReturn | CustomerReturn | ||
| KEY | CustomerReturnItem | CustomerReturnItem | ||
| HigherLevelItem | HigherLevelItem | |||
| CustomerReturnItemCategory | CustomerReturnItemCategory | |||
| CustomerReturnItemText | CustomerReturnItemText | |||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | |||
| Material | Material | |||
| MaterialByCustomer | MaterialByCustomer | |||
| RequestedQuantity | RequestedQuantity | |||
| RequestedQuantityUnit | RequestedQuantityUnit | |||
| ItemGrossWeight | ItemGrossWeight | |||
| ItemNetWeight | ItemNetWeight | |||
| ItemWeightUnit | ItemWeightUnit | |||
| ItemVolume | ItemVolume | |||
| ItemVolumeUnit | ItemVolumeUnit | |||
| TransactionCurrency | TransactionCurrency | |||
| NetAmount | NetAmount | |||
| MaterialGroup | MaterialGroup | |||
| Batch | Batch | |||
| ProductionPlant | Plant | |||
| StorageLocation | StorageLocation | |||
| ShippingPoint | ShippingPoint | |||
| ShippingType | ShippingType | |||
| DeliveryPriority | DeliveryPriority | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| CustomerPaymentTerms | CustomerPaymentTerms | |||
| ProductTaxClassification1 | ProductTaxClassification1 | |||
| ProductTaxClassification2 | ProductTaxClassification2 | |||
| ProductTaxClassification3 | ProductTaxClassification3 | |||
| ProductTaxClassification4 | ProductTaxClassification4 | |||
| ProductTaxClassification5 | ProductTaxClassification5 | |||
| ProductTaxClassification6 | ProductTaxClassification6 | |||
| ProductTaxClassification7 | ProductTaxClassification7 | |||
| ProductTaxClassification8 | ProductTaxClassification8 | |||
| ProductTaxClassification9 | ProductTaxClassification9 | |||
| SalesDocumentRjcnReason | SalesDocumentRjcnReason | |||
| ItemBillingBlockReason | ItemBillingBlockReason | |||
| ProfitCenter | ProfitCenter | |||
| RetsMgmtProcess | RetsMgmtProcess | |||
| RetsMgmtProcessItem | RetsMgmtProcessItem | |||
| ReturnReason | ReturnReason | |||
| RetsMgmtProcessingBlock | RetsMgmtProcessingBlock | |||
| CustRetItmFollowUpActivity | CustRetItmFollowUpActivity | |||
| ReturnsMaterialHasBeenReceived | ReturnsMaterialHasBeenReceived | |||
| ReturnsRefundType | ReturnsRefundType | |||
| ReturnsRefundProcgMode | ReturnsRefundProcgMode | |||
| RetsProdValnIsSuspended | ||||
| ReturnsRefundExtent | ReturnsRefundExtent | |||
| PrelimRefundIsDetermined | PrelimRefundIsDetermined | |||
| ReturnsRefundRjcnReason | ReturnsRefundRjcnReason | |||
| ReplacementMaterial | ReplacementMaterial | |||
| ReplacementMaterialQuantity | ReplacementMaterialQuantity | |||
| ReplacementMaterialQtyUnit | ReplacementMaterialQtyUnit | |||
| ReplacementMaterialIsRequested | ReplacementMaterialIsRequested | |||
| ReplacementMatlSupplyingPlant | ReplacementMatlSupplyingPlant | |||
| NextPlantForFollowUpActivity | NextPlantForFollowUpActivity | |||
| ReturnsTransshipmentPlant | ReturnsTransshipmentPlant | |||
| Supplier | Supplier | |||
| SupplierRetMatlAuthzn | SupplierRetMatlAuthzn | |||
| SuplrRetMatlAuthznIsRequired | SuplrRetMatlAuthznIsRequired | |||
| CustomerRetMatlInspResultCode | CustomerRetMatlInspResultCode | |||
| NextFllwUpActivityForMatlInsp | NextFllwUpActivityForMatlInsp | |||
| RetMatlInspResultCode | RetMatlInspResultCode | |||
| ProductIsInspectedAtCustSite | ProductIsInspectedAtCustSite | |||
| CustRetMatlAuthzn | CustRetMatlAuthzn | |||
| CRMLogicalSystem | CRMLogicalSystem | |||
| CRMObjectUUID | CRMObjectUUID | |||
| CRMObjectID | CRMObjectID | |||
| CRMObjectType | CRMObjectType | |||
| RetsMgmtItmLogProcgStatus | RetsMgmtItmLogProcgStatus | |||
| RetsMgmtItmCompnProcgStatus | RetsMgmtItmCompnProcgStatus | |||
| RetsMgmtItmProcgStatus | RetsMgmtItmProcgStatus | |||
| ReturnsDocumentStatus | ReturnsDocumentStatus | |||
| ReturnsDocumentApprovalStatus | ReturnsDocumentApprovalStatus | |||
| SDProcessStatus | SDProcessStatus | |||
| ReferenceSDDocument | ReferenceSDDocument | |||
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | |||
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | |||
| SDDocumentRejectionStatus | SDDocumentRejectionStatus | |||
| CustomerReturnType | SalesDocumentBasic | SalesDocumentType | ||
| OrganizationDivision | SalesDocumentBasic | OrganizationDivision | ||
| SalesOrganization | SalesDocumentBasic | SalesOrganization | ||
| DistributionChannel | SalesDocumentBasic | DistributionChannel | ||
| _CustomerReturn | _CustomerReturn | |||
| _ScheduleLine | _ScheduleLine | |||
| _SerialNumber | _SerialNumber | |||
| _Partner | _Partner | |||
| _Text | _Text | |||
| _RelatedObject | _RelatedObject | |||
| _PricingElement | _PricingElement | |||
| _ProcessStep | _ProcessStep | |||
| _ValueAddedService | _ValueAddedService |
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Returns Order Item'
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
sqlViewName: 'ACRITEM',
compiler.compareFilter: true
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #D,
sizeCategory: #XL
}
}
@Metadata.ignorePropagatedAnnotations: true
define view A_CustomerReturnItem
as select from I_CustomerReturnItemEnhanced as Item
association [1..1] to I_SalesDocumentBasic as SalesDocumentBasic on SalesDocumentBasic.SalesDocument = $projection.CustomerReturn
association [1..1] to A_CustomerReturn as _CustomerReturn on _CustomerReturn.CustomerReturn = $projection.CustomerReturn
association [0..*] to A_CustomerReturnScheduleLine as _ScheduleLine on _ScheduleLine.CustomerReturn = $projection.CustomerReturn
and _ScheduleLine.CustomerReturnItem = $projection.CustomerReturnItem
association [0..*] to A_CustomerReturnSerialNumber as _SerialNumber on _SerialNumber.CustomerReturn = $projection.CustomerReturn
and _SerialNumber.CustomerReturnItem = $projection.CustomerReturnItem
association [0..*] to A_CustomerReturnItemPartner as _Partner on _Partner.CustomerReturn = $projection.CustomerReturn
and _Partner.CustomerReturnItem = $projection.CustomerReturnItem
association [0..*] to A_CustomerReturnItemText as _Text on _Text.CustomerReturn = $projection.CustomerReturn
and _Text.CustomerReturnItem = $projection.CustomerReturnItem
association [0..*] to A_CustomerReturnItemRelatedObj as _RelatedObject on _RelatedObject.CustomerReturn = $projection.CustomerReturn
and _RelatedObject.CustomerReturnItem = $projection.CustomerReturnItem
association [0..*] to A_CustomerReturnItemPrcgElmnt as _PricingElement on _PricingElement.CustomerReturn = $projection.CustomerReturn
and _PricingElement.CustomerReturnItem = $projection.CustomerReturnItem
association [0..*] to A_CustomerReturnProcessStep as _ProcessStep on _ProcessStep.RetsMgmtProcess = $projection.RetsMgmtProcess
and _ProcessStep.RetsMgmtProcessItem = $projection.CustomerReturnItem
// RFM enhancement : value-added services
association [0..*] to A_CustomerReturnValAddedSrvc as _ValueAddedService on _ValueAddedService.CustomerReturn = $projection.CustomerReturn
and _ValueAddedService.CustomerReturnItem = $projection.CustomerReturnItem
//Extensibility
association [0..1] to E_SalesDocumentItemBasic as _Extension on $projection.CustomerReturn = _Extension.SalesDocument
and $projection.CustomerReturnItem = _Extension.SalesDocumentItem
{
@ObjectModel.readOnly: true
key CustomerReturn,
@ObjectModel.text.element: 'CustomerReturnItemText'
key CustomerReturnItem,
HigherLevelItem,
CustomerReturnItemCategory,
@Semantics.text: true
CustomerReturnItemText,
PurchaseOrderByCustomer,
Material,
MaterialByCustomer,
@Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
RequestedQuantity,
@Semantics.unitOfMeasure: true
RequestedQuantityUnit,
@ObjectModel.readOnly: true
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemGrossWeight,
@ObjectModel.readOnly: true
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemNetWeight,
@Semantics.unitOfMeasure: true
@ObjectModel.readOnly: true
ItemWeightUnit,
@Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
@ObjectModel.readOnly: true
ItemVolume,
@Semantics.unitOfMeasure: true
@ObjectModel.readOnly: true
ItemVolumeUnit,
@Semantics.currencyCode: true
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference: 'Currency'
TransactionCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
@ObjectModel.readOnly: true
NetAmount,
MaterialGroup,
@ObjectModel.readOnly: true
Batch,
@ObjectModel.sapObjectNodeTypeReference: 'Plant'
Plant as ProductionPlant,
@ObjectModel.sapObjectNodeTypeReference: 'StorageLocation'
StorageLocation,
@ObjectModel.sapObjectNodeTypeReference: 'ShippingPoint'
ShippingPoint,
ShippingType,
DeliveryPriority,
@ObjectModel.sapObjectNodeTypeReference: 'IncotermsClassification'
IncotermsClassification,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
CustomerPaymentTerms,
//Tax Classfication
ProductTaxClassification1,
ProductTaxClassification2,
ProductTaxClassification3,
ProductTaxClassification4,
ProductTaxClassification5,
ProductTaxClassification6,
ProductTaxClassification7,
ProductTaxClassification8,
ProductTaxClassification9,
@ObjectModel.sapObjectNodeTypeReference: 'SalesDocumentRjcnReason'
SalesDocumentRjcnReason,
@ObjectModel.sapObjectNodeTypeReference: 'BillingBlockReason'
ItemBillingBlockReason,
ProfitCenter,
@ObjectModel.readOnly: true
RetsMgmtProcess,
@ObjectModel.readOnly: true
RetsMgmtProcessItem,
ReturnReason,
RetsMgmtProcessingBlock,
CustRetItmFollowUpActivity,
ReturnsMaterialHasBeenReceived,
ReturnsRefundType,
ReturnsRefundProcgMode,
cast (RetsProdValnIsSuspended as abap.char(1)) as RetsProdValnIsSuspended,
ReturnsRefundExtent,
PrelimRefundIsDetermined,
@ObjectModel.readOnly: true
ReturnsRefundRjcnReason,
ReplacementMaterial,
@Semantics.quantity.unitOfMeasure: 'ReplacementMaterialQtyUnit'
ReplacementMaterialQuantity,
@Semantics.unitOfMeasure: true
ReplacementMaterialQtyUnit,
ReplacementMaterialIsRequested,
ReplacementMatlSupplyingPlant,
NextPlantForFollowUpActivity,
ReturnsTransshipmentPlant,
Supplier,
SupplierRetMatlAuthzn,
@ObjectModel.readOnly: true
SuplrRetMatlAuthznIsRequired,
CustomerRetMatlInspResultCode,
NextFllwUpActivityForMatlInsp,
RetMatlInspResultCode,
ProductIsInspectedAtCustSite,
@ObjectModel.readOnly: true
CustRetMatlAuthzn,
@ObjectModel.readOnly: true
CRMLogicalSystem,
@ObjectModel.readOnly: true
CRMObjectUUID,
@ObjectModel.readOnly: true
CRMObjectID,
@ObjectModel.readOnly: true
CRMObjectType,
@ObjectModel.readOnly: true
RetsMgmtItmLogProcgStatus,
@ObjectModel.readOnly: true
RetsMgmtItmCompnProcgStatus,
@ObjectModel.readOnly: true
RetsMgmtItmProcgStatus,
@ObjectModel.readOnly: true
ReturnsDocumentStatus,
@ObjectModel.readOnly: true
ReturnsDocumentApprovalStatus,
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference: 'SDProcessStatus'
SDProcessStatus,
ReferenceSDDocument,
ReferenceSDDocumentItem,
@ObjectModel.readOnly: true
ReferenceSDDocumentCategory,
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference: 'SalesDocRejectionStatus'
SDDocumentRejectionStatus,
// For Access control
@Consumption.hidden: true
SalesDocumentBasic.SalesDocumentType as CustomerReturnType,
@Consumption.hidden: true
SalesDocumentBasic.OrganizationDivision,
@Consumption.hidden: true
SalesDocumentBasic.SalesOrganization,
@Consumption.hidden: true
SalesDocumentBasic.DistributionChannel,
// Expose own associations
_CustomerReturn,
_ScheduleLine,
_SerialNumber,
_Partner,
_Text,
_RelatedObject,
_PricingElement,
_ProcessStep,
// RFM enhancement : value-added services
_ValueAddedService
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERRETURNITEMENHANCED",
"I_SALESDOCUMENTBASIC"
],
"ASSOCIATED":
[
"A_CUSTOMERRETURN",
"A_CUSTOMERRETURNITEMPARTNER",
"A_CUSTOMERRETURNITEMPRCGELMNT",
"A_CUSTOMERRETURNITEMRELATEDOBJ",
"A_CUSTOMERRETURNITEMTEXT",
"A_CUSTOMERRETURNPROCESSSTEP",
"A_CUSTOMERRETURNSCHEDULELINE",
"A_CUSTOMERRETURNSERIALNUMBER",
"A_CUSTOMERRETURNVALADDEDSRVC",
"E_SALESDOCUMENTITEMBASIC",
"I_SALESDOCUMENTBASIC"
],
"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