C_InspUsgeDescStk

DDL: C_INSPUSGEDESCSTK SQL: CINSPUSGEDESCSTK Type: view CONSUMPTION
13 Fields 1 Data Sources

Insp Usage Decision Stk Posting

C_InspUsgeDescStk is a Consumption CDS View that provides data about "Insp Usage Decision Stk Posting" in SAP S/4HANA. It reads from 1 data source (I_InspLotMatlDocItem) and exposes 13 fields with key fields InspectionLot, InspLotMatlDocItem.

Data Sources (1)

SourceAliasJoin Type
I_InspLotMatlDocItem _InspLotMatlDocItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINSPUSGEDESCSTK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Insp Usage Decision Stk Posting view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspLotMatlDocItem InspectionLot Inspection Lot
KEY InspLotMatlDocItem I_InspLotMatlDocItem InspLotMatlDocItem Version
InspLotMatlDocItemType I_InspLotMatlDocItem InspLotMatlDocItemType Type
MaterialDocumentYear I_InspLotMatlDocItem MaterialDocumentYear Material Document Year
MaterialDocument I_InspLotMatlDocItem MaterialDocument Material Doc.
MaterialDocumentItem I_InspLotMatlDocItem MaterialDocumentItem Material Document Item
CreationDate I_InspLotMatlDocItem CreationDate Time Stamp
GoodsMovementType Movement Type
GoodsMovementTypeName
InspLotMatlDocItemTypeText
MatlStkChangeQtyInBaseUnit
UnitOfMeasure_E
_InspectionLot I_InspLotMatlDocItem _InspectionLot

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_InspUsgeDescStk.
-- 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: CINSPUSGEDESCSTK

CREATE VIEW C_InspUsgeDescStk AS
SELECT
  _InspLotMatlDocItem.InspectionLot AS InspectionLot,
  _InspLotMatlDocItem.InspLotMatlDocItem AS InspLotMatlDocItem,
  _InspLotMatlDocItem.InspLotMatlDocItemType AS InspLotMatlDocItemType,
  _InspLotMatlDocItem.MaterialDocumentYear AS MaterialDocumentYear,
  _InspLotMatlDocItem.MaterialDocument AS MaterialDocument,
  _InspLotMatlDocItem.MaterialDocumentItem AS MaterialDocumentItem,
  _InspLotMatlDocItem.CreationDate AS CreationDate,
  _InspLotMatlDocItem._GoodsMovementDocument.GoodsMovementType AS GoodsMovementType,
  _InspLotMatlDocItem._GoodsMovementDocument._GoodsMovementType._Text[1:Language=$session.system_language].GoodsMovementTypeName AS GoodsMovementTypeName,
  _InspLotMatlDocItem._InspLotMatlDocItemType._Text[1:Language=$session.system_language].InspLotMatlDocItemTypeText AS InspLotMatlDocItemTypeText,
  _InspLotMatlDocItem._GoodsMovementDocument.MatlStkChangeQtyInBaseUnit AS MatlStkChangeQtyInBaseUnit,
  _InspLotMatlDocItem._GoodsMovementDocument._MaterialBaseUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E AS UnitOfMeasure_E,
  _InspLotMatlDocItem._InspectionLot AS _InspectionLot
FROM I_InspLotMatlDocItem AS _InspLotMatlDocItem
;

Learn More