I_ADVNCDRETSMGMTPROCEXECUTED
Advanced Returns Mgmt Process Executed
I_ADVNCDRETSMGMTPROCEXECUTED is a CDS View in S/4HANA. Advanced Returns Mgmt Process Executed. It contains 38 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AdvncdRetsMgmtProcExecStatus | view | left_outer | COMPOSITE | ARM Process Execution Status |
| I_AdvncdReturnsMgmtProcessStep | view | from | COMPOSITE | Advanced Returns Management Process Step |
| I_RetsMgmtInspExec | view_entity | from | COMPOSITE | Returns Inspection Executed |
| P_AdvncdReturnsMgmtProcessStep | view | from | CONSUMPTION | |
| P_CustRetProcFlow05 | view | inner | CONSUMPTION | |
| P_CustRetProcFlow06 | view | inner | CONSUMPTION | |
| P_CustRetProcFlow13 | view | inner | CONSUMPTION | |
| P_RefundedQuantity | view | union | CONSUMPTION |
Fields (38)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | RetsMgmtProcess | RetsMgmtProcess | 2 |
| KEY | RetsMgmtProcessItem | CustomerReturnItem,RetsMgmtProcessItem | 4 |
| KEY | RetsMgmtProcessStep | RetsMgmtProcessStep | 4 |
| KEY | RetsMgmtProcItmQtySplit | RetsMgmtProcItmQtySplit | 4 |
| KEY | ReturnsDocument | Level1Document,ReturnsDocument,SalesDocument | 5 |
| KEY | ReturnsDocumentItem | ReturnsDocumentItem | 1 |
| KEY | ReturnsDocumentType | Level1DocumentCategory,ReturnsDocumentType | 4 |
| KEY | ReturnsReferenceDocument | ReturnsReferenceDocument | 2 |
| KEY | ReturnsReferenceDocumentItem | ReturnsReferenceDocumentItem | 2 |
| KEY | ReturnsReferenceDocumentType | ReturnsReferenceDocumentType | 2 |
| _Address | _Address | 1 | |
| _AdvncdRetsMgmtProcess | _AdvncdRetsMgmtProcess | 1 | |
| _AdvncdRetsMgmtProcessItem | _AdvncdRetsMgmtProcessItem | 1 | |
| _DfltAddrRprstn | _DfltAddrRprstn | 1 | |
| _ReplacementMaterialQtyUnit | _ReplacementMaterialQtyUnit | 1 | |
| _RetMatlInspResultCode | _RetMatlInspResultCode | 1 | |
| _ReturnsReferenceDocumentType | _ReturnsReferenceDocumentType | 1 | |
| _ReturnsRefundProcgMode | _ReturnsRefundProcgMode | 1 | |
| _ReturnsRefundType | _ReturnsRefundType | 1 | |
| _Supplier | _Supplier | 1 | |
| AddressID | AddressID | 1 | |
| CustRetItmChainID | CustRetItmChainID | 1 | |
| PrelimRefundIsDetermined | PrelimRefundIsDetermined | 1 | |
| ReplacedMaterialQuantity | RefundedQuantityInBaseUnit | 1 | |
| ReplacementMaterial | ReplacementMaterial | 2 | |
| ReplacementMaterialIsRequested | ReplacementMaterialIsRequested | 1 | |
| ReplacementMaterialQtyUnit | ReplacementMaterialQtyUnit | 2 | |
| ReplacementMaterialQuantity | ReplacementMaterialQuantity | 2 | |
| ReplacementMatlSupplyingPlant | ReplacementMatlSupplyingPlant | 2 | |
| RetMatlInspResultCode | RetMatlInspResultCode | 1 | |
| RetsMgmtProcItmExectdSequence | RetsMgmtProcItmExectdSequence | 1 | |
| ReturnsDocumentApprovalStatus | ReturnsDocumentApprovalStatus | 1 | |
| ReturnsDocumentStatus | ReturnsDocumentStatus | 1 | |
| ReturnsRefundProcgMode | ReturnsRefundProcgMode | 2 | |
| ReturnsRefundType | ReturnsRefundType | 2 | |
| SuplrRetMatlAuthznIsRequired | SuplrRetMatlAuthznIsRequired | 1 | |
| Supplier | Supplier | 1 | |
| SupplierRetMatlAuthzn | SupplierRetMatlAuthzn | 1 |
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Advanced Returns Mgmt Process Executed'
@VDM.viewType: #BASIC
@Analytics.dataExtraction.enabled: false
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA'),
privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]
}
@AbapCatalog: {
sqlViewName: 'IARMPEXECUTED',
preserveKey: true,
compiler.compareFilter: true
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #L
}
}
define view I_AdvncdRetsMgmtProcExecuted
as select from msr_d_executed as Executed
//Associations
association [1..1] to I_AdvncdReturnsMgmtProcess as _AdvncdRetsMgmtProcess on $projection.RetsMgmtProcess = _AdvncdRetsMgmtProcess.RetsMgmtProcess
association [1..1] to I_AdvncdReturnsMgmtProcessItem as _AdvncdRetsMgmtProcessItem on $projection.RetsMgmtProcess = _AdvncdRetsMgmtProcessItem.RetsMgmtProcess
and $projection.RetsMgmtProcessItem = _AdvncdRetsMgmtProcessItem.RetsMgmtProcessItem
association [0..1] to I_ReturnsDocumentType as _ReturnsReferenceDocumentType on $projection.ReturnsReferenceDocumentType = _ReturnsReferenceDocumentType.ReturnsDocumentType
association [0..1] to I_ReturnsRefundType as _ReturnsRefundType on $projection.ReturnsRefundType = _ReturnsRefundType.ReturnsRefundType
association [0..1] to I_ReturnsRefundProcgModeActive as _ReturnsRefundProcgMode on $projection.ReturnsRefundProcgMode = _ReturnsRefundProcgMode.ReturnsRefundProcgMode
and $projection.ReturnsRefundType = _ReturnsRefundProcgMode.ReturnsRefundType
association [0..1] to I_UnitOfMeasure as _ReplacementMaterialQtyUnit on $projection.ReplacementMaterialQtyUnit = _ReplacementMaterialQtyUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _ReplacedMaterialQtyUnit on $projection.ReplacedMaterialQtyUnit = _ReplacedMaterialQtyUnit.UnitOfMeasure
association [1..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [1..1] to I_Address as _Address on $projection.AddressID = _Address.AddressID
association [1..*] to I_Address_2 as _DfltAddrRprstn on $projection.AddressID = _DfltAddrRprstn.AddressID
association [0..1] to I_RetMatlInspResultCode as _RetMatlInspResultCode on $projection.RetMatlInspResultCode = _RetMatlInspResultCode.RetMatlInspResultCode
{
//Key
key msr_id as RetsMgmtProcess,
key item as RetsMgmtProcessItem,
key split_id as RetsMgmtProcItmQtySplit,
key executed_step_id as RetsMgmtProcessStep,
key doc_type as ReturnsDocumentType,
key doc_nr as ReturnsDocument,
key doc_item as ReturnsDocumentItem,
cast (right(doc_item, 6) as posnr) as SDDocumentItem,
executed_seq_id as RetsMgmtProcItmExectdSequence,
chain_id as CustRetItmChainID,
//Reference Document
@ObjectModel.foreignKey.association: '_ReturnsReferenceDocumentType'
ref_doc_type as ReturnsReferenceDocumentType,
ref_doc_nr as ReturnsReferenceDocument,
ref_doc_item as ReturnsReferenceDocumentItem,
//Returns Document Status
doc_status as ReturnsDocumentStatus,
appr_status as ReturnsDocumentApprovalStatus,
im_plant as TargetPlant,
lgort as TargetStorageLocation,
insmk as TargetStockType,
im_material as TgtProdForGdsMvtPostg,
//Refunding
@ObjectModel.foreignKey.association: '_ReturnsRefundType'
refund_type as ReturnsRefundType,
@ObjectModel.foreignKey.association: '_ReturnsRefundProcgMode'
cast (refund_control as returns_refund_procg_mode preserving type) as ReturnsRefundProcgMode,
cast (pre_refund as abap.char(1)) as PrelimRefundIsDetermined,
//Replacement
replace_matnr as ReplacementMaterial,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'ReplacementMaterialQtyUnit'
replace_qty as ReplacementMaterialQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ReplacementMaterialQtyUnit'
replace_unit as ReplacementMaterialQtyUnit,
cast (replace_request as abap.char(1)) as ReplacementMaterialIsRequested,
paying_plant as ReplacementMatlSupplyingPlant,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'ReplacedMaterialQtyUnit'
replaced_qty as ReplacedMaterialQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ReplacedMaterialQtyUnit'
replaced_unit as ReplacedMaterialQtyUnit,
@ObjectModel.foreignKey.association: '_Supplier'
lifnr as Supplier,
@ObjectModel.foreignKey.association: '_Address'
addrnumber as AddressID,
rma_vendor as SupplierRetMatlAuthzn,
cast (rma_vendor_req as abap.char(1)) as SuplrRetMatlAuthznIsRequired,
//Inspection
@ObjectModel.foreignKey.association: '_RetMatlInspResultCode'
inspection_code as RetMatlInspResultCode,
//Associations
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_AdvncdRetsMgmtProcess,
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
_AdvncdRetsMgmtProcessItem,
_ReturnsReferenceDocumentType,
_ReturnsRefundType,
_ReturnsRefundProcgMode,
_ReplacementMaterialQtyUnit,
_ReplacedMaterialQtyUnit,
_Supplier,
_Address,
_DfltAddrRprstn,
_RetMatlInspResultCode
}