P_ProjActlPlnJrnlEntrItm

DDL: P_PROJACTLPLNJRNLENTRITM SQL: PPRJACTPLNJITM Type: view COMPOSITE Package: ODATA_PS_COS_PROJCOSTLINEITEM
96 Fields 4 Data Sources 1 Associations

Project Actual Plan Journal Entry Items

P_ProjActlPlnJrnlEntrItm is a Composite CDS View that provides data about "Project Actual Plan Journal Entry Items" in SAP S/4HANA. It reads from 4 data sources (P_SEMTAGVERMAP, I_ControllingArea, I_ActualPlanJournalEntryItem, R_ProjectSemTagGLAccount) and exposes 96 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views. Part of development package ODATA_PS_COS_PROJCOSTLINEITEM.

Data Sources (4)

SourceAliasJoin Type
P_SEMTAGVERMAP _ChildTag inner
I_ControllingArea _ContArea inner
I_ActualPlanJournalEntryItem _ProjCstLineItm from
R_ProjectSemTagGLAccount _SemTagGL inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FiscalPeriodForVariant _FiscalPeriod _FiscalPeriod.FiscalYear = $projection.LedgerFiscalYear and _FiscalPeriod.FiscalPeriod = $projection.FiscalPeriod and _FiscalPeriod.FiscalYearVariant = $projection.FiscalYearVariant

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPRJACTPLNJITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (96)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY Ledger Ledger Ledger
KEY CompanyCode I_ActualPlanJournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket Data packet number
KEY ActualPlanJournalEntryItem ActualPlanJournalEntryItem
LedgerFiscalYear LedgerFiscalYear
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
FinancialPlanningEntryItem FinancialPlanningEntryItem
GLAccount I_ActualPlanJournalEntryItem GLAccount General Ledger
ChartOfAccounts I_ActualPlanJournalEntryItem ChartOfAccounts Node Class
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
GLAccountHierarchy R_ProjectSemTagGLAccount GLAccountHierarchy
BusinessArea BusinessArea Business Area
CostCenter I_ActualPlanJournalEntryItem CostCenter Cost Center
PartnerOrder I_ActualPlanJournalEntryItem PartnerOrder_2
PartnerOrderCategory PartnerOrderCategory
PartnerWBSElement I_ActualPlanJournalEntryItem PartnerWBSElementExternalID Partner WBSElmnt ext
PartnerProject I_ActualPlanJournalEntryItem PartnerProjectExternalID Partner Project External ID
BusinessTransactionType BusinessTransactionType Bus.transaction
DebitCreditCode DebitCreditCode Single-Character Flag
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
ProfitCenter I_ActualPlanJournalEntryItem ProfitCenter Profit Center
WBSElementProfitCenter
WBSDescription
ProjectObjectNode
WBSElementCoCode
SemanticTag R_ProjectSemTagGLAccount SemanticTag Semantic Tag
WBSElement I_ActualPlanJournalEntryItem WBSElementExternalID WBS Element External ID
ResponsibleCostCenter
ControllingArea I_ActualPlanJournalEntryItem ControllingArea Controlling Area
Project I_ActualPlanJournalEntryItem ProjectExternalID Project def.
ProjectInternalID I_ActualPlanJournalEntryItem ProjectInternalID Project Def.
ProjectDescription
ProjectProfileCode
ProjectObject
AvailabilityControlProfile
AvailabilityControlIsActive
AvailyCtrlTimeRangeType
BudgetCurrencyRole
WBSElementInternalID I_ActualPlanJournalEntryItem WBSElementInternalID WBS Internal ID
CreationDate CreationDate Time Stamp
FunctionalArea I_ActualPlanJournalEntryItem FunctionalArea Sendr Fctl Area
CostCtrActivityType CostCtrActivityType Activity Type
OrderID OrderID Order ID
OrderOperation OrderOperation Operation or Phase
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
PlanningCategory I_ActualPlanJournalEntryItem PlanningCategory Plan Category
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant I_ActualPlanJournalEntryItem FiscalYearVariant FY Variant
PartnerSalesDocument PartnerSalesDocument Partner Sales Doc.
PartnerProjectNetwork PartnerProjectNetwork Part. Proj. Network
PartnerProjectNetworkActivity PartnerProjectNetworkActivity Partner Project Network Activity
PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
PartnerCostObject PartnerCostObject Partner Cost Object
SourceReferenceDocumentType SourceReferenceDocumentType Ref. procedure
SourceLogicalSystem SourceLogicalSystem
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt
SourceReferenceDocument SourceReferenceDocument Reference Doc.
SourceReferenceDocumentItem SourceReferenceDocumentItem Ref. Doc. Item
SourceReferenceDocSubitem SourceReferenceDocSubitem
IsCommitment IsCommitment
_ProjectBasicData _ProjectBasicData
CtrlgStdFinStatementVersion I_ControllingArea CtrlgStdFinStatementVersion
_FiscalPeriod _FiscalPeriod
IsLeadingLedger _Ledger IsLeadingLedger
_MaintenanceOrder I_ActualPlanJournalEntryItem _MaintenanceOrder
_MaintenanceOrderOperation I_ActualPlanJournalEntryItem _MaintenanceOrderOperation

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_ProjActlPlnJrnlEntrItm.
-- 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: PPRJACTPLNJITM

