P_ACMFormulaGrpgGeneralRes

DDL: P_ACMFORMULAGRPGGENERALRES SQL: PFMLAGRPGENRS Type: view BASIC
8 Fields 1 Data Sources

P_ACMFormulaGrpgGeneralRes is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (cped_formdoc) and exposes 8 fields with key fields ACMPricingDocItemUUID, ACMPricingConditionType.

Data Sources (1)

SourceAliasJoin Type
cped_formdoc cped_formdoc from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFMLAGRPGENRS 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 #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ACMPricingDocItemUUID docitem_guid GUID
KEY ACMPricingConditionType cond_type Demurrage rate
PrcgConditionFormulaInputUUID forminput_guid Doc. Form. GUID
ACMPrcgCndnFormulaPrice formrate Formula Rate
ACMPrcgCndnFormulaRateCrcy formcurr Formula Currency
ACMPrcgCndnFormulaRateQty formprun Formula Price Unit
ACMPrcgCndnFormulaRateQtyUnit formuom Formula UoM
ACMPrcgCndnDocumentCrcy doccurr Doc. Currency

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 P_ACMFormulaGrpgGeneralRes.
-- 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: PFMLAGRPGENRS

CREATE VIEW P_ACMFormulaGrpgGeneralRes AS
SELECT
  docitem_guid AS ACMPricingDocItemUUID,
  cond_type AS ACMPricingConditionType,
  forminput_guid AS PrcgConditionFormulaInputUUID,
  formrate AS ACMPrcgCndnFormulaPrice,
  formcurr AS ACMPrcgCndnFormulaRateCrcy,
  formprun AS ACMPrcgCndnFormulaRateQty,
  formuom AS ACMPrcgCndnFormulaRateQtyUnit,
  doccurr AS ACMPrcgCndnDocumentCrcy
FROM cped_formdoc
;

Learn More