P_PCCEvtBsdWIPVarc

DDL: P_PCCEVTBSDWIPVARC SQL: PPCCEBWIPVRC Type: view COMPOSITE Package: FINS_PCC_RTPC_REM
13 Fields 2 Data Sources

WIP and Variance for Event-Based PCC

P_PCCEvtBsdWIPVarc is a Composite CDS View that provides data about "WIP and Variance for Event-Based PCC" in SAP S/4HANA. It reads from 2 data sources (P_RTPC_PCC_OrderBasic, I_LedgerCompanyCodeCrcyRolesVH) and exposes 13 fields with key fields Ledger, CompanyCode, OrderID, OrderType, OrderCategory. Part of development package FINS_PCC_RTPC_REM.

Data Sources (2)

SourceAliasJoin Type
P_RTPC_PCC_OrderBasic _EvtBsdOrderAndItem from
I_LedgerCompanyCodeCrcyRolesVH _LdgrCompCodeCrcy inner

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fac_crcyrole

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPCCEBWIPVRC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Ledger
KEY CompanyCode P_RTPC_PCC_OrderBasic CompanyCode Receiver Company Code
KEY OrderID P_RTPC_PCC_OrderBasic OrderID Order ID
KEY OrderType P_RTPC_PCC_OrderBasic OrderType Order Type
KEY OrderCategory P_RTPC_PCC_OrderBasic OrderCategory Order Category
KEY ChartOfAccounts _WIPVariance ChartOfAccounts Node Class
KEY GLAccount _WIPVariance GLAccount General Ledger
KEY Plant P_RTPC_PCC_OrderBasic Plant Valuation Area
KEY ProducedProduct P_RTPC_PCC_OrderBasic Material Vehicle Model
KEY OriginProduct _WIPVariance OriginProduct
KEY OriginCostCenter _WIPVariance OriginCostCenter
KEY OriginCostCtrActivityType _WIPVariance OriginCostCtrActivityType
DisplayCurrency I_LedgerCompanyCodeCrcyRolesVH Currency Valuation Crcy

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_PCCEvtBsdWIPVarc.
-- 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: PPCCEBWIPVRC
-- Parameters: P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_CurrencyRole : fac_crcyrole

CREATE VIEW P_PCCEvtBsdWIPVarc AS
SELECT
  cast(:P_Ledger as fins_ledger preserving type) AS Ledger,
  _EvtBsdOrderAndItem.CompanyCode AS CompanyCode,
  _EvtBsdOrderAndItem.OrderID AS OrderID,
  _EvtBsdOrderAndItem.OrderType AS OrderType,
  _EvtBsdOrderAndItem.OrderCategory AS OrderCategory,
  _WIPVariance.ChartOfAccounts AS ChartOfAccounts,
  _WIPVariance.GLAccount AS GLAccount,
  _EvtBsdOrderAndItem.Plant AS Plant,
  _EvtBsdOrderAndItem.Material AS ProducedProduct,
  _WIPVariance.OriginProduct AS OriginProduct,
  _WIPVariance.OriginCostCenter AS OriginCostCenter,
  _WIPVariance.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _LdgrCompCodeCrcy.Currency AS DisplayCurrency
FROM P_RTPC_PCC_OrderBasic AS _EvtBsdOrderAndItem
INNER JOIN I_LedgerCompanyCodeCrcyRolesVH AS _LdgrCompCodeCrcy ON /* join condition not captured in parsed metadata */
;

Learn More