I_RetsMgmtInspExec

DDL: I_RETSMGMTINSPEXEC Type: view_entity COMPOSITE

Returns Inspection Executed

I_RetsMgmtInspExec is a Composite CDS View that provides data about "Returns Inspection Executed" in SAP S/4HANA. It reads from 1 data source (I_AdvncdRetsMgmtProcExecuted) and exposes 10 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem, RetsMgmtProcItmQtySplit, ReturnsDocumentType, RetsMgmtProcessStep. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_AdvncdRetsMgmtProcExecuted AdvncdRetsMgmtProcExecuted from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ReturnsInspectionItem _ReturnsInspectionItem $projection.RetsMgmtProcess = _ReturnsInspectionItem.RetsMgmtProcess and $projection.ReturnsDocument = _ReturnsInspectionItem.ReturnsInspection

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Returns Inspection Executed view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess RetsMgmtProcess
KEY RetsMgmtProcessItem RetsMgmtProcessItem
KEY RetsMgmtProcItmQtySplit RetsMgmtProcItmQtySplit
KEY ReturnsDocumentType ReturnsDocumentType
KEY RetsMgmtProcessStep RetsMgmtProcessStep
ReturnsDocument ReturnsDocument
TargetPlant TargetPlant
TargetStorageLocation TargetStorageLocation
TargetStockType TargetStockType
_ReturnsInspectionItem _ReturnsInspectionItem 
@VDM.viewType: #COMPOSITE //#BASIC

@ObjectModel.usageType:
{serviceQuality: #B,dataClass: #TRANSACTIONAL,sizeCategory: #L}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Returns Inspection Executed'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@Metadata.ignorePropagatedAnnotations: true
define view entity I_RetsMgmtInspExec
  as select from I_AdvncdRetsMgmtProcExecuted as AdvncdRetsMgmtProcExecuted
 association [1..*] to I_ReturnsInspectionItem as _ReturnsInspectionItem on  $projection.RetsMgmtProcess = _ReturnsInspectionItem.RetsMgmtProcess
                                                               and $projection.ReturnsDocument = _ReturnsInspectionItem.ReturnsInspection
{

  key    RetsMgmtProcess,
  key    RetsMgmtProcessItem,
  key    RetsMgmtProcItmQtySplit,
  key    ReturnsDocumentType,
  key    RetsMgmtProcessStep,
         ReturnsDocument,       
         TargetPlant,
         TargetStorageLocation,
         TargetStockType,
    _ReturnsInspectionItem
}
where
      RetsMgmtProcessStep = '0041'
  and ReturnsDocumentType         = '05'
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADVNCDRETSMGMTPROCEXECUTED"
],
"ASSOCIATED":
[
"I_RETURNSINSPECTIONITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More