C_QltyTskProcFllwActnTblParam

DDL: C_QLTYTSKPROCFLLWACTNTBLPARAM SQL: CQLTYTSKPROCFTP Type: view CONSUMPTION Package: ODATA_QM_TASK

Follow-up Action Single Parameter

C_QltyTskProcFllwActnTblParam is a Consumption CDS View that provides data about "Follow-up Action Single Parameter" in SAP S/4HANA. It reads from 1 data source (I_QltyTaskFllwUpActionParamTP) and exposes 39 fields with key fields QualityTaskInternalId, ItemCounter. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F2929, ASQL_F3250). Part of development package ODATA_QM_TASK.

Data Sources (1)

SourceAliasJoin Type
I_QltyTaskFllwUpActionParamTP I_QltyTaskFllwUpActionParamTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_QualityTaskProcess _QualityTaskProcess $projection.QualityTaskInternalId = _QualityTaskProcess.QualityTaskInternalId

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYTSKPROCFTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Follow-up Action Single Parameter view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ItemCounter view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.compositionRoot false view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F2929 ASQL_F2929 C2 NOT_RELEASED
ASQL_F3250 ASQL_F3250 C2 NOT_RELEASED

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId QualityTaskInternalId
KEY ItemCounter ItemCounter Sequence
QltyTskFllwUpActnParamType QltyTskFllwUpActnParamType
DefectiveQuantity DefectiveQuantity
DefectiveQuantityUnit DefectiveQuantityUnit
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsVersion BillOfOperationsVersion Routing Version
OrderInternalID OrderInternalID Plan No.f.Oper.
OrderOperationInternalID OrderOperationInternalID
OrderID OrderID Order ID
Operation Operation Transaction
MfgReworkRoutingGroup MfgReworkRoutingGroup
MfgReworkRoutingVariant MfgReworkRoutingVariant
MfgNonConformanceRsnCodeCtlg MfgNonConformanceRsnCodeCtlg
MfgNonConformanceRsnCodeGrp MfgNonConformanceRsnCodeGrp
MfgNonConformanceReasonCode MfgNonConformanceReasonCode
MfgNonConformanceNote MfgNonConformanceNote
ChangeRecord ChangeRecord Char20
ChangeRecordType ChangeRecordType Record Type
ChgRecordDescriptionText ChgRecordDescriptionText
DefectAffectedObject DefectAffectedObject
StockItemUUID StockItemUUID
ParentHandlingUnitUUID ParentHandlingUnitUUID
DefectAffectedObjIsAddlParam DefectAffectedObjIsAddlParam
QltyTaskStkSelInEWMIsProcd QltyTaskStkSelInEWMIsProcd
Batch Batch Lot No.
_QualityTaskProcess _QualityTaskProcess
_Material _Material
_Plant _Plant
_StorageLocation _StorageLocation
_UnitOfMeasure _UnitOfMeasure
_MfgActionReasonCodeGroup _MfgActionReasonCodeGroup
_MfgActionReasonCode _MfgActionReasonCode
_ChangeRecordBsc _ChangeRecordBsc

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_QltyTskProcFllwActnTblParam.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CQLTYTSKPROCFTP

CREATE VIEW C_QltyTskProcFllwActnTblParam AS
SELECT
  QualityTaskInternalId,
  ItemCounter,
  QltyTskFllwUpActnParamType,
  DefectiveQuantity,
  DefectiveQuantityUnit,
  Material,
  Plant,
  StorageLocation,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersion,
  OrderInternalID,
  OrderOperationInternalID,
  OrderID,
  Operation,
  MfgReworkRoutingGroup,
  MfgReworkRoutingVariant,
  MfgNonConformanceRsnCodeCtlg,
  MfgNonConformanceRsnCodeGrp,
  MfgNonConformanceReasonCode,
  MfgNonConformanceNote,
  ChangeRecord,
  ChangeRecordType,
  ChgRecordDescriptionText,
  DefectAffectedObject,
  StockItemUUID,
  ParentHandlingUnitUUID,
  DefectAffectedObjIsAddlParam,
  QltyTaskStkSelInEWMIsProcd,
  Batch
FROM I_QltyTaskFllwUpActionParamTP
LEFT OUTER JOIN C_QualityTaskProcess AS _QualityTaskProcess ON QualityTaskInternalId = _QualityTaskProcess.QualityTaskInternalId  -- association [1..1]
;