A_CustomerReturnItem

DDL: A_CUSTOMERRETURNITEM Type: view COMPOSITE

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)

SourceAliasJoin Type
I_CustomerReturnItemEnhanced Item from

Associations (11)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/