C_SupplierInvoiceItemDP

DDL: C_SUPPLIERINVOICEITEMDP Type: view_entity CONSUMPTION Package: MM_IV_BDC
33 Fields 1 Data Sources 7 Associations 1 OData Services

Supplier Invoice Item

C_SupplierInvoiceItemDP is a Consumption CDS View that provides data about "Supplier Invoice Item" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoiceItemOnline) and exposes 33 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem. It has 7 associations to related views. It is exposed through 1 OData service (DP_SUPPLIERINVOICE). Part of development package MM_IV_BDC.

Data Sources (1)

SourceAliasJoin Type
I_SupplierInvoiceItemOnline I_SupplierInvoiceItemOnline from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _PurOrdPriceUnitOfMeasure $projection.PurchaseOrderPriceUnit = _PurOrdPriceUnitOfMeasure.UnitOfMeasure
[0..1] I_Product _Product $projection.PurchaseOrderItemMaterial = _Product.Product
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_Currency _DocumentCurrency $projection.DocumentCurrency = _DocumentCurrency.Currency
[1..1] I_CompanyCode _CompanyCode $projection.companycode = _CompanyCode.CompanyCode
[1..1] C_PurchaseOrderDP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] C_PurchaseOrderItemDP _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (13)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
DataIntegration.deltaReplication.intended true view
EndUserText.label Supplier Invoice Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #EXTERNAL_DATA_PROVIDER view
ObjectModel.sapObjectNodeType.name SupplierInvoiceItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
PersonalData.entitySemantics #OTHER view

OData Services (1)

ServiceBindingVersionContractRelease
DP_SUPPLIERINVOICE DP_SUPPLIERINVOICE C2 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice SupplierInvoice
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SupplierInvoiceItem SupplierInvoiceItem
CompanyCode _SupplierInvoice CompanyCode Receiver Company Code
IsEndOfPurposeBlocked _SupplierInvoice IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
SupplierInvoiceItemAmount Amount
DocumentCurrency DocumentCurrency Document Currency
Plant Plant Valuation Area
SuplrInvcItemHasDateVariance SuplrInvcItemHasDateVariance Bl. Reason Date
SuplrInvcItemHasAmountOutsdTol SuplrInvcItemHasAmountOutsdTol Blkg Reas. Amount
SuplrInvcItemHasOtherVariance SuplrInvcItemHasOtherVariance Man.Block.Reasn
SuplrInvcItemHasPriceVariance SuplrInvcItemHasPriceVariance Block.Reas.:Prc
SuplrInvcItemHasQtyVariance SuplrInvcItemHasQtyVariance Block.Reas.:Qty
SuplrInvcItemHasOrdPrcQtyVarc SuplrInvcItemHasOrdPrcQtyVarc Block.Reas: OPQ
SuplrInvcItmHasQualityVariance SuplrInvcItmHasQualityVariance Block: Quality
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit Quantity
PurchaseOrderItemMaterial PurchaseOrderItemMaterial
PrmtHbReferenceDocumentItem ReferenceDocumentItem Reference item
PrmtHbReferenceDocumentFsclYr ReferenceDocumentFiscalYear Year Cur.Period
PrmtHbReferenceDocument ReferenceDocument Reference Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
PurchaseOrderPriceUnit PurchaseOrderPriceUnit Order Price Un.
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
_CompanyCode _CompanyCode
_SupplierInvoiceDP _SupplierInvoiceDP
_PurOrdPriceUnitOfMeasure _PurOrdPriceUnitOfMeasure
_Product _Product
_Plant _Plant
_DocumentCurrency _DocumentCurrency
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem

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_SupplierInvoiceItemDP.
-- 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 C_SupplierInvoiceItemDP AS
SELECT
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  _SupplierInvoice.CompanyCode AS CompanyCode,
  _SupplierInvoice.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  curr_to_decfloat_amount(SupplierInvoiceItemAmount) AS SupplierInvoiceItemAmount,
  DocumentCurrency,
  Plant,
  SuplrInvcItemHasDateVariance,
  SuplrInvcItemHasAmountOutsdTol,
  SuplrInvcItemHasOtherVariance,
  SuplrInvcItemHasPriceVariance,
  SuplrInvcItemHasQtyVariance,
  SuplrInvcItemHasOrdPrcQtyVarc,
  SuplrInvcItmHasQualityVariance,
  QuantityInPurchaseOrderUnit,
  PurchaseOrderItemMaterial,
  ReferenceDocumentItem AS PrmtHbReferenceDocumentItem,
  ReferenceDocumentFiscalYear AS PrmtHbReferenceDocumentFsclYr,
  ReferenceDocument AS PrmtHbReferenceDocument,
  PurchaseOrderItem,
  PurchaseOrder,
  PurchaseOrderQuantityUnit,
  PurchaseOrderPriceUnit,
  QtyInPurchaseOrderPriceUnit
FROM I_SupplierInvoiceItemOnline
LEFT OUTER JOIN I_UnitOfMeasure AS _PurOrdPriceUnitOfMeasure ON PurchaseOrderPriceUnit = _PurOrdPriceUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON PurchaseOrderItemMaterial = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderDP AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemDP AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
;

Learn More