P_EBASO_CostUnion_F3

DDL: P_EBASO_COSTUNION_F3 Type: view_entity COMPOSITE Package: ODATA_CO_EB_ANALYZE_SUM_OBJECT
138 Fields 4 Data Sources

Event-Based Analyze Summarization Object - Cost Union - F3

P_EBASO_CostUnion_F3 is a Composite CDS View that provides data about "Event-Based Analyze Summarization Object - Cost Union - F3" in SAP S/4HANA. It reads from 4 data sources (P_EBASO_ActualCost1, P_EBASO_EvtBsdVariance1, P_EBASO_OrderPlanCost1, P_EBASO_WIP1) and exposes 138 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package ODATA_CO_EB_ANALYZE_SUM_OBJECT.

Data Sources (4)

SourceAliasJoin Type
P_EBASO_ActualCost1 P_EBASO_ActualCost1 from
P_EBASO_EvtBsdVariance1 P_EBASO_EvtBsdVariance1 union_all
P_EBASO_OrderPlanCost1 P_EBASO_OrderPlanCost1 union_all
P_EBASO_WIP1 P_EBASO_WIP1 union_all

Parameters (3)

NameTypeDefault
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper
P_Ledger fins_ledger

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (138)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem
KEY ControllingValueType ControllingValueType
Plant Plant Valuation Area
CostElement CostElement G/L Account
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
OrderID OrderID Order ID
OrderItem OrderItem
PartnerAccountAssignment PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
PartnerOrder PartnerOrder Partner Order
CtrlgOriginClassification
UnitOfMeasure UnitOfMeasure Unit Protected Qty
Material Material Vehicle Model
CostOriginGroup CostOriginGroup Origin Group
ControllingArea ControllingArea Controlling Area
SubLedgerAcctLineItemType SLALineItemType
IsLotSizeIndependent
OriginCostCenter OriginCostCenter
OriginCostCtrActivityType OriginCostCtrActivityType
DisplayCurrency FreeDefinedCurrency3 Freely Defined Currency 3
AmountInDisplayCurrency AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
P_FromFiscalYearPeriod
P_ToFiscalYearPeriod
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear G/L Fiscal Year
KEY AccountingDocument Journal Entry
KEY LedgerGLLineItem Journal Entry Item
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem
KEY ControllingValueType ControllingValueType
Plant Plant Valuation Area
CostElement CostElement G/L Account
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
OrderID OrderID Order ID
OrderItem OrderItem
PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerBusinessProcess Part. Bus. Process
PartnerOrder PartnerOrder Partner Order
CtrlgOriginClassification CtrlgOriginClassification
UnitOfMeasure UnitOfMeasure Unit Protected Qty
Material Material Vehicle Model
CostOriginGroup CostOriginGroup Origin Group
ControllingArea ControllingArea Controlling Area
SubLedgerAcctLineItemType SLALineItemType
IsLotSizeIndependent IsLotSizeIndependent
OriginCostCenter OriginCostCenter
OriginCostCtrActivityType OriginCostCtrActivityType
DisplayCurrency FreeDefinedCurrency3 Freely Defined Currency 3
AmountInDisplayCurrency AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
P_FromFiscalYearPeriod
P_ToFiscalYearPeriod
P_LedgerkeyLedger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem
KEY ControllingValueType ControllingValueType
Plant Valuation Area
CostElement CostElement G/L Account
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
OrderID OrderID Order ID
OrderItem OrderItem
PartnerAccountAssignment PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
PartnerOrder PartnerOrder Partner Order
CtrlgOriginClassification CtrlgOriginClassification
UnitOfMeasure UnitOfMeasure Unit Protected Qty
Material Vehicle Model
CostOriginGroup Origin Group
ControllingArea ControllingArea Controlling Area
SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
IsLotSizeIndependent
OriginCostCenter OriginCostCenter
OriginCostCtrActivityType OriginCostCtrActivityType
DisplayCurrency FreeDefinedCurrency3 Freely Defined Currency 3
AmountInDisplayCurrency AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
P_FromFiscalYearPeriod
P_ToFiscalYearPeriod
P_LedgerkeyLedger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem
KEY ControllingValueType ControllingValueType
Plant Plant Valuation Area
CostElement CostElement G/L Account
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
OrderID OrderID Order ID
OrderItem OrderItem
PartnerAccountAssignment PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
PartnerOrder PartnerOrder Partner Order
CtrlgOriginClassification CtrlgOriginClassification
UnitOfMeasure UnitOfMeasure Unit Protected Qty
Material Material Vehicle Model
CostOriginGroup CostOriginGroup Origin Group
ControllingArea ControllingArea Controlling Area
SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
IsLotSizeIndependent IsLotSizeIndependent
OriginCostCenter OriginCostCenter
OriginCostCtrActivityType OriginCostCtrActivityType
DisplayCurrency FreeDefinedCurrency3 Freely Defined Currency 3
AmountInDisplayCurrency AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
TotalQuantity

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_EBASO_CostUnion_F3.
-- 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_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_Ledger : fins_ledger

CREATE VIEW P_EBASO_CostUnion_F3 AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  cast('00000000000000000000000' as fis_fp_request_tsn) AS FinancialPlanningReqTransSqnc,
  cast('000000' as fis_fp_data_packet) AS FinancialPlanningDataPacket,
  cast('0000000000' as fis_fp_entry_item_no_sign) AS FinancialPlanningEntryItem,
  ControllingValueType,
  Plant,
  CostElement,
  BusinessTransactionCategory,
  ControllingDebitCreditCode,
  AccountAssignmentType,
  OrderID,
  OrderItem,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerBusinessProcess,
  PartnerOrder,
  'A' AS CtrlgOriginClassification,
  UnitOfMeasure,
  Material,
  CostOriginGroup,
  ControllingArea,
  cast('00000' as slalittype) AS SubLedgerAcctLineItemType,
  cast('' as fco_psknz) AS IsLotSizeIndependent,
  OriginCostCenter,
  OriginCostCtrActivityType,
  FreeDefinedCurrency3 AS DisplayCurrency,
  AmountInFreeDefinedCurrency3 AS AmountInDisplayCurrency,
  Quantity as TotalQuantity AS P_FromFiscalYearPeriod,
  P_ToFiscalYearPeriod : $parameters.P_ToFiscalYearPeriod AS P_ToFiscalYearPeriod,
  cast(0 as quan1_12 ) AS TotalQuantity
FROM P_EBASO_ActualCost1
-- UNION ALL with additional select branch(es): P_EBASO_OrderPlanCost1, P_EBASO_WIP1, P_EBASO_EvtBsdVariance1
;

Learn More