C_ParkedMCAJournalEntryItm

DDL: C_PARKEDMCAJOURNALENTRYITM SQL: CGLEMCAPARK Type: view CONSUMPTION
38 Fields 1 Data Sources

Parked MCA Journal Entry Item details

C_ParkedMCAJournalEntryItm is a Consumption CDS View (Cube) that provides data about "Parked MCA Journal Entry Item details" in SAP S/4HANA. It reads from 1 data source (I_ParkedMCAJournalEntry) and exposes 38 fields with key fields Ledger, CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_ParkedMCAJournalEntry _Source from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CGLEMCAPARK view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
Analytics.dataCategory #CUBE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.internalName #LOCAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
OData.publish true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Parked MCA Journal Entry Item details view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
MCARunID MCARunID UUID
LedgerGroup LedgerGroup Ledger Group
MCAFileID MCAFileID File ID
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountCurrency AccountCurrency Transaction Currency
PurchasingDocumentAmount PurchasingDocumentAmount Gross Amount
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TransactionAmountInLocalCrcy TransactionAmountInLocalCrcy Loc. amount
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
ParkedByUser ParkedByUser Parked_By
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
Segment Segment Segment number
TradingPartner TradingPartner Trading Partner
PostingKey PostingKey Posting Key
DocumentDate DocumentDate Document date
PostingDate PostingDate Posting Date
FiscalMonth FiscalMonth Period Block
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
MarketDataExchangeRate MarketDataExchangeRate
DocumentReferenceID DocumentReferenceID Reference
PlannedReversalDate PlannedReversalDate Planned reversal date
ReversalReason ReversalReason Reversal Reason
GLAccount GLAccount General Ledger
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerSegment PartnerSegment Partner Segment
ValueDate ValueDate Value Date
DocumentItemText DocumentItemText Text
AssignmentReference AssignmentReference Assignment Reference
TotalCount Total Record

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_ParkedMCAJournalEntryItm.
-- 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: CGLEMCAPARK

CREATE VIEW C_ParkedMCAJournalEntryItm AS
SELECT
  Ledger,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  MCARunID,
  LedgerGroup,
  MCAFileID,
  AccountingDocumentType,
  AccountCurrency,
  PurchasingDocumentAmount,
  CompanyCodeCurrency,
  TransactionAmountInLocalCrcy,
  AdditionalCurrency1,
  AmountInAdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  ParkedByUser,
  ProfitCenter,
  CostCenter,
  Segment,
  TradingPartner,
  PostingKey,
  DocumentDate,
  PostingDate,
  FiscalMonth,
  AccountingDocumentHeaderText,
  MarketDataExchangeRate,
  DocumentReferenceID,
  PlannedReversalDate,
  ReversalReason,
  GLAccount,
  PartnerProfitCenter,
  PartnerSegment,
  ValueDate,
  DocumentItemText,
  AssignmentReference,
  cast( '1' as int4 ) AS TotalCount
FROM I_ParkedMCAJournalEntry AS _Source
;

Learn More