P_HU_MMINVOICECONSIGNMENTNEW

DDL: P_HU_MMINVOICECONSIGNMENTNEW Type: view_entity CONSUMPTION Package: GLO_FIN_IS_HU
23 Fields 1 Data Sources

HU Audit Report: MM invoices for Consignment Process

P_HU_MMINVOICECONSIGNMENTNEW is a Consumption CDS View that provides data about "HU Audit Report: MM invoices for Consignment Process" in SAP S/4HANA. It reads from 1 data source (P_HU_MMINVOICECONSIGNMENTNEWR) and exposes 23 fields. Part of development package GLO_FIN_IS_HU.

Data Sources (1)

SourceAliasJoin Type
P_HU_MMINVOICECONSIGNMENTNEWR P_HU_MMINVOICECONSIGNMENTNEWR from

Annotations (7)

NameValueLevelField
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
CompanyCode P_HU_MMINVOICECONSIGNMENTNEWR CompanyCode Receiver Company Code
CompanyCodeCurrency P_HU_MMINVOICECONSIGNMENTNEWR CompanyCodeCurrency Local Currency
DocumentCurrency P_HU_MMINVOICECONSIGNMENTNEWR DocumentCurrency Document Currency
OriginalReferenceDocument P_HU_MMINVOICECONSIGNMENTNEWR OriginalReferenceDocument Reference Key
ProductName P_HU_MMINVOICECONSIGNMENTNEWR ProductName Description
Quantity P_HU_MMINVOICECONSIGNMENTNEWR Quantity Value
UnitOfMeasure
Taxrate P_HU_MMINVOICECONSIGNMENTNEWR Taxrate Tax Rate
CountryCurrency P_HU_MMINVOICECONSIGNMENTNEWR CountryCurrency Currency
DocumentReferenceID P_HU_MMINVOICECONSIGNMENTNEWR DocumentReferenceID Reference
BaseUnitNetAmount P_HU_MMINVOICECONSIGNMENTNEWR BaseUnitNetAmount
CustomerInvoiceType P_HU_MMINVOICECONSIGNMENTNEWR CustomerInvoiceType
OriginalInvoiceID
ReferenceDocumentType P_HU_MMINVOICECONSIGNMENTNEWR ReferenceDocumentType Reference Document Type
DocumentDate P_HU_MMINVOICECONSIGNMENTNEWR DocumentDate Journal Entry Date
PostingDate P_HU_MMINVOICECONSIGNMENTNEWR PostingDate Posting Date for GR
TaxFulfillmentDate P_HU_MMINVOICECONSIGNMENTNEWR TaxFulfillmentDate Tax Settlement Date
NetPriceAmount P_HU_MMINVOICECONSIGNMENTNEWR NetPriceAmount Net Price
TaxAmount P_HU_MMINVOICECONSIGNMENTNEWR TaxAmount Tax Amt in Rptg Crcy
GrossAmount P_HU_MMINVOICECONSIGNMENTNEWR GrossAmount Gross value
HungarianCurrency P_HU_MMINVOICECONSIGNMENTNEWR HungarianCurrency
TaxAmountInHUFCrcy P_HU_MMINVOICECONSIGNMENTNEWR TaxAmountInHUFCrcy
Supplier P_HU_MMINVOICECONSIGNMENTNEWR Supplier Supplier

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_HU_MMINVOICECONSIGNMENTNEW.
-- 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.

CREATE VIEW P_HU_MMINVOICECONSIGNMENTNEW AS
SELECT
  P_HU_MMINVOICECONSIGNMENTNEWR.CompanyCode AS CompanyCode,
  P_HU_MMINVOICECONSIGNMENTNEWR.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_HU_MMINVOICECONSIGNMENTNEWR.DocumentCurrency AS DocumentCurrency,
  P_HU_MMINVOICECONSIGNMENTNEWR.OriginalReferenceDocument AS OriginalReferenceDocument,
  P_HU_MMINVOICECONSIGNMENTNEWR.ProductName AS ProductName,
  P_HU_MMINVOICECONSIGNMENTNEWR.Quantity AS Quantity,
  coalesce( _UnitOfMeasureLangDep.UnitOfMeasure_E, P_HU_MMINVOICECONSIGNMENTNEWR.UnitOfMeasure ) AS UnitOfMeasure,
  P_HU_MMINVOICECONSIGNMENTNEWR.Taxrate AS Taxrate,
  P_HU_MMINVOICECONSIGNMENTNEWR.CountryCurrency AS CountryCurrency,
  P_HU_MMINVOICECONSIGNMENTNEWR.DocumentReferenceID AS DocumentReferenceID,
  P_HU_MMINVOICECONSIGNMENTNEWR.BaseUnitNetAmount AS BaseUnitNetAmount,
  P_HU_MMINVOICECONSIGNMENTNEWR.CustomerInvoiceType AS CustomerInvoiceType,
  '' AS OriginalInvoiceID,
  P_HU_MMINVOICECONSIGNMENTNEWR.ReferenceDocumentType AS ReferenceDocumentType,
  P_HU_MMINVOICECONSIGNMENTNEWR.DocumentDate AS DocumentDate,
  P_HU_MMINVOICECONSIGNMENTNEWR.PostingDate AS PostingDate,
  P_HU_MMINVOICECONSIGNMENTNEWR.TaxFulfillmentDate AS TaxFulfillmentDate,
  P_HU_MMINVOICECONSIGNMENTNEWR.NetPriceAmount AS NetPriceAmount,
  P_HU_MMINVOICECONSIGNMENTNEWR.TaxAmount AS TaxAmount,
  P_HU_MMINVOICECONSIGNMENTNEWR.GrossAmount AS GrossAmount,
  P_HU_MMINVOICECONSIGNMENTNEWR.HungarianCurrency AS HungarianCurrency,
  P_HU_MMINVOICECONSIGNMENTNEWR.TaxAmountInHUFCrcy AS TaxAmountInHUFCrcy,
  P_HU_MMINVOICECONSIGNMENTNEWR.Supplier AS Supplier
FROM P_HU_MMINVOICECONSIGNMENTNEWR
;

Learn More