Which tables does A_CustomerReturnItemSimulation use?

A_CustomerReturnItemSimulation reads from 2 data source(s): I_CustomerReturnItemEnhanced, I_SalesDocumentBasic.

How many fields does A_CustomerReturnItemSimulation have?

A_CustomerReturnItemSimulation has 85 fields. Key fields: CustomerReturn, CustomerReturnItem.

A_CustomerReturnItemSimulation

DDL: A_CUSTOMERRETURNITEMSIMULATION Type: view_entity COMPOSITE

Returns Order Item Simulation

A_CustomerReturnItemSimulation is a Composite CDS View that provides data about "Returns Order Item Simulation" in SAP S/4HANA. It reads from 2 data sources (I_CustomerReturnItemEnhanced, I_SalesDocumentBasic) and exposes 85 fields with key fields CustomerReturn, CustomerReturnItem. It has 3 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_CustomerReturnItemEnhanced	CustomerReturnItem	from
I_SalesDocumentBasic	SalesDocumentBasic	inner

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	E_SalesDocumentItemBasic	_Extension	`$projection.CustomerReturn = _Extension.SalesDocument and $projection.CustomerReturnItem = _Extension.SalesDocumentItem`
[0..*]	A_CustRetItemPartnerSimulation	_Partner
[0..*]	A_CustRetItemPrcgElmntSimln	_PricingElement

Annotations (8)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Returns Order Item Simulation	view

Fields (85)

