C_PurOrdOutputAutomnRate

DDL: C_PURORDOUTPUTAUTOMNRATE SQL: CMMPOOPAUTOMN Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
26 Fields 1 Data Sources 1 Fiori Apps

PO Output Automn & non Automn percentage

C_PurOrdOutputAutomnRate (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_PurOrdOutputAutomnRate is a Consumption CDS View that provides data about "PO Output Automn & non Automn percentage" in SAP S/4HANA. It reads from 1 data source (C_PurOrdOutputAutomnCube) and exposes 26 fields with key field POOutputMessageItemID. It is used in 1 Fiori application: Purchase Order Output Automation. 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_PurOrdOutputAutomnCube C_PurOrdOutputAutomnCube from

Parameters (3)

NameTypeDefault
P_StartDate vdm_validitystart
P_EndDate vdm_validityend
P_DateFunction datefunctionid

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CMMPOOPAUTOMN view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
Analytics.query true view
OData.publish true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.settings.maxProcessingEffort #MEDIUM view
EndUserText.label PO Output Automn & non Automn percentage view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view

Fiori Apps (1)

App IDApp NameTypeDescription
F4378 Purchase Order Output Automation Analytical You can use this app to analyse the output automation rate for purchase orders.

Purchase Order Output Automation

Business Role: Strategic Buyer

With this app, you can see an overview of the number of purchase order outputs by output channel. Output channels are classified into two groups: automated outputs and manual outputs. Automated outputs include outputs of types EDI and XML. Manual outputs include outputs that are printed or mailed. The default evaluation time frame is from previous year to current date. Only the outputs with Completed status are considered for analysis.

Fields (26)

KeyFieldSource TableSource FieldDescription
resultElementDateFunctionStartDate
resultElementDateFunctionEndDate
P_StartDate
P_EndDatekeyPurchaseOrder Purchase Order
KEY POOutputMessageItemID POOutputMessageItemID ID of an Output Request Item
POOutputChannel POOutputChannel Output Channel
Supplier Supplier Supplier
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CalendarYear CalendarYear Calendar Year
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
CalendarWeek CalendarWeek Calendar Week
POOutputChannelManualUniqueID POOutputChannelManualUniqueID Text field length 14
POOutputChannelAutomnUniqueID POOutputChannelAutomnUniqueID Text field length 14
PurchaseOrderOutputIsAutomated PurchaseOrderOutputIsAutomated Is Automated
NmbrOfPOOutputItems NmbrOfPOOutputItems Count
NmbrOfPurchaseOrdersPrinted NmbrOfPurchaseOrdersPrinted Number of Purchase Orders - Printed
NmbrOfPurchaseOrdersEmailed NmbrOfPurchaseOrdersEmailed Number of Purchase Orders Mailed
NmbrOfPurOrdersOutputAsXML NmbrOfPurOrdersOutputAsXML Number of Purchase Orders with Output as XML
NmbrOfPurOrdersOutputAsIDOC NmbrOfPurOrdersOutputAsIDOC Number of Purchase Orders with Output as IDOC
NmbrOfPurOrdersOutputAsEDI NmbrOfPurOrdersOutputAsEDI Number of Purchase Orders with Output as EDI
NmbrOfPurOrdsWithAutomnOutput No. of POs - Automn
NmbrOfPurOrdsWithNonAutomnOutp No. of POs - Manual
POOutputAutomationPercent POs Auto. Output %
POOutputNonAutomnPercent POs Manual Output %

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_PurOrdOutputAutomnRate.
-- 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: CMMPOOPAUTOMN
-- Parameters: P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend, P_DateFunction : datefunctionid

CREATE VIEW C_PurOrdOutputAutomnRate AS
SELECT
  resultElement: 'DateFunctionStartDate' AS resultElementDateFunctionStartDate,
  resultElement: 'DateFunctionEndDate' AS resultElementDateFunctionEndDate,
  binding: [ { targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' AS P_StartDate,
  POOutputMessageItemID,
  POOutputChannel,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  POOutputChannelManualUniqueID,
  POOutputChannelAutomnUniqueID,
  PurchaseOrderOutputIsAutomated,
  NmbrOfPOOutputItems,
  NmbrOfPurchaseOrdersPrinted,
  NmbrOfPurchaseOrdersEmailed,
  NmbrOfPurOrdersOutputAsXML,
  NmbrOfPurOrdersOutputAsIDOC,
  NmbrOfPurOrdersOutputAsEDI,
  case when POOutputChannelAutomnUniqueID <> ' ' then NmbrOfPurOrdsWithAutomnOutput else 0 end AS NmbrOfPurOrdsWithAutomnOutput,
  case when POOutputChannelManualUniqueID <> ' ' then NmbrOfPurOrdsWithNonAutomnOutp else 0 end AS NmbrOfPurOrdsWithNonAutomnOutp,
  cast( 1 as abap.dec(15,3) ) AS POOutputAutomationPercent,
  cast( 1 as abap.dec(15,3) ) AS POOutputNonAutomnPercent
FROM C_PurOrdOutputAutomnCube
;

Learn More