C_MaintOrdOpOutlineAgreementVH

DDL: C_MAINTORDOPOUTLINEAGREEMENTVH Type: view_entity CONSUMPTION Package: RAP_EAM_MAINTENANCEORDER

Outline Agreement

C_MaintOrdOpOutlineAgreementVH is a Consumption CDS View that provides data about "Outline Agreement" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocument) and exposes 13 fields with key field PurchasingDocument. It is exposed through 1 OData service (ASQL_F5241). Part of development package RAP_EAM_MAINTENANCEORDER.

Data Sources (1)

SourceAliasJoin Type
R_PurchasingDocument R_PurchasingDocument from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Outline Agreement view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey PurchasingDocument view
Search.searchable true view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F5241 ASQL_F5241 C2 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Outline Agreement
PurchasingDocumentName PurchasingDocumentName Agreement Description
Supplier Supplier Supplier
ValidityStartDate Validity Start Date
ValidityEndDate ValidTo
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
PurchasingDocumentType PurchasingDocumentType Purchasing Document Type
PurchasingDocumentTypeName
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentOrigin PurchasingDocumentOrigin Status
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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_MaintOrdOpOutlineAgreementVH.
-- 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_MaintOrdOpOutlineAgreementVH AS
SELECT
  PurchasingDocument,
  PurchasingDocumentName,
  Supplier,
  cast (ValidityStartDate as vdm_validitystart preserving type) AS ValidityStartDate,
  cast (ValidityEndDate as vdm_validityend preserving type) AS ValidityEndDate,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  PurchasingDocumentType,
  _PurchasingDocumentType._Text[1:Language=$session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingDocumentCategory,
  PurchasingDocumentOrigin,
  IsEndOfPurposeBlocked
FROM R_PurchasingDocument
;