VALUATIONINVOICE

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 VALUATIONINVOICE.
-- 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, p_key_date : fis_budat

CREATE VIEW VALUATIONINVOICE 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.ClearingAccountingDocument AS ClearingAccountingDocument,
  acdoca.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  acdoca.ClearingDate AS ClearingDate,
  acdoca.NetDueDate AS NetDueDate,
  acdoca.ChartOfAccounts AS ChartOfAccounts,
  acdoca.IsReversal AS IsReversal,
  acdoca.OrganizationalChange AS OrganizationalChange,
  acdoca.GLAccount AS GLAccount,
  acdoca.CreationDateTime AS CreationDateTime,
  acdoca.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  acdoca.DocumentDate AS DocumentDate,
  acdoca.PostingDate AS PostingDate,
  acdoca.PostingDate AS OriginalPostingDate,
  acdoca.AccountingDocumentCategory AS AccountingDocumentCategory,
  acdoca.LedgerFiscalYear AS LedgerFiscalYear,
  acdoca.ReferenceDocumentType AS ReferenceDocumentType,
  acdoca.FiscalYearPeriod AS FiscalYearPeriod,
  acdoca.IsOpenItemManaged AS IsOpenItemManaged,
  acdoca._PostingKey.DebitCreditCode AS DebitCreditCode,
  acdoca.PostingKey AS PostingKey,
  acdoca.BusinessTransactionCategory AS BusinessTransactionCategory,
  acdoca.GLAccountType AS GLAccountType,
  acdoca.FinancialAccountType AS FinancialAccountType,
  acdoca.AssignmentReference AS AssignmentReference,
  acdoca.FiscalPeriod AS FiscalPeriod,
  acdoca.OffsettingAccount AS OffsettingAccount,
  acdoca.WBSElement AS WBSElement,
  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.TaxCode AS TaxCode,
  acdoca.TaxCountry AS TaxCountry,
  cast(case acdoca.GLAccountType when 'C' then acdoca.HouseBank else '' end as farp_hbkid) AS HouseBank,
  cast(case acdoca.GLAccountType when 'C' then acdoca.HouseBankAccount else '' end as fac_hktid) AS HouseBankAccount,
  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.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.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,
  acdoca.CompanyCode AS PrdcssrJournalEntryCompanyCode,
  acdoca.FiscalYear AS PrdcssrJournalEntryFiscalYear,
  acdoca.AccountingDocument AS PredecessorJournalEntry,
  acdoca.LedgerGLLineItem AS PredecessorJournalEntryItem,
  cast(coalesce(_CustomerRiskClass._CreditManagement.CreditRiskClass, '') as ukm_risk_class) AS CreditRiskClass,
  cast('' as cls_run_group_id) AS group_id,
  _BPFinancialServicesExtn.TradingPartner AS MASTERDATAPARTNERCOMPANY
FROM I_GLAccountLineItem AS acdoca
LEFT OUTER JOIN P_BPCreditRiskClass AS _CustomerRiskClass ON acdoca.Customer = _CustomerRiskClass.Customer  -- association [0..1]
;