C_ValuationDocumentHdrQry

DDL: C_VALUATIONDOCUMENTHDRQRY SQL: CPVVALNDOCHDRQ Type: view CONSUMPTION Package: OIU_VDM_CDS
13 Fields 1 Data Sources

Valuation Document Header Query

C_ValuationDocumentHdrQry (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_ValuationDocumentHdrQry is a Consumption CDS View that provides data about "Valuation Document Header Query" in SAP S/4HANA. It reads from 1 data source (I_ValuationDocumentHdr) and exposes 13 fields with key fields ValuationDocumentNumber, ValuationDocumentYear. Part of development package OIU_VDM_CDS.

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ValuationDocumentHdr I_ValuationDocumentHdr from

Annotations (9)

NameValueLevelField
EndUserText.label Valuation Document Header Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CPVVALNDOCHDRQ view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ValuationDocumentNumber ValuationDocumentNumber Val. document number
KEY ValuationDocumentYear ValuationDocumentYear Mat. Doc. Year
ValuationDocumentStatus ValuationDocumentStatus Valuation Document Status
PrimaryGeogrlLocation _DeliveryNetwork PrimaryGeogrlLocation Primary Geographical Location
DeliveryNetworkHier _DeliveryNetwork DeliveryNetworkHier Delivery Network Hierarchy Group
DeliveryNetwork DeliveryNetwork Delivery network number
SalesDate SalesDate Sales Date / Month
AllocationFrequency AllocationFrequency Frequency
ValuationDocumentType ValuationDocumentType Valuation Document Type
ProcessingStatus ProcessingStatus Valuation Document Processing Status
LastExecutionDate LastExecutionDate Run date
LastExecutionTime LastExecutionTime Start Time
NumberOfDocuments NumberOfDocuments Number of Documents

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_ValuationDocumentHdrQry.
-- 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: CPVVALNDOCHDRQ

CREATE VIEW C_ValuationDocumentHdrQry AS
SELECT
  ValuationDocumentNumber,
  ValuationDocumentYear,
  ValuationDocumentStatus,
  _DeliveryNetwork.PrimaryGeogrlLocation AS PrimaryGeogrlLocation,
  _DeliveryNetwork.DeliveryNetworkHier AS DeliveryNetworkHier,
  DeliveryNetwork,
  SalesDate,
  AllocationFrequency,
  ValuationDocumentType,
  ProcessingStatus,
  LastExecutionDate,
  LastExecutionTime,
  NumberOfDocuments
FROM I_ValuationDocumentHdr
;

Learn More