I_QltyTaskFllwUpActionParamTP

DDL: I_QLTYTASKFLLWUPACTIONPARAMTP Type: view TRANSACTIONAL Package: VDM_QM_NOTIFICATION

Quality Task Follow-Up Action Parameter

I_QltyTaskFllwUpActionParamTP is a Transactional CDS View that provides data about "Quality Task Follow-Up Action Parameter" in SAP S/4HANA. It reads from 1 data source (I_QltyTaskFllwUpActionParam) and exposes 49 fields with key fields QualityTaskInternalId, ItemCounter. It has 2 associations to related views. Part of development package VDM_QM_NOTIFICATION.

Data Sources (1)

SourceAliasJoin Type
I_QltyTaskFllwUpActionParam I_QltyTaskFllwUpActionParam from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_QualityTaskTP _QualityTaskTP $projection.QualityTaskInternalId = _QualityTaskTP.QualityTaskInternalId
[1..1] E_QltyTskFllwUpActnParam _Extension $projection.QualityTaskInternalId = _Extension.QualityNotification and _Extension.QualityNotificationTask = '0000' and $projection.ItemCounter = _Extension.ItemCounter

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IQLTYTSKFOAPRMTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence QTASKFOAPARAM_D view
ObjectModel.writeActivePersistence V_QTSKFP_DR2ACT view
ObjectModel.representativeKey ItemCounter view
EndUserText.label Quality Task Follow-Up Action Parameter view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId QualityTaskInternalId
KEY ItemCounter ItemCounter
QualityTask QualityTask
QltyTaskFllwUpActionParam QltyTaskFllwUpActionParam
QltyTskFllwUpActnParamType QltyTskFllwUpActnParamType
DefectiveQuantity DefectiveQuantity
DefectiveQuantityUnit DefectiveQuantityUnit
Material Material
Plant Plant
StorageLocation StorageLocation
DefectAffectedObject DefectAffectedObject
BillOfOperationsType BillOfOperationsType
BillOfOperationsGroup BillOfOperationsGroup
BillOfOperationsVariant BillOfOperationsVariant
BillOfOperationsVersion BillOfOperationsVersion
OrderInternalID OrderInternalID
OrderOperationInternalID OrderOperationInternalID
OrderID _OrderInternalID OrderID
Operation
MfgReworkRoutingGroup MfgReworkRoutingGroup
MfgReworkRoutingVariant MfgReworkRoutingVariant
MfgNonConformanceRsnCodeCtlg MfgNonConformanceRsnCodeCtlg
MfgNonConformanceRsnCodeGrp MfgNonConformanceRsnCodeGrp
MfgNonConformanceReasonCode MfgNonConformanceReasonCode
MfgNonConformanceNote MfgNonConformanceNote
ChangeRecord ChangeRecord
ChangeRecordType ChangeRecordType
ChgRecordDescriptionText ChgRecordDescriptionText
ProductionSupplyArea ProductionSupplyArea
CostCenter CostCenter
SourceStorageBin SourceStorageBin
DefectUUID DefectUUID
StockItemUUID StockItemUUID
ParentHandlingUnitUUID ParentHandlingUnitUUID
QltyTaskStkSelInEWMIsProcd QltyTaskStkSelInEWMIsProcd
DefectAffectedObjIsAddlParam DefectAffectedObjIsAddlParam
Batch Batch
EWMWarehouse EWMWarehouse
QltyTaskEWMFollowUpAction QltyTaskEWMFollowUpAction
WarehouseLogicalSystem WarehouseLogicalSystem
_QualityTaskTP _QualityTaskTP
_Material _Material
_Plant _Plant
_StorageLocation _StorageLocation
_UnitOfMeasure _UnitOfMeasure
_MfgActionReasonCodeGroup _MfgActionReasonCodeGroup
_MfgActionReasonCode _MfgActionReasonCode
_ChangeRecordBsc _ChangeRecordBsc
_EWM_WarehouseNumber _EWM_WarehouseNumber
@AbapCatalog: {
    sqlViewName: 'IQLTYTSKFOAPRMTP',
    compiler.compareFilter: true,
    preserveKey: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #C
}

/* Draft 2.0*/
@ObjectModel:{
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    writeDraftPersistence: 'QTASKFOAPARAM_D',
    writeActivePersistence: 'V_QTSKFP_DR2ACT',
    representativeKey: 'ItemCounter',
    semanticKey: ['QualityTask', 'QltyTaskFllwUpActionParam']
}

@EndUserText.label: 'Quality Task Follow-Up Action Parameter'
define view I_QltyTaskFllwUpActionParamTP as select from I_QltyTaskFllwUpActionParam

//=== BO Aggregation

    association [1..1] to I_QualityTaskTP as _QualityTaskTP on $projection.QualityTaskInternalId = _QualityTaskTP.QualityTaskInternalId
    
//=== Extension

    association [1..1] to E_QltyTskFllwUpActnParam as _Extension on  $projection.QualityTaskInternalId = _Extension.QualityNotification
                                                                 and _Extension.QualityNotificationTask = '0000'
                                                                 and $projection.ItemCounter = _Extension.ItemCounter

{
    @ObjectModel: { foreignKey.association: '_QualityTaskTP',
                    readOnly: true }
    key QualityTaskInternalId,
    @ObjectModel.readOnly: true
    key ItemCounter,
    @ObjectModel: { readOnly: true }
    QualityTask,
    @ObjectModel: { readOnly: true }
    QltyTaskFllwUpActionParam,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    QltyTskFllwUpActnParamType,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    DefectiveQuantity,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    DefectiveQuantityUnit,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    Material,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    Plant,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    StorageLocation,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    DefectAffectedObject,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    BillOfOperationsType,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    BillOfOperationsGroup,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    BillOfOperationsVariant,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    BillOfOperationsVersion,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    OrderInternalID,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    OrderOperationInternalID,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    _OrderInternalID.OrderID,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    cast(_OrderOperationBasic.Operation as mpe_vornr preserving type ) as Operation,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    MfgReworkRoutingGroup,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    MfgReworkRoutingVariant,
    
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    MfgNonConformanceRsnCodeCtlg,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    MfgNonConformanceRsnCodeGrp,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    MfgNonConformanceReasonCode,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    MfgNonConformanceNote,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    ChangeRecord,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    ChangeRecordType,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    ChgRecordDescriptionText,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    ProductionSupplyArea,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    CostCenter,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    SourceStorageBin,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    DefectUUID,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    StockItemUUID,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    ParentHandlingUnitUUID,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    QltyTaskStkSelInEWMIsProcd,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    DefectAffectedObjIsAddlParam,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    Batch,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    EWMWarehouse,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    QltyTaskEWMFollowUpAction,
    @ObjectModel:{    readOnly: 'EXTERNAL_CALCULATION' }
    WarehouseLogicalSystem,
        
    /* Associations */
    @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
    _QualityTaskTP,
    _Material,
    _Plant,
    _StorageLocation,
    _UnitOfMeasure,
    _MfgActionReasonCodeGroup,
    _MfgActionReasonCode,
    _ChangeRecordBsc,
    _EWM_WarehouseNumber
}