R_CmplAgnstSuplrActnParamTP

DDL: R_CMPLAGNSTSUPLRACTNPARAMTP Type: view_entity TRANSACTIONAL Package: VDM_QM_CMPLAGAINSTSUPLR
36 Fields 1 Data Sources 6 Associations

Comp Against Supplier Action Param - TP

R_CmplAgnstSuplrActnParamTP is a Transactional CDS View that provides data about "Comp Against Supplier Action Param - TP" in SAP S/4HANA. It reads from 1 data source (I_CmplAgnstSuplrActnParam) and exposes 36 fields with key fields ComplaintAgainstSupplier, QltyCmplActionInternalNumber, QualityComplaintItem. It has 6 associations to related views. Part of development package VDM_QM_CMPLAGAINSTSUPLR.

Data Sources (1)

SourceAliasJoin Type
I_CmplAgnstSuplrActnParam param from

Associations (6)

CardinalityTargetAliasCondition
[1..1] R_ComplaintAgainstSupplierTP _ComplaintAgainstSupplier $projection.ComplaintAgainstSupplier = _ComplaintAgainstSupplier.ComplaintAgainstSupplier
[0..1] R_CmplAgainstSupplierItemTP _CmplAgainstSupplierItem $projection.ComplaintAgainstSupplier = _CmplAgainstSupplierItem.ComplaintAgainstSupplier and $projection.QualityComplaintItem = _CmplAgainstSupplierItem.QualityComplaintItem
[0..1] I_PurchaseOrderTP_2 _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[0..1] I_PurchaseOrderItemTP_2 _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
[0..1] I_MaterialDocumentTP _MaterialDocument $projection.MaterialDocumentYear = _MaterialDocument.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocument.MaterialDocument
[0..1] I_MaterialDocumentItemTP _MaterialDocumentItem $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentItem.MaterialDocument and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Comp Against Supplier Action Param - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey QualityComplaintItem view
ObjectModel.sapObjectNodeType.name CmplAgainstSupplierActionParam view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ComplaintAgainstSupplier I_CmplAgnstSuplrActnParam ComplaintAgainstSupplier
KEY QltyCmplActionInternalNumber I_CmplAgnstSuplrActnParam QltyCmplActionInternalNumber
KEY QualityComplaintItem I_CmplAgnstSuplrActnParam QualityComplaintItem
PurchaseOrderType I_CmplAgnstSuplrActnParam PurchaseOrderType PO Type
PurchasingOrganization I_CmplAgnstSuplrActnParam PurchasingOrganization Purchasing Organization
PurchasingGroup I_CmplAgnstSuplrActnParam PurchasingGroup Purchasing Group
CompanyCode I_CmplAgnstSuplrActnParam CompanyCode Receiver Company Code
PurchasingCompletenessStatus I_CmplAgnstSuplrActnParam PurchasingCompletenessStatus Incomplete
Supplier I_CmplAgnstSuplrActnParam Supplier Supplier
QltyCmplActionQuantity I_CmplAgnstSuplrActnParam QltyCmplActionQuantity
QltyCmplActionQuantityUnit I_CmplAgnstSuplrActnParam QltyCmplActionQuantityUnit
Plant I_CmplAgnstSuplrActnParam Plant Valuation Area
StorageLocation I_CmplAgnstSuplrActnParam StorageLocation StorageLocation
ControllingArea I_CmplAgnstSuplrActnParam ControllingArea Controlling Area
CostCenter I_CmplAgnstSuplrActnParam CostCenter Cost Center
GoodsMovementType I_CmplAgnstSuplrActnParam GoodsMovementType Movement Type
PurchasingInfoRecord I_CmplAgnstSuplrActnParam PurchasingInfoRecord Info Record
PurchaseOrder I_CmplAgnstSuplrActnParam PurchaseOrder Purchasing Document
PurchaseOrderItem I_CmplAgnstSuplrActnParam PurchaseOrderItem Purchasing Document Item
MaterialDocumentYear I_CmplAgnstSuplrActnParam MaterialDocumentYear Material Document Year
MaterialDocument I_CmplAgnstSuplrActnParam MaterialDocument Material Doc.
MaterialDocumentItem I_CmplAgnstSuplrActnParam MaterialDocumentItem Material Document Item
_ComplaintAgainstSupplier _ComplaintAgainstSupplier
_CmplAgainstSupplierAction _CmplAgainstSupplierAction
_CmplAgainstSupplierItem _CmplAgainstSupplierItem
_PurchaseOrderType _PurchaseOrderType
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_CompanyCode _CompanyCode
_Supplier _Supplier
_Plant _Plant
_StorageLocation _StorageLocation
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_MaterialDocument _MaterialDocument
_MaterialDocumentItem _MaterialDocumentItem

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 R_CmplAgnstSuplrActnParamTP.
-- 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.

CREATE VIEW R_CmplAgnstSuplrActnParamTP AS
SELECT
  param.ComplaintAgainstSupplier AS ComplaintAgainstSupplier,
  param.QltyCmplActionInternalNumber AS QltyCmplActionInternalNumber,
  param.QualityComplaintItem AS QualityComplaintItem,
  param.PurchaseOrderType AS PurchaseOrderType,
  param.PurchasingOrganization AS PurchasingOrganization,
  param.PurchasingGroup AS PurchasingGroup,
  param.CompanyCode AS CompanyCode,
  param.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  param.Supplier AS Supplier,
  param.QltyCmplActionQuantity AS QltyCmplActionQuantity,
  param.QltyCmplActionQuantityUnit AS QltyCmplActionQuantityUnit,
  param.Plant AS Plant,
  param.StorageLocation AS StorageLocation,
  param.ControllingArea AS ControllingArea,
  param.CostCenter AS CostCenter,
  param.GoodsMovementType AS GoodsMovementType,
  param.PurchasingInfoRecord AS PurchasingInfoRecord,
  param.PurchaseOrder AS PurchaseOrder,
  param.PurchaseOrderItem AS PurchaseOrderItem,
  param.MaterialDocumentYear AS MaterialDocumentYear,
  param.MaterialDocument AS MaterialDocument,
  param.MaterialDocumentItem AS MaterialDocumentItem
FROM I_CmplAgnstSuplrActnParam AS param
LEFT OUTER JOIN R_ComplaintAgainstSupplierTP AS _ComplaintAgainstSupplier ON ComplaintAgainstSupplier = _ComplaintAgainstSupplier.ComplaintAgainstSupplier  -- association [1..1]
LEFT OUTER JOIN R_CmplAgainstSupplierItemTP AS _CmplAgainstSupplierItem ON ComplaintAgainstSupplier = _CmplAgainstSupplierItem.ComplaintAgainstSupplier AND QualityComplaintItem = _CmplAgainstSupplierItem.QualityComplaintItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderTP_2 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemTP_2 AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentTP AS _MaterialDocument ON MaterialDocumentYear = _MaterialDocument.MaterialDocumentYear AND MaterialDocument = _MaterialDocument.MaterialDocument  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentItemTP AS _MaterialDocumentItem ON MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentItem.MaterialDocument AND MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [0..1]
;

Learn More