C_PostedMCAJournalEntryItm

DDL: C_POSTEDMCAJOURNALENTRYITM SQL: CGLEMCAPOST Type: view CONSUMPTION Package: FAGL_MCA_AL_GEN
39 Fields 1 Data Sources

Posted MCA Journal Entry Item details

C_PostedMCAJournalEntryItm is a Consumption CDS View (Cube) that provides data about "Posted MCA Journal Entry Item details" in SAP S/4HANA. It reads from 1 data source (I_PostedMCAJournalEntry) and exposes 39 fields with key fields Ledger, CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package FAGL_MCA_AL_GEN.

Data Sources (1)

SourceAliasJoin Type
I_PostedMCAJournalEntry _Source from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CGLEMCAPOST 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 Posted MCA Journal Entry Item details view

Fields (39)

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
ApprovedByUser ApprovedByUser Approved_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_PostedMCAJournalEntryItm.
-- 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: CGLEMCAPOST

CREATE VIEW C_PostedMCAJournalEntryItm AS
SELECT
  Ledger,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  MCARunID,
  LedgerGroup,
  MCAFileID,
  AccountingDocumentType,
  AccountCurrency,
  PurchasingDocumentAmount,
  CompanyCodeCurrency,
  TransactionAmountInLocalCrcy,
  AdditionalCurrency1,
  AmountInAdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  ParkedByUser,
  ApprovedByUser,
  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_PostedMCAJournalEntry AS _Source
;

Learn More