C_POWthNonCmplncPaytTrmQry

DDL: C_POWTHNONCMPLNCPAYTTRMQRY SQL: CMMPOPAYTMQUERY Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
26 Fields 1 Data Sources

PO having Non compliant Payment Terms

C_POWthNonCmplncPaytTrmQry (Consumption)

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

Sourcing & Procurement

C_POWthNonCmplncPaytTrmQry is a Consumption CDS View that provides data about "PO having Non compliant Payment Terms" in SAP S/4HANA. It reads from 1 data source (C_POWthNonCmplncPaytTrm) and exposes 26 fields with key field PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-ANA-2CL
CapabilitiesAnalytical Query
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageSourcing and Procurement for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
C_POWthNonCmplncPaytTrm C_POWthNonCmplncPaytTrm from

Parameters (4)

NameTypeDefault
P_StartDate badat
P_EndDate badat
P_DateFunction datefunctionid
P_DisplayCurrency displaycurrency

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CMMPOPAYTMQUERY view
EndUserText.label PO having Non compliant Payment Terms view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
Analytics.query true view
OData.publish true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
resultElementDateFunctionStartDate
resultElementDateFunctionEndDate
P_StartDate
P_EndDate
P_DisplayCurrencykeyPurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem Item Number of Purchase Order
Supplier Supplier Supplier
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
MaterialGroup MaterialGroup Material Group
Plant Plant Valuation Area
SupplierCountry SupplierCountry Supplier Country/Region
Region Region Region (State, Province, County)
IncotermsClassification IncotermsClassification Incoterms (Part 1)
PaymentTerms PaymentTerms Terms of Payment Key
PaymentTermsDescription Payment Terms Description
PurchaseOrderDate PurchaseOrderDate Purchase Order Date
CalendarYear CalendarYear Calendar Year
DisplayCurrency DisplayCurrency Display Currency
PurOrdNetAmountInDisplayCrcy PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
NrOfPOInNonCompliantPaytTrms NrOfPOWithNonCompliantPaytTrm Number of PO with non compliant payment terms
NumberOfPurchaseOrders NumberOfPurchaseOrders Number of Purchase Orders
MinNrOfPOWithNonCompPaytTrm MinNrOfPOWithNonCompPaytTrm Number of PO with non compliant payment terms
NrOfPOWithNonCompliantPaytTrm Number of PO with non compliant payment terms
POWithNonCompliantPaytTrmPct Percentage of PO with non compliant payment terms

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_POWthNonCmplncPaytTrmQry.
-- 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: CMMPOPAYTMQUERY
-- Parameters: P_StartDate : badat, P_EndDate : badat, P_DateFunction : datefunctionid, P_DisplayCurrency : displaycurrency

CREATE VIEW C_POWthNonCmplncPaytTrmQry AS
SELECT
  resultElement: 'DateFunctionStartDate' AS resultElementDateFunctionStartDate,
  resultElement: 'DateFunctionEndDate' AS resultElementDateFunctionEndDate,
  binding: [ { targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' AS P_StartDate,
  P_EndDate : $parameters.P_EndDate AS P_EndDate,
  PurchaseOrderItem,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  MaterialGroup,
  Plant,
  SupplierCountry,
  Region,
  IncotermsClassification,
  PaymentTerms,
  _PaymentTerms._Text.PaymentTermsDescription AS PaymentTermsDescription,
  PurchaseOrderDate,
  CalendarYear,
  DisplayCurrency,
  PurOrdNetAmountInDisplayCrcy,
  NrOfPOWithNonCompliantPaytTrm AS NrOfPOInNonCompliantPaytTrms,
  NumberOfPurchaseOrders,
  MinNrOfPOWithNonCompPaytTrm,
  cast( 1 as mm_a_nrof_non_cmplnc_payttrm ) AS NrOfPOWithNonCompliantPaytTrm,
  cast( 1 as mm_a_non_cmplnc_payttrm_pct ) AS POWithNonCompliantPaytTrmPct
FROM C_POWthNonCmplncPaytTrm
;

Learn More