C_ChmlSuplrMatlNoReldCmpstn

DDL: C_CHMLSUPLRMATLNORELDCMPSTN Type: view CONSUMPTION Package: EHFND_CNS_CCI
6 Fields 1 Data Sources 1 Associations 1 OData Services

Suppliers Without Released Composition

C_ChmlSuplrMatlNoReldCmpstn is a Consumption CDS View that provides data about "Suppliers Without Released Composition" in SAP S/4HANA. It reads from 1 data source (P_ChmlSuplrMatlNoReldCmpstn) and exposes 6 fields with key field ChmlSuplrMatlUUID. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F3210). Part of development package EHFND_CNS_CCI.

Data Sources (1)

SourceAliasJoin Type
P_ChmlSuplrMatlNoReldCmpstn ChmlSuplrMatl from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_ChmlSuplrMatlData _AdditionalData $projection.ChmlSuplrMatlUUID = _AdditionalData.ChmlSuplrMatlUUID

Annotations (16)

NameValueLevelField
EndUserText.label Suppliers Without Released Composition view
AbapCatalog.sqlViewName CSMTLNORELCMPSTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
UI.lineItem.criticality ChmlCmpstnCalcProbCritlty view
UI.headerInfo.typeName Supplier Without Composition view
UI.headerInfo.typeNamePlural Suppliers Without Composition view
UI.headerInfo.title.label Supplier Without Composition view
UI.headerInfo.title.value BusinessPartnerSupplier view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3210 ASQL_F3210 C2 NOT_RELEASED

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChmlSuplrMatlUUID ChmlSuplrMatlUUID Supplier Raw Material
CCIunderinvestigationChmlCmplncInfoUUID
ChmlCmpstnCalcProbCritlty
ResponsibleUnit P_ChmlSuplrMatlNoReldCmpstn ResponsibleUnit Responsible Unit
AuthorizationGroup
_BusinessPartner

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_ChmlSuplrMatlNoReldCmpstn.
-- 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_ChmlSuplrMatlNoReldCmpstn AS
SELECT
  ChmlSuplrMatlUUID,
  cast( 2 as ehfnd_calc_prob_critlty ) AS ChmlCmpstnCalcProbCritlty,
  ChmlSuplrMatl.ResponsibleUnit AS ResponsibleUnit
FROM P_ChmlSuplrMatlNoReldCmpstn AS ChmlSuplrMatl
LEFT OUTER JOIN P_ChmlSuplrMatlData AS _AdditionalData ON ChmlSuplrMatlUUID = _AdditionalData.ChmlSuplrMatlUUID  -- association [1..1]
;

Learn More