C_OpenCatalogProposalDesc

DDL: C_OPENCATALOGPROPOSALDESC SQL: COCIPROPOSALTEXT Type: view CONSUMPTION Package: ODATA_MM_PUR_REQ_MAINTAIN
4 Fields 1 Data Sources

Internal Catalog Proposal Desc

C_OpenCatalogProposalDesc is a Consumption CDS View that provides data about "Internal Catalog Proposal Desc" in SAP S/4HANA. It reads from 1 data source (I_OpenCatalogProposalDesc) and exposes 4 fields with key fields OpnCtlgItemPrpslID, OpnCtlgPrpslDescSequenceNumber. Part of development package ODATA_MM_PUR_REQ_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_OpenCatalogProposalDesc I_OpenCatalogProposalDesc from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName COCIPROPOSALTEXT view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Internal Catalog Proposal Desc view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY OpnCtlgItemPrpslID OpnCtlgItemPrpslID Proposal ID
KEY OpnCtlgPrpslDescSequenceNumber OpnCtlgPrpslDescSequenceNumber Serial Number of Proposal Descriptions
OpnCtlgItemPrpslDesc OpnCtlgItemPrpslDesc Well Code Des.
PurReqnCatalog PurReqnCatalog Web Service ID

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_OpenCatalogProposalDesc.
-- 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: COCIPROPOSALTEXT

CREATE VIEW C_OpenCatalogProposalDesc AS
SELECT
  OpnCtlgItemPrpslID,
  OpnCtlgPrpslDescSequenceNumber,
  OpnCtlgItemPrpslDesc,
  PurReqnCatalog
FROM I_OpenCatalogProposalDesc
;

Learn More