Key	Field	Source Table	Source Field
KEY	CustomerReturn	I_CustomerReturnItemEnhanced	CustomerReturn
KEY	CustomerReturnItem	I_CustomerReturnItemEnhanced	CustomerReturnItem
	HigherLevelItem	I_CustomerReturnItemEnhanced	HigherLevelItem
	CustomerReturnItemCategory	I_CustomerReturnItemEnhanced	CustomerReturnItemCategory
	CustomerReturnItemText	I_CustomerReturnItemEnhanced	CustomerReturnItemText
	PurchaseOrderByCustomer	I_CustomerReturnItemEnhanced	PurchaseOrderByCustomer
	Material	I_CustomerReturnItemEnhanced	Material
	MaterialByCustomer	I_CustomerReturnItemEnhanced	MaterialByCustomer
	RequestedQuantity	I_CustomerReturnItemEnhanced	RequestedQuantity
	RequestedQuantityUnit	I_CustomerReturnItemEnhanced	RequestedQuantityUnit
	ItemGrossWeight	I_CustomerReturnItemEnhanced	ItemGrossWeight
	ItemNetWeight	I_CustomerReturnItemEnhanced	ItemNetWeight
	ItemWeightUnit	I_CustomerReturnItemEnhanced	ItemWeightUnit
	ItemVolume	I_CustomerReturnItemEnhanced	ItemVolume
	ItemVolumeUnit	I_CustomerReturnItemEnhanced	ItemVolumeUnit
	TransactionCurrency	I_CustomerReturnItemEnhanced	TransactionCurrency
	NetAmount	I_CustomerReturnItemEnhanced	NetAmount
	MaterialGroup	I_CustomerReturnItemEnhanced	MaterialGroup
	AdditionalMaterialGroup1	I_CustomerReturnItemEnhanced	AdditionalMaterialGroup1
	AdditionalMaterialGroup2	I_CustomerReturnItemEnhanced	AdditionalMaterialGroup2
	AdditionalMaterialGroup3	I_CustomerReturnItemEnhanced	AdditionalMaterialGroup3
	AdditionalMaterialGroup4	I_CustomerReturnItemEnhanced	AdditionalMaterialGroup4
	AdditionalMaterialGroup5	I_CustomerReturnItemEnhanced	AdditionalMaterialGroup5
	Subtotal1Amount	I_CustomerReturnItemEnhanced	Subtotal1Amount
	Subtotal2Amount	I_CustomerReturnItemEnhanced	Subtotal2Amount
	Subtotal3Amount	I_CustomerReturnItemEnhanced	Subtotal3Amount
	Subtotal4Amount	I_CustomerReturnItemEnhanced	Subtotal4Amount
	Subtotal5Amount	I_CustomerReturnItemEnhanced	Subtotal5Amount
	Subtotal6Amount	I_CustomerReturnItemEnhanced	Subtotal6Amount
	TaxAmount	I_CustomerReturnItemEnhanced	TaxAmount
	Batch	I_CustomerReturnItemEnhanced	Batch
	ProductionPlant	I_CustomerReturnItemEnhanced	Plant
	StorageLocation	I_CustomerReturnItemEnhanced	StorageLocation
	ShippingPoint	I_CustomerReturnItemEnhanced	ShippingPoint
	ShippingType	I_CustomerReturnItemEnhanced	ShippingType
	DeliveryPriority	I_CustomerReturnItemEnhanced	DeliveryPriority
	IncotermsClassification	I_CustomerReturnItemEnhanced	IncotermsClassification
	IncotermsTransferLocation	I_CustomerReturnItemEnhanced	IncotermsTransferLocation
	IncotermsLocation1	I_CustomerReturnItemEnhanced	IncotermsLocation1
	IncotermsLocation2	I_CustomerReturnItemEnhanced	IncotermsLocation2
	CustomerPaymentTerms	I_CustomerReturnItemEnhanced	CustomerPaymentTerms
	ProductTaxClassification1	I_CustomerReturnItemEnhanced	ProductTaxClassification1
	ProductTaxClassification2	I_CustomerReturnItemEnhanced	ProductTaxClassification2
	ProductTaxClassification3	I_CustomerReturnItemEnhanced	ProductTaxClassification3
	ProductTaxClassification4	I_CustomerReturnItemEnhanced	ProductTaxClassification4
	ProductTaxClassification5	I_CustomerReturnItemEnhanced	ProductTaxClassification5
	ProductTaxClassification6	I_CustomerReturnItemEnhanced	ProductTaxClassification6
	ProductTaxClassification7	I_CustomerReturnItemEnhanced	ProductTaxClassification7
	ProductTaxClassification8	I_CustomerReturnItemEnhanced	ProductTaxClassification8
	ProductTaxClassification9	I_CustomerReturnItemEnhanced	ProductTaxClassification9
	SalesDocumentRjcnReason	I_CustomerReturnItemEnhanced	SalesDocumentRjcnReason
	ProfitCenter	I_CustomerReturnItemEnhanced	ProfitCenter
	ReturnReason	I_CustomerReturnItemEnhanced	ReturnReason
	RetsMgmtProcessingBlock	I_CustomerReturnItemEnhanced	RetsMgmtProcessingBlock
	CustRetItmFollowUpActivity	I_CustomerReturnItemEnhanced	CustRetItmFollowUpActivity
	ReturnsMaterialHasBeenReceived	I_CustomerReturnItemEnhanced	ReturnsMaterialHasBeenReceived
	ReturnsRefundType	I_CustomerReturnItemEnhanced	ReturnsRefundType
	ReturnsRefundProcgMode	I_CustomerReturnItemEnhanced	ReturnsRefundProcgMode
	ReturnsRefundExtent	I_CustomerReturnItemEnhanced	ReturnsRefundExtent
	PrelimRefundIsDetermined	I_CustomerReturnItemEnhanced	PrelimRefundIsDetermined
	ReturnsRefundRjcnReason	I_CustomerReturnItemEnhanced	ReturnsRefundRjcnReason
	ReplacementMaterial	I_CustomerReturnItemEnhanced	ReplacementMaterial
	ReplacementMaterialQuantity	I_CustomerReturnItemEnhanced	ReplacementMaterialQuantity
	ReplacementMaterialQtyUnit	I_CustomerReturnItemEnhanced	ReplacementMaterialQtyUnit
	ReplacementMaterialIsRequested	I_CustomerReturnItemEnhanced	ReplacementMaterialIsRequested
	ReplacementMatlSupplyingPlant	I_CustomerReturnItemEnhanced	ReplacementMatlSupplyingPlant
	NextPlantForFollowUpActivity	I_CustomerReturnItemEnhanced	NextPlantForFollowUpActivity
	ReturnsTransshipmentPlant	I_CustomerReturnItemEnhanced	ReturnsTransshipmentPlant
	Supplier	I_CustomerReturnItemEnhanced	Supplier
	SupplierRetMatlAuthzn	I_CustomerReturnItemEnhanced	SupplierRetMatlAuthzn
	SuplrRetMatlAuthznIsRequired	I_CustomerReturnItemEnhanced	SuplrRetMatlAuthznIsRequired
	CustomerRetMatlInspResultCode	I_CustomerReturnItemEnhanced	CustomerRetMatlInspResultCode
	NextFllwUpActivityForMatlInsp	I_CustomerReturnItemEnhanced	NextFllwUpActivityForMatlInsp
	RetMatlInspResultCode	I_CustomerReturnItemEnhanced	RetMatlInspResultCode
	ProductIsInspectedAtCustSite	I_CustomerReturnItemEnhanced	ProductIsInspectedAtCustSite
	CustRetMatlAuthzn	I_CustomerReturnItemEnhanced	CustRetMatlAuthzn
	ReferenceSDDocument	I_CustomerReturnItemEnhanced	ReferenceSDDocument
	ReferenceSDDocumentItem	I_CustomerReturnItemEnhanced	ReferenceSDDocumentItem
	CustomerReturnType	I_SalesDocumentBasic	SalesDocumentType
	OrganizationDivision	I_SalesDocumentBasic	OrganizationDivision
	SalesOrganization	I_SalesDocumentBasic	SalesOrganization
	DistributionChannel	I_SalesDocumentBasic	DistributionChannel
	_CustomerReturn		_CustomerReturn
	_Partner		_Partner
	_PricingElement		_PricingElement

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Returns Order Item Simulation'
define view entity A_CustomerReturnItemSimulation as select from I_CustomerReturnItemEnhanced as CustomerReturnItem
inner join I_SalesDocumentBasic           as SalesDocumentBasic on  SalesDocumentBasic.SalesDocument = CustomerReturnItem.CustomerReturn
                                          and SalesDocumentBasic.SDDocumentCategory          = 'H'
