A_SupplierInvoiceItemMaterial

DDL: A_SUPPLIERINVOICEITEMMATERIAL SQL: ASINVCITMMAT Type: view CONSUMPTION Package: ODATA_MM_IV_SI_API
21 Fields 1 Data Sources 1 Associations

Item for Material Posting

A_SupplierInvoiceItemMaterial is a Consumption CDS View that provides data about "Item for Material Posting" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoiceItemMaterial) and exposes 21 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem. It has 1 association to related views. Part of development package ODATA_MM_IV_SI_API.

Data Sources (1)

SourceAliasJoin Type
I_SupplierInvoiceItemMaterial item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_SupplierInvoice _SupplierInvoice $projection.SupplierInvoice = _SupplierInvoice.SupplierInvoice and $projection.FiscalYear = _SupplierInvoice.FiscalYear

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ASINVCITMMAT view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Item for Material Posting view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice SupplierInvoice SD Document
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SupplierInvoiceItem SupplierInvoiceItem Posting View Item
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
CompanyCode CompanyCode Receiver Company Code
Plant SuplrInvcItemMaterialPlant Receiving Plant
InventoryValuationType InventoryValuationType Valuation Type
TaxCode TaxCode Tax Code
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TaxCountry TaxCountry Tax Ctry/Reg.
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
DocumentCurrency _SupplierInvoice DocumentCurrency Document Currency
SupplierInvoiceItemAmount SupplierInvoiceItemAmount Amount
QuantityUnit QuantityUnit Unit of measure
SuplrInvcItmQtyUnitSAPCode QuantityUnit Unit of measure
SuplrInvcItmQtyUnitISOCode _UnitOfMeasure UnitOfMeasureISOCode
Quantity Quantity Value
DebitCreditCode DebitCreditCode Single-Character Flag
IsNotCashDiscountLiable IsNotCashDiscountLiable W/o CashDsc.
_SupplierInvoice _SupplierInvoice

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 A_SupplierInvoiceItemMaterial.
-- 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: ASINVCITMMAT

CREATE VIEW A_SupplierInvoiceItemMaterial AS
SELECT
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  Material,
  ValuationArea,
  CompanyCode,
  SuplrInvcItemMaterialPlant AS Plant,
  InventoryValuationType,
  TaxCode,
  TaxJurisdiction,
  TaxCountry,
  TaxDeterminationDate,
  _SupplierInvoice.DocumentCurrency AS DocumentCurrency,
  SupplierInvoiceItemAmount,
  QuantityUnit,
  QuantityUnit AS SuplrInvcItmQtyUnitSAPCode,
  _UnitOfMeasure.UnitOfMeasureISOCode AS SuplrInvcItmQtyUnitISOCode,
  Quantity,
  DebitCreditCode,
  IsNotCashDiscountLiable
FROM I_SupplierInvoiceItemMaterial AS item
LEFT OUTER JOIN A_SupplierInvoice AS _SupplierInvoice ON SupplierInvoice = _SupplierInvoice.SupplierInvoice AND FiscalYear = _SupplierInvoice.FiscalYear  -- association [1..1]
;

Learn More