REPM_PurOrderGrosAmtQ

DDL: REPM_PURORDERGROSSAMTQ SQL: REPM_PURGROSSQ Type: view
5 Fields 1 Data Sources

Gross Amount Query View

REPM_PurOrderGrosAmtQ is a CDS View that provides data about "Gross Amount Query View" in SAP S/4HANA. It reads from 1 data source (REPM_PurOrderGrossAmtC) and exposes 5 fields.

Data Sources (1)

SourceAliasJoin Type
REPM_PurOrderGrossAmtC REPM_PurOrderGrossAmtC from

Parameters (2)

NameTypeDefault
P_KeyDate sydate
hidden true

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName REPM_PURGROSSQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
EndUserText.label Gross Amount Query View view
OData.publish true view

Fields (5)

KeyFieldSource TableSource FieldDescription
GrossAmount REPM_PurOrderGrossAmtC GrossAmount GrossAmount
TransactionCurrency REPM_PurOrderGrossAmtC TransactionCurrency Transaction Currency
TaxAmount REPM_PurOrderGrossAmtC TaxAmount Tax Amount
NetAmount REPM_PurOrderGrossAmtC NetAmount Net Order Amount
PurchaseOrder REPM_PurOrderGrossAmtC PurchaseOrder Purchase Order(EPM Demo)

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 REPM_PurOrderGrosAmtQ.
-- 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: REPM_PURGROSSQ
-- Parameters: P_KeyDate : sydate, hidden : true

CREATE VIEW REPM_PurOrderGrosAmtQ AS
SELECT
  REPM_PurOrderGrossAmtC.GrossAmount AS GrossAmount,
  REPM_PurOrderGrossAmtC.TransactionCurrency AS TransactionCurrency,
  REPM_PurOrderGrossAmtC.TaxAmount AS TaxAmount,
  REPM_PurOrderGrossAmtC.NetAmount AS NetAmount,
  REPM_PurOrderGrossAmtC.PurchaseOrder AS PurchaseOrder
FROM REPM_PurOrderGrossAmtC
;

Learn More