P_PCCOrderGeneralInformation

DDL: P_PCCORDERGENERALINFORMATION SQL: PFIPCCORDGENINFO Type: view COMPOSITE
11 Fields 1 Data Sources

P_PCCOrderGeneralInformation is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ProductCostCtrlgOrder) and exposes 11 fields with key field OrderID.

Data Sources (1)

SourceAliasJoin Type
I_ProductCostCtrlgOrder _Order from

Parameters (4)

NameTypeDefault
P_OrderID fis_order_number
P_OrderItem char4
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFIPCCORDGENINFO view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_ProductCostCtrlgOrder OrderID Order ID
OrderDescription OrderDescription
OrderType OrderType Order Type
OrderCategory OrderCategory Order Category
Plant Plant Valuation Area
Material _RepresentativeOrderItem Material Vehicle Model
ActualCostsCostingVariant ActualCostsCostingVariant Act. Costing Variant
ControllingObjectCurrency Currency Valuation Crcy
ControllingArea ControllingArea Controlling Area
ActlCostInGlobalCrcy
ActlCostInObjCrcy

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_PCCOrderGeneralInformation.
-- 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: PFIPCCORDGENINFO
-- Parameters: P_OrderID : fis_order_number, P_OrderItem : char4, P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper

CREATE VIEW P_PCCOrderGeneralInformation AS
SELECT
  _Order.OrderID AS OrderID,
  OrderDescription,
  OrderType,
  OrderCategory,
  Plant,
  _RepresentativeOrderItem.Material AS Material,
  ActualCostsCostingVariant,
  Currency AS ControllingObjectCurrency,
  ControllingArea,
  CreditActlCostInGlobalCrcy + DebitActlCostInGlobalCrcy AS ActlCostInGlobalCrcy,
  CreditActlCostInObjCrcy + DebitActlCostInObjCrcy AS ActlCostInObjCrcy
FROM I_ProductCostCtrlgOrder AS _Order
;

Learn More