C_CmplAgnstSuplrOutpParamFDP

DDL: C_CMPLAGNSTSUPLROUTPPARAMFDP Type: view_entity CONSUMPTION Package: ODATA_QM_CMPLAGSUPLR
8 Fields 2 Data Sources 1 Associations

FDP for Output Param Compl Agnst Suplr

C_CmplAgnstSuplrOutpParamFDP is a Consumption CDS View that provides data about "FDP for Output Param Compl Agnst Suplr" in SAP S/4HANA. It reads from 2 data sources (I_ComplaintAgainstSupplier, P_CmplAgnstSuplrToBizPartner) and exposes 8 fields with key field ComplaintAgainstSupplier. It has 1 association to related views. Part of development package ODATA_QM_CMPLAGSUPLR.

Data Sources (2)

SourceAliasJoin Type
I_ComplaintAgainstSupplier _cas from
P_CmplAgnstSuplrToBizPartner _castosup left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CmplAgnstSuplrPartner _CmplAgnstSuplrPartner $projection.ComplaintAgainstSupplier = _CmplAgnstSuplrPartner.ComplaintAgainstSupplier

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label FDP for Output Param Compl Agnst Suplr view
VDM.viewType #CONSUMPTION view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ComplaintAgainstSupplier I_ComplaintAgainstSupplier ComplaintAgainstSupplier
Plant I_ComplaintAgainstSupplier Plant Valuation Area
QltyCmplLifecycleStatus I_ComplaintAgainstSupplier QltyCmplLifecycleStatus Life Cycle Status
QualityIssueReference I_ComplaintAgainstSupplier QualityIssueReference Reference Number
NotificationPriorityType I_ComplaintAgainstSupplier NotificationPriorityType
NotificationPriority I_ComplaintAgainstSupplier NotificationPriority Workflow priority
BusinessPartnerasBusinessPartner Supplier (Business Partner)
Supplier

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_CmplAgnstSuplrOutpParamFDP.
-- 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 C_CmplAgnstSuplrOutpParamFDP AS
SELECT
  _cas.ComplaintAgainstSupplier AS ComplaintAgainstSupplier,
  _cas.Plant AS Plant,
  _cas.QltyCmplLifecycleStatus AS QltyCmplLifecycleStatus,
  _cas.QualityIssueReference AS QualityIssueReference,
  _cas.NotificationPriorityType AS NotificationPriorityType,
  _cas.NotificationPriority AS NotificationPriority,
  _CmplAgnstSuplrPartner[ to one: ComplaintAgainstSupplier = complaintagainstsupplier and QualityComplaintIsSupplier = 'X' ].BusinessPartner as BusinessPartner AS BusinessPartnerasBusinessPartner,
  _castosup._SupplierToBusinessPartner.Supplier AS Supplier
FROM I_ComplaintAgainstSupplier AS _cas
LEFT OUTER JOIN P_CmplAgnstSuplrToBizPartner AS _castosup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmplAgnstSuplrPartner AS _CmplAgnstSuplrPartner ON ComplaintAgainstSupplier = _CmplAgnstSuplrPartner.ComplaintAgainstSupplier  -- association [0..*]
;

Learn More