I_DPQSHeaderDetails

DDL: I_DPQSHEADERDETAILS SQL: IDPQSHDRDET Type: view COMPOSITE
18 Fields 2 Data Sources

Interface Layer for Trading Contract DPQS Header Details

I_DPQSHeaderDetails (Composite)

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

Sales

I_DPQSHeaderDetails is a Composite CDS View that provides data about "Interface Layer for Trading Contract DPQS Header Details" in SAP S/4HANA. It reads from 2 data sources (I_DiscPremQltySchedOvrdDet, P_GenericDomainVH) and exposes 18 fields with key fields TradingContractNumber, TradingContractItem.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AGR-CC
CapabilitiesData Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_DiscPremQltySchedOvrdDet dpqsoverrides from
P_GenericDomainVH P_GenericDomainVH left_outer

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IDPQSHDRDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Interface Layer for Trading Contract DPQS Header Details view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber TradingContractNumber Trading Contract
KEY TradingContractItem TradingContractItem Item Number of Trading Contract
DiscPremQtyScheduleVersion DiscPremQtyScheduleVersion Sch Version
DiscPremQtyVersionDateTime DiscPremQtyVersionDateTime Version Time Stamp
DiscPremQtyScheduleUniqueID DiscPremQtyScheduleUniqueID Schedule ID
DiscPremQtyOvrdTiming DiscPremQtyOvrdTiming Timing
DiscPremQtyOvrdTimingText TimingText DomainText Short Text for Fixed Values
DiscPremQtyOvrdIsUnloadLoc DiscPremQtyOvrdIsUnloadLoc Schedule at Unload Location
DiscPremQtyOvrdGovAnalysisCode I_DiscPremQltySchedOvrdDet DiscPremQtyOvrdGovAnalysisCode Governing Analysis Code
DiscPremQtyOvrdGovAnalysisDesc _DiscPremQltySchedGovAnlys DiscPremQtyOvrdGovAnalysisDesc Governing Analysis Description
DiscPremQtyOvrdGovWeightCode I_DiscPremQltySchedOvrdDet DiscPremQtyOvrdGovWeightCode
DiscPremQtyOvrdGovWeightDesc _DiscPremQltySchedGovWgt DiscPremQtyOvrdGovWeightDesc Description
DiscPremQtyOvrdGovTerm DiscPremQtyOvrdGovTerm Governing Term
DiscPremQtyScheduleUUID DiscPremQtyScheduleUUID Schedule GUID
DiscPremQtyIsOvrdFlag DiscPremQtyIsOvrdFlag Boolean Variable (X = True, - = False, Space = Unknown)
DiscPremQtySchedValdtyVersion DiscPremQtySchedValdtyVersion Schedule Validity Version
DiscPremQtyScheduleName DiscPremQtyScheduleName DPQS Schedule Name
ACMOvrrdeVersionDPQSVal ACMOvrrdeVersionDPQSVal Sch Version

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 I_DPQSHeaderDetails.
-- 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: IDPQSHDRDET

CREATE VIEW I_DPQSHeaderDetails AS
SELECT
  TradingContractNumber,
  TradingContractItem,
  DiscPremQtyScheduleVersion,
  DiscPremQtyVersionDateTime,
  DiscPremQtyScheduleUniqueID,
  DiscPremQtyOvrdTiming,
  TimingText.DomainText AS DiscPremQtyOvrdTimingText,
  DiscPremQtyOvrdIsUnloadLoc,
  dpqsoverrides.DiscPremQtyOvrdGovAnalysisCode AS DiscPremQtyOvrdGovAnalysisCode,
  _DiscPremQltySchedGovAnlys.DiscPremQtyOvrdGovAnalysisDesc AS DiscPremQtyOvrdGovAnalysisDesc,
  dpqsoverrides.DiscPremQtyOvrdGovWeightCode AS DiscPremQtyOvrdGovWeightCode,
  _DiscPremQltySchedGovWgt.DiscPremQtyOvrdGovWeightDesc AS DiscPremQtyOvrdGovWeightDesc,
  DiscPremQtyOvrdGovTerm,
  DiscPremQtyScheduleUUID,
  DiscPremQtyIsOvrdFlag,
  DiscPremQtySchedValdtyVersion,
  DiscPremQtyScheduleName,
  ACMOvrrdeVersionDPQSVal
FROM I_DiscPremQltySchedOvrdDet AS dpqsoverrides
LEFT OUTER JOIN P_GenericDomainVH ON /* join condition not captured in parsed metadata */
;

Learn More