C_PrepayThresholdPercent

DDL: C_PREPAYTHRESHOLDPERCENT SQL: CPPMTTHOLD Type: view CONSUMPTION
10 Fields 3 Data Sources

Consumption view for threshold

C_PrepayThresholdPercent is a Consumption CDS View that provides data about "Consumption view for threshold" in SAP S/4HANA. It reads from 3 data sources (I_ACMTrdgContractBusinessData, I_PrepayRefDocThresholdPercent, I_ACMTradingContractData) and exposes 10 fields with key fields PrepaymentRefDocThresholdUUID, PrepaymentAgrmtRefDocument, PrepaymentReferenceDocItem.

Data Sources (3)

SourceAliasJoin Type
I_ACMTrdgContractBusinessData Business inner
I_PrepayRefDocThresholdPercent I_PrepayRefDocThresholdPercent from
I_ACMTradingContractData TrdgContrHdr inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPPMTTHOLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Consumption view for threshold view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentRefDocThresholdUUID PrepaymentRefDocThresholdUUID UUID
KEY PrepaymentAgrmtRefDocument PrepaymentAgrmtRefDocument Linking Document No.
KEY PrepaymentReferenceDocItem PrepaymentReferenceDocItem
PrepaymentDocThresholdPercent PrepaymentDocThresholdPercent Threshold Percentage
TradingContractType I_ACMTradingContractData TradingContractType Contract Type
SalesOrganization SalesOrganization Sales Organization
Division Division Internal Division ID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization

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_PrepayThresholdPercent.
-- 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: CPPMTTHOLD

CREATE VIEW C_PrepayThresholdPercent AS
SELECT
  PrepaymentRefDocThresholdUUID,
  PrepaymentAgrmtRefDocument,
  PrepaymentReferenceDocItem,
  PrepaymentDocThresholdPercent,
  TrdgContrHdr.TradingContractType AS TradingContractType,
  SalesOrganization,
  Division,
  DistributionChannel,
  PurchasingGroup,
  PurchasingOrganization
FROM I_PrepayRefDocThresholdPercent
INNER JOIN I_ACMTradingContractData AS TrdgContrHdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContractBusinessData AS Business ON /* join condition not captured in parsed metadata */
;

Learn More