association to parent A_CustomerReturnSimulation     as _CustomerReturn on $projection.CustomerReturn = _CustomerReturn.CustomerReturn 

composition [0..*] of A_CustRetItemPartnerSimulation as _Partner
                                                                          
composition [0..*] of A_CustRetItemPrcgElmntSimln    as _PricingElement
                                                                          
//Extensibility

  association [0..1] to E_SalesDocumentItemBasic      as _Extension       on  $projection.CustomerReturn       = _Extension.SalesDocument
                                                                          and $projection.CustomerReturnItem   = _Extension.SalesDocumentItem
{

       @ObjectModel.readOnly: true
  key  CustomerReturnItem.CustomerReturn,

       @ObjectModel.text.element: ['CustomerReturnItemText']
  key  CustomerReturnItem.CustomerReturnItem,

       CustomerReturnItem.HigherLevelItem,

       CustomerReturnItem.CustomerReturnItemCategory,

       @Semantics.text: true
       CustomerReturnItem.CustomerReturnItemText,

       CustomerReturnItem.PurchaseOrderByCustomer,

       CustomerReturnItem.Material,

       CustomerReturnItem.MaterialByCustomer,

       @Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
       CustomerReturnItem.RequestedQuantity,
       CustomerReturnItem.RequestedQuantityUnit,

       @ObjectModel.readOnly: true
       @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
       CustomerReturnItem.ItemGrossWeight,

       @ObjectModel.readOnly: true
       @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
       CustomerReturnItem.ItemNetWeight,
       @ObjectModel.readOnly: true
       CustomerReturnItem.ItemWeightUnit,

       @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
       @ObjectModel.readOnly: true
       CustomerReturnItem.ItemVolume,
       @ObjectModel.readOnly: true
       CustomerReturnItem.ItemVolumeUnit,

       @ObjectModel.readOnly: true
       CustomerReturnItem.TransactionCurrency,

       @Semantics.amount.currencyCode: 'TransactionCurrency'
       @ObjectModel.readOnly: true
       CustomerReturnItem.NetAmount,

       CustomerReturnItem.MaterialGroup,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup1'
       CustomerReturnItem.AdditionalMaterialGroup1,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup2'
       CustomerReturnItem.AdditionalMaterialGroup2,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup3'
       CustomerReturnItem.AdditionalMaterialGroup3,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup4'
       CustomerReturnItem.AdditionalMaterialGroup4,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup5'
       CustomerReturnItem.AdditionalMaterialGroup5,
       
       @ObjectModel.readOnly: true   
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CustomerReturnItem.Subtotal1Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CustomerReturnItem.Subtotal2Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CustomerReturnItem.Subtotal3Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CustomerReturnItem.Subtotal4Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CustomerReturnItem.Subtotal5Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CustomerReturnItem.Subtotal6Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CustomerReturnItem.TaxAmount,
       
       
       CustomerReturnItem.Batch,
       @ObjectModel.sapObjectNodeTypeReference: 'Plant'
       CustomerReturnItem.Plant                                as ProductionPlant,
       @ObjectModel.sapObjectNodeTypeReference: 'StorageLocation'
       CustomerReturnItem.StorageLocation,
       @ObjectModel.sapObjectNodeTypeReference: 'ShippingPoint'
       CustomerReturnItem.ShippingPoint,
       CustomerReturnItem.ShippingType,
       CustomerReturnItem.DeliveryPriority,

       @ObjectModel.sapObjectNodeTypeReference: 'IncotermsClassification'
       CustomerReturnItem.IncotermsClassification,
       CustomerReturnItem.IncotermsTransferLocation,
       CustomerReturnItem.IncotermsLocation1,
       CustomerReturnItem.IncotermsLocation2,
       CustomerReturnItem.CustomerPaymentTerms,

      //Tax Classfication

       CustomerReturnItem.ProductTaxClassification1,
       CustomerReturnItem.ProductTaxClassification2,
       CustomerReturnItem.ProductTaxClassification3,
       CustomerReturnItem.ProductTaxClassification4,
       CustomerReturnItem.ProductTaxClassification5,
       CustomerReturnItem.ProductTaxClassification6,
       CustomerReturnItem.ProductTaxClassification7,
       CustomerReturnItem.ProductTaxClassification8,
       CustomerReturnItem.ProductTaxClassification9,
       
       @ObjectModel.sapObjectNodeTypeReference: 'SalesDocumentRjcnReason'
       CustomerReturnItem.SalesDocumentRjcnReason,
       
       CustomerReturnItem.ProfitCenter,
       
       CustomerReturnItem.ReturnReason,
       CustomerReturnItem.RetsMgmtProcessingBlock,
       CustomerReturnItem.CustRetItmFollowUpActivity,
       CustomerReturnItem.ReturnsMaterialHasBeenReceived,

       CustomerReturnItem.ReturnsRefundType,
       CustomerReturnItem.ReturnsRefundProcgMode,
       
       CustomerReturnItem.ReturnsRefundExtent,
       CustomerReturnItem.PrelimRefundIsDetermined,
       CustomerReturnItem.ReturnsRefundRjcnReason,

       CustomerReturnItem.ReplacementMaterial,

       @Semantics.quantity.unitOfMeasure: 'ReplacementMaterialQtyUnit'
       CustomerReturnItem.ReplacementMaterialQuantity,
       CustomerReturnItem.ReplacementMaterialQtyUnit,

       CustomerReturnItem.ReplacementMaterialIsRequested,
       CustomerReturnItem.ReplacementMatlSupplyingPlant,

       CustomerReturnItem.NextPlantForFollowUpActivity,
       CustomerReturnItem.ReturnsTransshipmentPlant,
       CustomerReturnItem.Supplier,
       CustomerReturnItem.SupplierRetMatlAuthzn,
       @ObjectModel.readOnly: true
       CustomerReturnItem.SuplrRetMatlAuthznIsRequired,

       CustomerReturnItem.CustomerRetMatlInspResultCode,
       CustomerReturnItem.NextFllwUpActivityForMatlInsp,
       CustomerReturnItem.RetMatlInspResultCode,
       CustomerReturnItem.ProductIsInspectedAtCustSite,
       @ObjectModel.readOnly: true
       CustomerReturnItem.CustRetMatlAuthzn,
       

       CustomerReturnItem.ReferenceSDDocument,
       CustomerReturnItem.ReferenceSDDocumentItem,

       // 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,
       _Partner,
       _PricingElement
}where CustomerReturnItem.CustomerReturn = '0'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERRETURNITEMENHANCED",
"I_SALESDOCUMENTBASIC"
],
"ASSOCIATED":
[
"A_CUSTOMERRETURNSIMULATION",
"A_CUSTRETITEMPARTNERSIMULATION",
"A_CUSTRETITEMPRCGELMNTSIMLN"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

A_CustomerReturnItemSimulation view_entity

I_CustomerReturnItemEnhanced view
I_SalesDocumentBasic view