C_SuplrInvcByAcctAssgmt

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_SuplrInvcByAcctAssgmt.
-- 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: CSUPINVACCTASS

CREATE VIEW C_SuplrInvcByAcctAssgmt AS
SELECT
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  SupplierInvoiceWthnFiscalYear,
  OrdinalNumber,
  AccountType,
  ValidityDate,
  InvoicingParty,
  InvoicingPartyName,
  CostCenter,
  ControllingArea,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName,
  CompanyCode,
  _CompanyCodeValueHelp.CompanyCodeName AS CompanyCodeName,
  BusinessArea,
  _BusinessAreaStdVH._Text[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  ProfitCenter,
  _ProfitCenterValueHelp._Text[1: Language = $session.system_language].ProfitCenterLongName AS ProfitCenterName,
  FunctionalArea,
  _FndsMgmtFuncnlAreaStdVH.FunctionalAreaName AS FunctionalAreaName,
  GLAccount,
  _GLAccountVH._Text[1: Language = $session.system_language].GLAccountName AS GLAccountName,
  SalesOrder,
  SalesOrderItem,
  _SalesOrderItemValueHelp.SalesOrderItemText AS SalesOrderItemText,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  CostObject,
  CostCtrActivityType,
  BusinessProcess,
  WBSElementInternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  _WBSElementBasicData.WBSElement AS WBSElementExternalID,
  DocumentCurrency,
  SupplierInvoiceItemAmount,
  Quantity,
  QuantityUnit,
  TaxCode,
  _SuplrInvcPersonalNumberVH.UserDescription AS UserDescription,
  PersonnelNumber,
  WorkItem,
  DebitCreditCode,
  _SuplrInvcDebitCreditCodeVH.DebitCreditCodeName AS DebitCreditCodeName,
  TaxJurisdiction,
  InternalOrder,
  _InternalOrderVH.OrderDescription AS InternalOrderDescription,
  ProjectNetwork,
  _ProjectNetworkVH.ProjectNetworkDescription AS ProjectNetworkDescription,
  NetworkActivity,
  _NetworkActivityVH.NetworkActivityDescription AS NetworkActivityDescription,
  CommitmentItem,
  TopCommitmentItem,
  _FundsCenterStdVH.FundsCenterName AS FundsCenterName,
  FundsCenter,
  Fund,
  _FundStdVH.FundDescription AS FundDescription,
  FinancialManagementArea,
  GrantID,
  _GrantStdVH.GrantName AS GrantName,
  PartnerBusinessArea,
  cast(InvoiceStatusAndOrigin as mmiv_invoice_state preserving type) AS InvoiceStatusAndOrigin,
  PostingDate
FROM C_SuplrInvcByAcctAssgmtCalc
LEFT OUTER JOIN I_MM_WBSElementValueHelp AS _WBSElementValueHelp ON _WBSElementValueHelp.WBSElementExternalID = WBSElementExternalID  -- association [0..*]
LEFT OUTER JOIN C_SuplrInvcAccountTypeText AS _SuplrInvcAccountTypeText ON _SuplrInvcAccountTypeText.AccountType = AccountType  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_CostCenterValueHelp AS _CostCenterValueHelp ON _CostCenterValueHelp.CostCenter = CostCenter AND _CostCenterValueHelp.ControllingArea = ControllingArea AND _CostCenterValueHelp.ValidityEndDate >= ValidityDate  -- association [0..1]
LEFT OUTER JOIN C_MM_SalesOrderItemValueHelp AS _SalesOrderItemValueHelp ON _SalesOrderItemValueHelp.SalesOrderItem = SalesOrderItem AND _SalesOrderItemValueHelp.SalesOrder = SalesOrder  -- association [0..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = InvoicingParty AND _SupplierValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_GLAccountVH AS _GLAccountVH ON _GLAccountVH.CompanyCode = CompanyCode AND _GLAccountVH.GLAccount = GLAccount  -- association [0..1]
LEFT OUTER JOIN C_SupplierInvoiceStatusValHelp AS _SupplierInvoiceStatusValHelp ON _SupplierInvoiceStatusValHelp.SupplierInvoiceStatus = InvoiceStatusAndOrigin  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceStsOriginText AS _SupplierInvoiceStsOriginText ON _SupplierInvoiceStsOriginText.InvoiceStatusAndOrigin = InvoiceStatusAndOrigin AND _SupplierInvoiceStsOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MM_SalesOrderValueHelp AS _SalesOrderValueHelp ON _SalesOrderValueHelp.SalesOrder = SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaStdVH AS _BusinessAreaStdVH ON _BusinessAreaStdVH.BusinessArea = BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_MM_ProfitCenterValueHelp AS _ProfitCenterValueHelp ON _ProfitCenterValueHelp.ControllingArea = ControllingArea AND _ProfitCenterValueHelp.ProfitCenter = ProfitCenter AND _ProfitCenterValueHelp.ValidityEndDate >= ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_FndsMgmtFuncnlAreaStdVH AS _FndsMgmtFuncnlAreaStdVH ON _FndsMgmtFuncnlAreaStdVH.FunctionalArea = FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _ProjectNetworkVH ON _ProjectNetworkVH.ProjectNetwork = ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterStdVH AS _FundsCenterStdVH ON _FundsCenterStdVH.FundsCenter = FundsCenter AND _FundsCenterStdVH.ValidityEndDate >= ValidityDate AND _FundsCenterStdVH.FinancialManagementArea = FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_FundStdVH AS _FundStdVH ON _FundStdVH.Fund = Fund AND _FundStdVH.FinancialManagementArea = FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_GrantStdVH AS _GrantStdVH ON _GrantStdVH.GrantID = GrantID  -- association [0..1]
LEFT OUTER JOIN C_ControllingAreaVH AS _ControllingAreaVH ON _ControllingAreaVH.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN C_SuplrInvcTaxCodeVH AS _SuplrInvcTaxCodeVH ON _SuplrInvcTaxCodeVH.TaxCode = TaxCode AND _SuplrInvcTaxCodeVH.CompanyCode = CompanyCode AND _SuplrInvcTaxCodeVH.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_MM_NetworkActivityVH AS _NetworkActivityVH ON _NetworkActivityVH.ProjectNetwork = ProjectNetwork AND _NetworkActivityVH.NetworkActivity = NetworkActivity  -- association [0..1]
LEFT OUTER JOIN I_OrderBasicVH AS _InternalOrderVH ON _InternalOrderVH.OrderID = InternalOrder  -- association [0..1]
LEFT OUTER JOIN C_SuplrInvcPersonalNumberVH AS _SuplrInvcPersonalNumberVH ON _SuplrInvcPersonalNumberVH.PersonnelNumber = PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN C_SuplrInvcDebitCreditCodeVH AS _SuplrInvcDebitCreditCodeVH ON _SuplrInvcDebitCreditCodeVH.DebitCreditCode = DebitCreditCode  -- association [0..1]
;