A_CreditMemoReqItemSimulation

DDL: A_CREDITMEMOREQITEMSIMULATION Type: view_entity COMPOSITE

Credit Memo Request Item Simulation

A_CreditMemoReqItemSimulation is a Composite CDS View that provides data about "Credit Memo Request Item Simulation" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, I_CreditMemoRequestItem) and exposes 66 fields with key fields CreditMemoRequest, CreditMemoRequestItem. It has 3 associations to related views.

2 data source(s) 66 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic CreditMemoRequest inner
I_CreditMemoRequestItem CreditMemoRequestItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_SalesDocumentItemBasic _Extension $projection.CreditMemoRequest = _Extension.SalesDocument and $projection.CreditMemoRequestItem = _Extension.SalesDocumentItem
[0..*] A_CrdtMemoReqItemPartnerSimln _Partner
[0..*] A_CrdtMemoReqItmPrcgElmntSimln _PricingElement

Annotations (8)

NameValueLevelField
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 Credit Memo Request Item Simulation view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY CreditMemoRequest I_CreditMemoRequestItem CreditMemoRequest
KEY CreditMemoRequestItem I_CreditMemoRequestItem CreditMemoRequestItem
HigherLevelItem I_CreditMemoRequestItem HigherLevelItem
CreditMemoRequestItemCategory I_CreditMemoRequestItem CreditMemoRequestItemCategory
CreditMemoRequestItemText I_CreditMemoRequestItem CreditMemoRequestItemText
PurchaseOrderByCustomer I_CreditMemoRequestItem PurchaseOrderByCustomer
Material I_CreditMemoRequestItem Material
MaterialByCustomer I_CreditMemoRequestItem MaterialByCustomer
PricingDate I_CreditMemoRequestItem PricingDate
RequestedQuantity I_CreditMemoRequestItem RequestedQuantity
RequestedQuantityUnit I_CreditMemoRequestItem RequestedQuantityUnit
RequestedQuantitySAPUnit
RequestedQuantityISOUnit
ItemGrossWeight I_CreditMemoRequestItem ItemGrossWeight
ItemNetWeight I_CreditMemoRequestItem ItemNetWeight
ItemWeightUnit I_CreditMemoRequestItem ItemWeightUnit
ItemWeightSAPUnit
ItemWeightISOUnit
ItemVolume I_CreditMemoRequestItem ItemVolume
ItemVolumeUnit I_CreditMemoRequestItem ItemVolumeUnit
ItemVolumeSAPUnit
ItemVolumeISOUnit
TransactionCurrency I_CreditMemoRequestItem TransactionCurrency
NetAmount I_CreditMemoRequestItem NetAmount
MaterialGroup I_CreditMemoRequestItem MaterialGroup
AdditionalMaterialGroup1 I_CreditMemoRequestItem AdditionalMaterialGroup1
AdditionalMaterialGroup2 I_CreditMemoRequestItem AdditionalMaterialGroup2
AdditionalMaterialGroup3 I_CreditMemoRequestItem AdditionalMaterialGroup3
AdditionalMaterialGroup4 I_CreditMemoRequestItem AdditionalMaterialGroup4
AdditionalMaterialGroup5 I_CreditMemoRequestItem AdditionalMaterialGroup5
Subtotal1Amount I_CreditMemoRequestItem Subtotal1Amount
Subtotal2Amount I_CreditMemoRequestItem Subtotal2Amount
Subtotal3Amount I_CreditMemoRequestItem Subtotal3Amount
Subtotal4Amount I_CreditMemoRequestItem Subtotal4Amount
Subtotal5Amount I_CreditMemoRequestItem Subtotal5Amount
Subtotal6Amount I_CreditMemoRequestItem Subtotal6Amount
TaxAmount I_CreditMemoRequestItem TaxAmount
MaterialPricingGroup I_CreditMemoRequestItem MaterialPricingGroup
ProductTaxClassification1 I_CreditMemoRequestItem ProductTaxClassification1
ProductTaxClassification2 I_CreditMemoRequestItem ProductTaxClassification2
ProductTaxClassification3 I_CreditMemoRequestItem ProductTaxClassification3
ProductTaxClassification4 I_CreditMemoRequestItem ProductTaxClassification4
ProductTaxClassification5 I_CreditMemoRequestItem ProductTaxClassification5
ProductTaxClassification6 I_CreditMemoRequestItem ProductTaxClassification6
ProductTaxClassification7 I_CreditMemoRequestItem ProductTaxClassification7
ProductTaxClassification8 I_CreditMemoRequestItem ProductTaxClassification8
ProductTaxClassification9 I_CreditMemoRequestItem ProductTaxClassification9
MatlAccountAssignmentGroup I_CreditMemoRequestItem MatlAccountAssignmentGroup
Batch I_CreditMemoRequestItem Batch
IncotermsClassification I_CreditMemoRequestItem IncotermsClassification
IncotermsTransferLocation I_CreditMemoRequestItem IncotermsTransferLocation
IncotermsLocation1 I_CreditMemoRequestItem IncotermsLocation1
IncotermsLocation2 I_CreditMemoRequestItem IncotermsLocation2
ItemBillingBlockReason I_CreditMemoRequestItem ItemBillingBlockReason
SalesDocumentRjcnReason I_CreditMemoRequestItem SalesDocumentRjcnReason
ProfitCenter I_CreditMemoRequestItem ProfitCenter
ReferenceSDDocument I_CreditMemoRequestItem ReferenceSDDocument
ReferenceSDDocumentItem I_CreditMemoRequestItem ReferenceSDDocumentItem
CreditMemoRequestType I_SalesDocumentBasic SalesDocumentType
OrganizationDivision I_SalesDocumentBasic OrganizationDivision
SalesOrganization I_SalesDocumentBasic SalesOrganization
DistributionChannel I_SalesDocumentBasic DistributionChannel
ServicesRenderedDate I_CreditMemoRequestItem ServicesRenderedDate
_CreditMemoRequest _CreditMemoRequest
_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: 'Credit Memo Request Item Simulation'
define view entity A_CreditMemoReqItemSimulation
  as select from I_CreditMemoRequestItem as CreditMemoRequestItem
  inner join   I_SalesDocumentBasic as CreditMemoRequest on  CreditMemoRequest.SalesDocument      = CreditMemoRequestItem.CreditMemoRequest // needed for DCL

                                                           and CreditMemoRequest.SDDocumentCategory = 'K'
  association        to parent A_CreditMemoRequestSimulation as _CreditMemoRequest on $projection.CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest
  composition [0..*] of A_CrdtMemoReqItemPartnerSimln        as _Partner
  composition [0..*] of A_CrdtMemoReqItmPrcgElmntSimln       as _PricingElement
  association [0..1] to E_SalesDocumentItemBasic             as _Extension       on  $projection.CreditMemoRequest       = _Extension.SalesDocument
                                                                                 and $projection.CreditMemoRequestItem   = _Extension.SalesDocumentItem
{
       @ObjectModel.readOnly: true
  key  CreditMemoRequestItem.CreditMemoRequest,

       @ObjectModel.text.element: ['CreditMemoRequestItemText']
  key  CreditMemoRequestItem.CreditMemoRequestItem,

       CreditMemoRequestItem.HigherLevelItem,

       CreditMemoRequestItem.CreditMemoRequestItemCategory,

       @Semantics.text: true
       CreditMemoRequestItem.CreditMemoRequestItemText,

       CreditMemoRequestItem.PurchaseOrderByCustomer,

       CreditMemoRequestItem.Material,
       CreditMemoRequestItem.MaterialByCustomer,

       CreditMemoRequestItem.PricingDate,

       @Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
       @Semantics.quantity.unitOfMeasureSapCode: 'RequestedQuantitySAPUnit'
       @Semantics.quantity.unitOfMeasureIsoCode: 'RequestedQuantityISOUnit'
       CreditMemoRequestItem.RequestedQuantity,


       CreditMemoRequestItem.RequestedQuantityUnit,
       cast(CreditMemoRequestItem._RequestedQuantityUnit.UnitOfMeasureSAPCode as sd_reqd_qty_sapunit preserving type) as RequestedQuantitySAPUnit,
       cast(CreditMemoRequestItem._RequestedQuantityUnit.UnitOfMeasureISOCode as sd_reqd_qty_isounit preserving type) as RequestedQuantityISOUnit,

       @ObjectModel.readOnly: true
       @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
       @Semantics.quantity.unitOfMeasureSapCode: 'ItemWeightSAPUnit'
       @Semantics.quantity.unitOfMeasureIsoCode: 'ItemWeightISOUnit'
       CreditMemoRequestItem.ItemGrossWeight,

       @ObjectModel.readOnly: true
       @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
       @Semantics.quantity.unitOfMeasureSapCode: 'ItemWeightSAPUnit'
       @Semantics.quantity.unitOfMeasureIsoCode: 'ItemWeightISOUnit'
       CreditMemoRequestItem.ItemNetWeight,


       @ObjectModel.readOnly: true
       CreditMemoRequestItem.ItemWeightUnit,
       @ObjectModel.readOnly: true
       cast(CreditMemoRequestItem._ItemWeightUnit.UnitOfMeasureSAPCode as sd_itm_wgt_sapunit preserving type)         as ItemWeightSAPUnit,
       @ObjectModel.readOnly: true
       cast(CreditMemoRequestItem._ItemWeightUnit.UnitOfMeasureISOCode as sd_itm_wgt_isounit preserving type)         as ItemWeightISOUnit,

       @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
       @Semantics.quantity.unitOfMeasureSapCode: 'ItemVolumeSAPUnit'
       @Semantics.quantity.unitOfMeasureIsoCode: 'ItemVolumeISOUnit'
       @ObjectModel.readOnly: true
       CreditMemoRequestItem.ItemVolume,

       @ObjectModel.readOnly: true
       CreditMemoRequestItem.ItemVolumeUnit,
       @ObjectModel.readOnly: true
       cast(CreditMemoRequestItem._ItemVolumeUnit.UnitOfMeasureSAPCode as sd_itm_vol_sapunit preserving type)         as ItemVolumeSAPUnit,
       @ObjectModel.readOnly: true
       cast(CreditMemoRequestItem._ItemVolumeUnit.UnitOfMeasureISOCode as sd_itm_vol_isounit preserving type)         as ItemVolumeISOUnit,


       @ObjectModel.sapObjectNodeTypeReference: 'Currency'
       @ObjectModel.readOnly: true
       CreditMemoRequestItem.TransactionCurrency,

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

       CreditMemoRequestItem.MaterialGroup,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup1'
       CreditMemoRequestItem.AdditionalMaterialGroup1,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup2'
       CreditMemoRequestItem.AdditionalMaterialGroup2,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup3'
       CreditMemoRequestItem.AdditionalMaterialGroup3,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup4'
       CreditMemoRequestItem.AdditionalMaterialGroup4,
       @ObjectModel.readOnly: true
       @ObjectModel.sapObjectNodeTypeReference: 'AdditionalProductGroup5'
       CreditMemoRequestItem.AdditionalMaterialGroup5,
       
       @ObjectModel.readOnly: true   
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CreditMemoRequestItem.Subtotal1Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CreditMemoRequestItem.Subtotal2Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CreditMemoRequestItem.Subtotal3Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CreditMemoRequestItem.Subtotal4Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CreditMemoRequestItem.Subtotal5Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CreditMemoRequestItem.Subtotal6Amount,
       @ObjectModel.readOnly: true
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       CreditMemoRequestItem.TaxAmount,
       
       @ObjectModel.sapObjectNodeTypeReference: 'MaterialPricingGroup'
       CreditMemoRequestItem.MaterialPricingGroup,
       CreditMemoRequestItem.ProductTaxClassification1,
       CreditMemoRequestItem.ProductTaxClassification2,
       CreditMemoRequestItem.ProductTaxClassification3,
       CreditMemoRequestItem.ProductTaxClassification4,
       CreditMemoRequestItem.ProductTaxClassification5,
       CreditMemoRequestItem.ProductTaxClassification6,
       CreditMemoRequestItem.ProductTaxClassification7,
       CreditMemoRequestItem.ProductTaxClassification8,
       CreditMemoRequestItem.ProductTaxClassification9,
       CreditMemoRequestItem.MatlAccountAssignmentGroup,
       @ObjectModel.readOnly: true
       CreditMemoRequestItem.Batch,

       @ObjectModel.sapObjectNodeTypeReference: 'IncotermsClassification'
       CreditMemoRequestItem.IncotermsClassification,
       CreditMemoRequestItem.IncotermsTransferLocation,
       CreditMemoRequestItem.IncotermsLocation1,
       CreditMemoRequestItem.IncotermsLocation2,


       @ObjectModel.sapObjectNodeTypeReference: 'BillingBlockReason'
       CreditMemoRequestItem.ItemBillingBlockReason,
       @ObjectModel.sapObjectNodeTypeReference: 'SalesDocumentRjcnReason'
       CreditMemoRequestItem.SalesDocumentRjcnReason,

       //       WBSElement,

       CreditMemoRequestItem.ProfitCenter,

       CreditMemoRequestItem.ReferenceSDDocument,
       CreditMemoRequestItem.ReferenceSDDocumentItem,

       // For Access control

       @Consumption.hidden: true
       CreditMemoRequest.SalesDocumentType                                                     as CreditMemoRequestType,
       @Consumption.hidden: true
       CreditMemoRequest.OrganizationDivision,
       @Consumption.hidden: true
       CreditMemoRequest.SalesOrganization,
       @Consumption.hidden: true
       CreditMemoRequest.DistributionChannel,

       CreditMemoRequestItem.ServicesRenderedDate,

       // Expose own associations

       _CreditMemoRequest,
       _Partner,
       _PricingElement
}
where
  CreditMemoRequestItem.CreditMemoRequest = '0'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CREDITMEMOREQUESTITEM",
"I_SALESDOCUMENTBASIC",
"I_UNITOFMEASURE"
],
"ASSOCIATED":
[
"A_CRDTMEMOREQITEMPARTNERSIMLN",
"A_CRDTMEMOREQITMPRCGELMNTSIMLN",
"A_CREDITMEMOREQUESTSIMULATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More