C_SchedgAgrmtRelOutputParamDet

DDL: C_SCHEDGAGRMTRELOUTPUTPARAMDET SQL: CMMSAROMPRMS Type: view CONSUMPTION
7 Fields 1 Data Sources

Scheduling Agreement Release OPD

C_SchedgAgrmtRelOutputParamDet is a Consumption CDS View that provides data about "Scheduling Agreement Release OPD" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtReleaseDoc) and exposes 7 fields with key fields SchedulingAgreement, SchedulingAgreementItem, SchedulingAgreementReleaseType, ReleaseCode.

Data Sources (1)

SourceAliasJoin Type
I_SchedgAgrmtReleaseDoc I_SchedgAgrmtReleaseDoc from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CMMSAROMPRMS view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Scheduling Agreement Release OPD view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem SchedulingAgreementItem Schedule Item Number
KEY SchedulingAgreementReleaseType SchedulingAgreementReleaseType
KEY ReleaseCode ReleaseCode Release ind.
PurchasingDocumentType _Schedgagrmthdr PurchasingDocumentType RFQ Type
PurchasingGroup _Schedgagrmthdr PurchasingGroup Purchasing Group
PurchasingOrganization _Schedgagrmthdr PurchasingOrganization Purchasing Organization

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_SchedgAgrmtRelOutputParamDet.
-- 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: CMMSAROMPRMS

CREATE VIEW C_SchedgAgrmtRelOutputParamDet AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  SchedulingAgreementReleaseType,
  ReleaseCode,
  _Schedgagrmthdr.PurchasingDocumentType AS PurchasingDocumentType,
  _Schedgagrmthdr.PurchasingGroup AS PurchasingGroup,
  _Schedgagrmthdr.PurchasingOrganization AS PurchasingOrganization
FROM I_SchedgAgrmtReleaseDoc
;

Learn More