C_SuplrInvcBlockedItemReason

DDL: C_SUPLRINVCBLOCKEDITEMREASON SQL: CSUPINVITMBLRS Type: view CONSUMPTION Package: ODATA_INVOICE_PAYMENT_SI_PG
16 Fields 1 Data Sources 3 OData Services

Supplier invoice item blocking reasons

C_SuplrInvcBlockedItemReason is a Consumption CDS View that provides data about "Supplier invoice item blocking reasons" in SAP S/4HANA. It reads from 1 data source (P_SuplrInvcBlockedItemReason1) and exposes 16 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem, SuplrInvcItmBlockingReason. It is exposed through 3 OData services (ASQL_F0859, ASQL_F6852, ASQL_F7900). Part of development package ODATA_INVOICE_PAYMENT_SI_PG.

Data Sources (1)

SourceAliasJoin Type
P_SuplrInvcBlockedItemReason1 P_SuplrInvcBlockedItemReason1 from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSUPINVITMBLRS view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Supplier invoice item blocking reasons view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F0859 ASQL_F0859 C2 NOT_RELEASED
ASQL_F6852 ASQL_F6852 C2 NOT_RELEASED
ASQL_F7900 ASQL_F7900 C2 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice SupplierInvoice
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SupplierInvoiceItem SupplierInvoiceItem
KEY SuplrInvcItmBlockingReason SuplrInvcItmBlockingReason
SuplrInvcItmBlockingReasonDesc SuplrInvcItmBlockingReasonDesc
Plant Plant Valuation Area
SuplrInvcItemHasPriceVariance SuplrInvcItemHasPriceVariance Block.Reas.:Prc
SuplrInvcItemHasQtyVariance SuplrInvcItemHasQtyVariance Block.Reas.:Qty
SuplrInvcItemHasDateVariance SuplrInvcItemHasDateVariance Bl. Reason Date
SuplrInvcItemHasOrdPrcQtyVarc SuplrInvcItemHasOrdPrcQtyVarc Block.Reas: OPQ
SuplrInvcItemHasOtherVariance SuplrInvcItemHasOtherVariance Man.Block.Reasn
SuplrInvcItemHasAmountOutsdTol SuplrInvcItemHasAmountOutsdTol Blkg Reas. Amount
SuplrInvcItmHasQualityVariance SuplrInvcItmHasQualityVariance Block: Quality
Supplier Supplier Supplier
_SupplierInvoice _SupplierInvoice
_FiscalYear _FiscalYear

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_SuplrInvcBlockedItemReason.
-- 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: CSUPINVITMBLRS

CREATE VIEW C_SuplrInvcBlockedItemReason AS
SELECT
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  SuplrInvcItmBlockingReason,
  SuplrInvcItmBlockingReasonDesc,
  Plant,
  SuplrInvcItemHasPriceVariance,
  SuplrInvcItemHasQtyVariance,
  SuplrInvcItemHasDateVariance,
  SuplrInvcItemHasOrdPrcQtyVarc,
  SuplrInvcItemHasOtherVariance,
  SuplrInvcItemHasAmountOutsdTol,
  SuplrInvcItmHasQualityVariance,
  Supplier
FROM P_SuplrInvcBlockedItemReason1
;

Learn More