C_HU_MMConsignmentAuditCube

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_HU_MMConsignmentAuditCube.
-- 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: CHUMMICAUDITCUBE

CREATE VIEW C_HU_MMConsignmentAuditCube AS
SELECT
  P_HU_MMINVOICECONSIGNMENTNEWR.CompanyCode AS CompanyCode,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.CompanyCodeCurrency as glo_hu_cocode_curr) AS CompanyCodeCurrency,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.OriginalReferenceDocument as idhu_origrefdoc) AS OriginalReferenceDocument,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.AccountingDocument as idhu_origdoc) AS AccountingDocument,
  cast (P_HU_MMINVOICECONSIGNMENTNEWR.TaxItem as glo_hu_item_num) AS BillingDocumentItem,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.DocumentCurrency as idhu_doccurrency) AS DocumentCurrency,
  P_HU_MMINVOICECONSIGNMENTNEWR.DocumentDate AS DocumentDate,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.TaxFulfillmentDate as vatdate) AS TaxFulfillmentDate,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.InvoiceIssueDate as erdat) AS InvoiceIssueDate,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.CustomerInvoiceType as idhu_invtyp) AS CustomerInvoiceType,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.AnalyticalGrossAmount as idhu_gross_amt) AS GrossAmount,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.AnalyticalNetPriceAmount as glo_hu_net_price_amt) AS NetPriceAmount,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.BaseUnitNetAmount as idhu_net_uprice) AS BaseUnitNetAmount,
  cast(P_HU_MM_IC_AUDITINVOICE.SupplierTaxNumber as idhu_taxnum) AS SupplierVATRegistration,
  P_HU_MMINVOICECONSIGNMENTNEWR.BusinessPartner AS BusinessPartner,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.BusinessPartnerName as business_partner_name) AS BusinessPartnerName,
  P_HU_MM_IC_AUDITINVOICE.SupplierPostalCode AS SupplierPostalCode,
  P_HU_MM_IC_AUDITINVOICE.SupplierCityName AS SupplierCityName,
  P_HU_MM_IC_AUDITINVOICE.SupplierStreetName AS SupplierStreetName,
  P_HU_MMINVOICECONSIGNMENTNEWR.PostingDate AS PostingDate,
  P_HU_MMINVOICECONSIGNMENTNEWR.ProductName AS ProductName,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.Quantity as idhu_quantity) AS Quantity,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.HungarianCurrency as fc_curr) AS ReportingCurrency,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.AnalyticalTaxAmountInHUFCrcy as glo_tax_amount) AS TaxAmountInRptgCrcy,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.AnlTaxAmountInDocumentCurrency as glo_taxamount_indocucrcy) AS TaxAmountInDocumentCurrency,
  P_HU_MMINVOICECONSIGNMENTNEWR.TaxCode AS TaxCode,
  cast(P_HU_MMINVOICECONSIGNMENTNEWR.Taxrate as glo_hu_tax_rate) AS TaxRate,
  P_HU_MMINVOICECONSIGNMENTNEWR.UnitOfMeasure AS UnitOfMeasure
FROM P_HU_MMINVOICECONSIGNMENTNEWR
;