C_EvtBsdNotJntProdnVariance

DDL: C_EVTBSDNOTJNTPRODNVARIANCE Type: view CONSUMPTION
33 Fields 1 Data Sources

Event-Based Production Accounting Non Joint Prodn Variance

C_EvtBsdNotJntProdnVariance is a Consumption CDS View that provides data about "Event-Based Production Accounting Non Joint Prodn Variance" in SAP S/4HANA. It reads from 1 data source (P_EBPAO_NonJntProdnVariance) and exposes 33 fields with key fields Ledger, CompanyCode, OrderID, OrderItem, OrderType.

Data Sources (1)

SourceAliasJoin Type
P_EBPAO_NonJntProdnVariance P_EBPAO_NonJntProdnVariance from

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fac_crcyrole

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CEBPAOVAR view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Event-Based Production Accounting Non Joint Prodn Variance view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY OrderID OrderID Order ID
KEY OrderItem OrderItem
KEY OrderType OrderType Order Type
KEY OrderCategory OrderCategory Order Category
KEY ControllingArea ControllingArea Controlling Area
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
KEY ProfitCenter ProfitCenter Profit Center
KEY Product Product Product Sold
KEY ProductGroup ProductGroup Product Sold Group
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
DisplayCurrency
InptPrVarcAmtInDspCrcy InptPrVarcAmtInDspCrcy
InptQtyVarcAmtInDspCrcy InptQtyVarcAmtInDspCrcy
RsceUsgeVarcAmtInDspCrcy RsceUsgeVarcAmtInDspCrcy
ScrapVarcAmtInDspCrcy ScrapVarcAmtInDspCrcy
MixedPrVarcAmtInDspCrcy MixedPrVarcAmtInDspCrcy
OutpPrVarcAmtInDspCrcy OutpPrVarcAmtInDspCrcy
LotSizeVarcAmtInDspCrcy LotSizeVarcAmtInDspCrcy
RmngVarcAmtInDspCrcy RmngVarcAmtInDspCrcy
NonSplitVarcAmtInDspCrcy NonSplitVarcAmtInDspCrcy
CostVarianceInDspCrcy CostVarianceInDspCrcy
AbsltTotCostVarcAmtInDspCrcy AbsltTotCostVarcAmtInDspCrcy
AbsltTotCostVarcName
MaxVarianceAmtInDspCrcy
MaximumVarianceName
_Plant _Plant
_ProductGroupText _ProductGroupText
_ProductText _ProductText
_ProfitCenterText _ProfitCenterText
_StorageLocation _StorageLocation

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

CREATE VIEW C_EvtBsdNotJntProdnVariance AS
SELECT
  Ledger,
  CompanyCode,
  OrderID,
  OrderItem,
  OrderType,
  OrderCategory,
  ControllingArea,
  Plant,
  StorageLocation,
  ProfitCenter,
  Product,
  ProductGroup,
  SubLedgerAcctLineItemType,
  cast('' as waers) AS DisplayCurrency,
  InptPrVarcAmtInDspCrcy,
  InptQtyVarcAmtInDspCrcy,
  RsceUsgeVarcAmtInDspCrcy,
  ScrapVarcAmtInDspCrcy,
  MixedPrVarcAmtInDspCrcy,
  OutpPrVarcAmtInDspCrcy,
  LotSizeVarcAmtInDspCrcy,
  RmngVarcAmtInDspCrcy,
  NonSplitVarcAmtInDspCrcy,
  CostVarianceInDspCrcy,
  AbsltTotCostVarcAmtInDspCrcy,
  cast( '' as fco_eb_abstotvarcam_name ) AS AbsltTotCostVarcName,
  cast( 0 as fco_eb_maxvarcamt_in_dspcrcy ) AS MaxVarianceAmtInDspCrcy,
  cast( '' as fco_eb_maxvarcamt_name ) AS MaximumVarianceName
FROM P_EBPAO_NonJntProdnVariance
;

Learn More