C_MstrProjJournalQ001

DDL: C_MSTRPROJJOURNALQ001 SQL: CMPJRNLQ001 Type: view CONSUMPTION
45 Fields 1 Data Sources

Master Project Journal Query

C_MstrProjJournalQ001 is a Consumption CDS View that provides data about "Master Project Journal Query" in SAP S/4HANA. It reads from 1 data source (I_MPJournalEntryItemCube) and exposes 45 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
I_MPJournalEntryItemCube I_MPJournalEntryItemCube from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMPJRNLQ001 view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Master Project Journal Query view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.settings.maxProcessingEffort #HIGH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (45)

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
FiscalPeriod FiscalPeriod Tax period
WBSElement WBSElement WBS Internal ID
ProjectNetwork ProjectNetwork Order
RelatedNetworkActivity RelatedNetworkActivity Netwk activity
Material Material Vehicle Model
ControllingObject ControllingObject Object number
CostCtrActivityType CostCtrActivityType Activity Type
GLAccount GLAccount General Ledger
ReferenceDocument ReferenceDocument Reference Document
DocumentDate DocumentDate Journal Entry Date
BaseUnit BaseUnit Unit of Measure
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
Quantity Quantity Value
BusinessTransactionType BusinessTransactionType Bus.transaction
Segment Segment Segment number
BusinessArea BusinessArea Business Area
FinancialAccountType FinancialAccountType Fin. Account Type
PostingDate PostingDate Posting Date for GR
ReferenceDocumentItem ReferenceDocumentItem Reference item
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
FixedQuantity FixedQuantity Fixed Quantity
ValuationQuantity ValuationQuantity
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
DocumentItemText DocumentItemText Text
PersonnelNumber PersonnelNumber Personnel No.
AccountAssignment AccountAssignment Sender Acct Assgmt
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
OrderID OrderID Order ID
OrderCategory OrderCategory Order Category
BillingDocumentType BillingDocumentType Billing Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
_TransactionCurrency _TransactionCurrency

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_MstrProjJournalQ001.
-- 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: CMPJRNLQ001

CREATE VIEW C_MstrProjJournalQ001 AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FiscalPeriod,
  WBSElement,
  ProjectNetwork,
  RelatedNetworkActivity,
  Material,
  ControllingObject,
  CostCtrActivityType,
  GLAccount,
  ReferenceDocument,
  DocumentDate,
  BaseUnit,
  AccountingDocCreatedByUser,
  TransactionCurrency,
  AmountInTransactionCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  Quantity,
  BusinessTransactionType,
  Segment,
  BusinessArea,
  FinancialAccountType,
  PostingDate,
  ReferenceDocumentItem,
  CostCenter,
  ControllingArea,
  PartnerCostCenter,
  FixedQuantity,
  ValuationQuantity,
  PurchasingDocument,
  PurchasingDocumentItem,
  DocumentItemText,
  PersonnelNumber,
  AccountAssignment,
  AccountAssignmentType,
  OrderID,
  OrderCategory,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision
FROM I_MPJournalEntryItemCube
;

Learn More