CREATE VIEW P_ProjActlPlnJrnlEntrItm AS
SELECT
  SourceLedger,
  Ledger,
  _ProjCstLineItm.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  ActualPlanJournalEntryItem,
  LedgerFiscalYear,
  LedgerGLLineItem,
  FinancialPlanningEntryItem,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  AccountingDocCreatedByUser,
  _SemTagGL.GLAccountHierarchy AS GLAccountHierarchy,
  BusinessArea,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.PartnerOrder_2 AS PartnerOrder,
  PartnerOrderCategory,
  _ProjCstLineItm.PartnerWBSElementExternalID AS PartnerWBSElement,
  _ProjCstLineItm.PartnerProjectExternalID AS PartnerProject,
  BusinessTransactionType,
  DebitCreditCode,
  ControllingDebitCreditCode,
  _ProjCstLineItm.ProfitCenter AS ProfitCenter,
  '' AS WBSElementProfitCenter,
  '' AS WBSDescription,
  '' AS ProjectObjectNode,
  '' AS WBSElementCoCode,
  _SemTagGL.SemanticTag AS SemanticTag,
  _ProjCstLineItm.WBSElementExternalID AS WBSElement,
  '' AS ResponsibleCostCenter,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm.ProjectExternalID AS Project,
  _ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  '' AS ProjectDescription,
  '' AS ProjectProfileCode,
  '' AS ProjectObject,
  '' AS AvailabilityControlProfile,
  '' AS AvailabilityControlIsActive,
  '' AS AvailyCtrlTimeRangeType,
  '' AS BudgetCurrencyRole,
  _ProjCstLineItm.WBSElementInternalID AS WBSElementInternalID,
  CreationDate,
  _ProjCstLineItm.FunctionalArea AS FunctionalArea,
  CostCtrActivityType,
  OrderID,
  OrderOperation,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  _ProjCstLineItm.PlanningCategory AS PlanningCategory,
  PostingDate,
  DocumentDate,
  FiscalPeriod,
  FiscalYearPeriod,
  _ProjCstLineItm.FiscalYearVariant AS FiscalYearVariant,
  PartnerSalesDocument,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  _ContArea.CtrlgStdFinStatementVersion AS CtrlgStdFinStatementVersion,
  _Ledger.IsLeadingLedger AS IsLeadingLedger,
  _ProjCstLineItm._MaintenanceOrder AS _MaintenanceOrder,
  _ProjCstLineItm._MaintenanceOrderOperation AS _MaintenanceOrderOperation
FROM I_ActualPlanJournalEntryItem AS _ProjCstLineItm
INNER JOIN I_ControllingArea AS _ContArea ON /* join condition not captured in parsed metadata */
INNER JOIN R_ProjectSemTagGLAccount AS _SemTagGL ON /* join condition not captured in parsed metadata */
INNER JOIN P_SEMTAGVERMAP AS _ChildTag ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriod ON _FiscalPeriod.FiscalYear = LedgerFiscalYear AND _FiscalPeriod.FiscalPeriod = FiscalPeriod AND _FiscalPeriod.FiscalYearVariant = FiscalYearVariant  -- association [0..1]
;

Learn More