P_FINCLOSINGMDCPOSTING

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_FINCLOSINGMDCPOSTING.
-- 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_fiscal_year_period : fiscalyearperiod

CREATE VIEW P_FINCLOSINGMDCPOSTING AS
SELECT
  acdoca.CompanyCode AS CompanyCode,
  acdoca.FiscalYear AS FiscalYear,
  acdoca.AccountingDocument AS AccountingDocument,
  acdoca.LedgerGLLineItem AS LedgerGLLineItem,
  acdoca.Ledger AS Ledger,
  acdoca.SourceLedger AS SourceLedger,
  acdoca.AccountingDocumentItem AS AccountingDocumentItem,
  acdoca.DebitCreditCode AS DebitCreditCode,
  acdoca.ClearingAccountingDocument AS ClearingAccountingDocument,
  acdoca.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  acdoca.ClearingDate AS ClearingDate,
  acdoca.NetDueDate AS NetDueDate,
  acdoca.ChartOfAccounts AS ChartOfAccounts,
  acdoca.OffsettingAccount AS GLAccount,
  acdoca.GLAccount AS MASTERDATARECNCLNACCT,
  acdoca.PartnerCompany AS MASTERDATAPARTNERCOMPANY,
  _mdc_rl.OldTradingPartner AS PartnerCompany,
  _mdc_rl.SpecialGLCode AS SpecialGLCode,
  acdoca.TAGGEDACCOUNT AS TAGGEDACCOUNT,
  acdoca.GLRecordType AS GLRecordType,
  acdoca.CreationDateTime AS CreationDateTime,
  acdoca.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  acdoca.PostingDate AS PostingDate,
  acdoca.OriginalPostingDate AS OriginalPostingDate,
  acdoca.AccountingDocumentCategory AS AccountingDocumentCategory,
  acdoca.LedgerFiscalYear AS LedgerFiscalYear,
  acdoca.ReferenceDocumentType AS ReferenceDocumentType,
  acdoca.FiscalYearPeriod AS FiscalYearPeriod,
  acdoca.BusinessTransactionCategory AS BusinessTransactionCategory,
  acdoca.IsOpenItemManaged AS IsOpenItemManaged,
  acdoca.IsReversal AS IsReversal,
  acdoca.IsReversed AS IsReversed,
  acdoca.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  acdoca.CompanyCodeCurrency AS CompanyCodeCurrency,
  acdoca.GlobalCurrency AS GlobalCurrency,
  acdoca.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  acdoca.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  acdoca.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  acdoca.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  acdoca.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  acdoca.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  acdoca.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  acdoca.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  acdoca.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  acdoca.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  acdoca.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  acdoca.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  acdoca.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  acdoca.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  acdoca.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  acdoca.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  acdoca.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  acdoca.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  acdoca.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  acdoca.ISCLEAREDATKEYDATE AS ISCLEAREDATKEYDATE,
  acdoca.GLAccountType AS GLAccountType,
  acdoca.FinancialAccountType AS FinancialAccountType,
  acdoca.AssignmentReference AS AssignmentReference,
  acdoca.CUSTOMER_SUPPLIER_GROUP_KEY AS CUSTOMER_SUPPLIER_GROUP_KEY,
  acdoca.FiscalPeriod AS FiscalPeriod,
  acdoca.WBSElement AS WBSElement,
  acdoca.TaxCode AS TaxCode,
  acdoca.TaxCountry AS TaxCountry,
  acdoca.HouseBank AS HouseBank,
  acdoca.HouseBankAccount AS HouseBankAccount,
  acdoca.CostCtrActivityType AS CostCtrActivityType,
  acdoca.WBSElementInternalID AS WBSElementInternalID,
  acdoca.FinancialTransactionType AS FinancialTransactionType,
  acdoca.JointVenture AS JointVenture,
  acdoca.JointVentureEquityGroup AS JointVentureEquityGroup,
  acdoca.JointVentureEquityType AS JointVentureEquityType,
  acdoca.PartnerVenture AS PartnerVenture,
  acdoca.JointVenturePartner AS JointVenturePartner,
  acdoca.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  acdoca.ProjectNetwork AS ProjectNetwork,
  acdoca.RelatedNetworkActivity AS RelatedNetworkActivity,
  acdoca.OrderID AS OrderID,
  acdoca.BusinessProcess AS BusinessProcess,
  acdoca.SalesOrder AS SalesOrder,
  acdoca.SalesOrderItem AS SalesOrderItem,
  acdoca.CostObject AS CostObject,
  acdoca.CostCenter AS CostCenter,
  acdoca.ProfitCenter AS ProfitCenter,
  acdoca.FunctionalArea AS FunctionalArea,
  acdoca.BusinessArea AS BusinessArea,
  acdoca.ControllingArea AS ControllingArea,
  acdoca.Segment AS Segment,
  acdoca.PartnerCostCenter AS PartnerCostCenter,
  acdoca.PartnerProfitCenter AS PartnerProfitCenter,
  acdoca.PartnerFunctionalArea AS PartnerFunctionalArea,
  acdoca.PartnerBusinessArea AS PartnerBusinessArea,
  acdoca.PartnerSegment AS PartnerSegment,
  acdoca.Supplier AS Supplier,
  acdoca.Customer AS Customer,
  acdoca.FinancialValuationObjectType AS FinancialValuationObjectType,
  acdoca.FinancialValuationObject AS FinancialValuationObject,
  acdoca.FinancialValuationSubobject AS FinancialValuationSubobject,
  acdoca.REBusinessEntity AS REBusinessEntity,
  acdoca.RealEstateBuilding AS RealEstateBuilding,
  acdoca.RealEstateProperty AS RealEstateProperty,
  acdoca.Fund AS Fund,
  acdoca.BudgetPeriod AS BudgetPeriod,
  acdoca.GrantID AS GrantID,
  acdoca.PubSecBudgetAccount AS PubSecBudgetAccount,
  acdoca.CashLedgerAccount AS CashLedgerAccount,
  acdoca.SponsoredProgram AS SponsoredProgram,
  acdoca.SponsoredClass AS SponsoredClass,
  acdoca.Plant AS Plant,
  acdoca.Product AS Product,
  acdoca.ShipToParty AS ShipToParty,
  acdoca.PartnerFund AS PartnerFund,
  acdoca.PartnerGrant AS PartnerGrant,
  acdoca.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  acdoca.FundsCenter AS FundsCenter,
  acdoca.PartnerEquityGroup AS PartnerEquityGroup,
  acdoca.FundedProgram AS FundedProgram,
  acdoca.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  acdoca.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  acdoca.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  acdoca.PredecessorJournalEntry AS PredecessorJournalEntry,
  acdoca.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  acdoca.BusinessPartner AS BusinessPartner,
  acdoca.CreditRiskClass AS CreditRiskClass,
  acdoca.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  acdoca.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  acdoca.AccrualObjectType AS AccrualObjectType,
  acdoca.AccrualObject AS AccrualObject,
  acdoca.AccrualSubobject AS AccrualSubobject,
  acdoca.AccrualItemType AS AccrualItemType,
  acdoca.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  acdoca.AccrualReferenceObject AS AccrualReferenceObject,
  acdoca.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  acdoca.ServiceDocument AS ServiceDocument,
  acdoca.ServiceDocumentItem AS ServiceDocumentItem,
  acdoca.ServiceDocumentType AS ServiceDocumentType,
  acdoca.Material AS Material
FROM P_ValuationRunAccountLineItem
INNER JOIN R_MstrDtaChgRunRsltListItm AS _mdc_rl ON /* join condition not captured in parsed metadata */
;