ValuationValuationItems

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 ValuationValuationItems.
-- 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: VALVALUATION
-- Parameters: p_fiscal_year_period : fiscalyearperiod

CREATE VIEW ValuationValuationItems AS
SELECT
  acdoca.SourceLedger AS SourceLedger,
  acdoca.CompanyCode AS CompanyCode,
  acdoca.FiscalYear AS FiscalYear,
  acdoca.AccountingDocument AS AccountingDocument,
  acdoca.LedgerGLLineItem AS LedgerGLLineItem,
  acdoca.Ledger AS Ledger,
  acdoca.GLAccount AS GLAccount,
  wl.netduedate AS netduedate,
  wl.group_id AS group_id,
  acdoca.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  acdoca.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  acdoca.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  acdoca.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  acdoca.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  acdoca.PredecessorJournalEntry AS PredecessorJournalEntry,
  acdoca.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  acdoca.CreditRiskClass AS CreditRiskClass,
  acdoca.CreationDateTime AS CreationDateTime,
  wl.postingdate AS postingdate,
  wl.documentdate AS DocumentDate,
  acdoca.PostingDate AS OriginalPostingDate,
  acdoca.FiscalYearPeriod AS FiscalYearPeriod,
  acdoca.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  acdoca.ReferenceDocumentType AS ReferenceDocumentType,
  acdoca.AccountingDocumentCategory AS AccountingDocumentCategory,
  acdoca.ClearingAccountingDocument AS ClearingAccountingDocument,
  acdoca.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  acdoca.ClearingDate AS ClearingDate,
  acdoca.IsReversal AS IsReversal,
  wl.Jrnlperiodendclosingrunloguuid AS Jrnlperiodendclosingrunloguuid,
  wl.is_cleared_at_keydate AS IsClearedAtKeyDate,
  acdoca.BusinessTransactionCategory AS BusinessTransactionCategory,
  acdoca.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  acdoca.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  acdoca.CompanyCodeCurrency AS CompanyCodeCurrency,
  acdoca.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  acdoca.GlobalCurrency AS GlobalCurrency,
  acdoca.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  acdoca.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  acdoca.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  acdoca.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  acdoca.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  acdoca.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  acdoca.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  acdoca.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  acdoca.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  acdoca.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  acdoca.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  acdoca.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  acdoca.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  acdoca.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  acdoca.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  acdoca.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  acdoca.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  case GLAccountType when 'C' then acdoca.HouseBank else ' ' end AS HouseBank,
  case GLAccountType when 'C' then acdoca.HouseBankAccount else ' ' end AS HouseBankAccount,
  acdoca.AssignmentReference AS AssignmentReference,
  acdoca.CostCtrActivityType AS CostCtrActivityType,
  acdoca.WBSElementInternalID AS WBSElementInternalID,
  acdoca.FinancialTransactionType AS FinancialTransactionType,
  acdoca.JointVenture AS JointVenture,
  acdoca.JointVentureEquityGroup AS JointVentureEquityGroup,
  acdoca.PartnerVenture AS PartnerVenture,
  acdoca.JointVenturePartner AS JointVenturePartner,
  acdoca.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  acdoca.JointVentureEquityType AS JointVentureEquityType,
  acdoca.ProjectNetwork AS ProjectNetwork,
  acdoca.RelatedNetworkActivity AS RelatedNetworkActivity,
  acdoca.OrderID AS OrderID,
  acdoca.BusinessProcess AS BusinessProcess,
  acdoca.SalesDocument AS SalesOrder,
  acdoca.SalesDocumentItem 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.PartnerCompany AS PartnerCompany,
  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.WBSElement AS WBSElement,
  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.TaxCode AS TaxCode,
  acdoca.TaxCountry AS TaxCountry,
  acdoca.AccrualObjectType AS AccrualObjectType,
  acdoca.AccrualObject AS AccrualObject,
  acdoca.AccrualSubobject AS AccrualSubobject,
  acdoca.AccrualItemType AS AccrualItemType,
  acdoca.AccrualReferenceObject AS AccrualReferenceObject,
  acdoca.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  acdoca.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  acdoca.ServiceDocument AS ServiceDocument,
  acdoca.ServiceDocumentItem AS ServiceDocumentItem,
  acdoca.ServiceDocumentType AS ServiceDocumentType,
  acdoca.Material AS Material
FROM I_GLAccountLineItem AS acdoca
INNER JOIN VALUATIONREMAINVALWL AS wl ON /* join condition not captured in parsed metadata */
;