C_InspLotStockPosting

DDL: C_INSPLOTSTOCKPOSTING SQL: CINSPSTKPOSTING Type: view CONSUMPTION Package: ODATA_QM_INSPLOT

Inspection Lot Stock Posting

C_InspLotStockPosting is a Consumption CDS View that provides data about "Inspection Lot Stock Posting" in SAP S/4HANA. It reads from 2 data sources (I_InspLotMatlDocItem, I_InspectionLot) and exposes 16 fields with key fields InspectionLot, InspLotMatlDocItem. Part of development package ODATA_QM_INSPLOT.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_InspLotMatlDocItem _InspLotMatlDocItem from
I_InspectionLot InspLot inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINSPSTKPOSTING view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Inspection Lot Stock Posting view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspLotMatlDocItem InspectionLot
KEY InspLotMatlDocItem I_InspLotMatlDocItem InspLotMatlDocItem
Plant I_InspectionLot Plant
InspectionLotType I_InspectionLot InspectionLotType
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup
IsBusinessPurposeCompleted I_InspectionLot IsBusinessPurposeCompleted
InspLotMatlDocItemType I_InspLotMatlDocItem InspLotMatlDocItemType
MaterialDocumentYear I_InspLotMatlDocItem MaterialDocumentYear
MaterialDocument I_InspLotMatlDocItem MaterialDocument
MaterialDocumentItem I_InspLotMatlDocItem MaterialDocumentItem
CreationDate I_InspLotMatlDocItem CreationDate
GoodsMovementType
GoodsMovementTypeName
InspLotMatlDocItemTypeText
MatlStkChangeQtyInBaseUnit
UnitOfMeasure_E 
@AbapCatalog.sqlViewName: 'CINSPSTKPOSTING'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Inspection Lot Stock Posting'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #XL, //expected number of rows < 10.000.000

    serviceQuality: #C 
}
define view C_InspLotStockPosting  
as select from I_InspLotMatlDocItem as _InspLotMatlDocItem
   inner join I_InspectionLot as InspLot on InspLot.InspectionLot = _InspLotMatlDocItem.InspectionLot

{
  key _InspLotMatlDocItem.InspectionLot,
  key _InspLotMatlDocItem.InspLotMatlDocItem,
  InspLot.Plant,
  InspLot.InspectionLotType,
  InspLot.MatlQualityAuthorizationGroup,
  @UI.hidden: true
  InspLot.IsBusinessPurposeCompleted,
  _InspLotMatlDocItem.InspLotMatlDocItemType,
  _InspLotMatlDocItem.MaterialDocumentYear,
  @UI.lineItem: [{position:30, type: #FOR_INTENT_BASED_NAVIGATION, semanticObjectAction: 'displayFactSheet'}]
  //@UI.hidden: true

  @Consumption.semanticObject: 'Material'
  _InspLotMatlDocItem.MaterialDocument,
  _InspLotMatlDocItem.MaterialDocumentItem,
  @UI.lineItem: [{position:20,importance: #HIGH}]
  _InspLotMatlDocItem.CreationDate,
  @UI.lineItem: [{position:10,importance: #HIGH}]
  @UI.textArrangement: #TEXT_LAST
  @ObjectModel.text.element:  [ 'GoodsMovementTypeName' ] 
  _InspLotMatlDocItem._GoodsMovementDocument.GoodsMovementType,
  @Semantics.text: true
  _InspLotMatlDocItem._GoodsMovementDocument._GoodsMovementType._Text[1:Language=$session.system_language].GoodsMovementTypeName,
  _InspLotMatlDocItem._InspLotMatlDocItemType._Text[1:Language=$session.system_language].InspLotMatlDocItemTypeText,
  @UI.lineItem: [{position:40}]
  _InspLotMatlDocItem._GoodsMovementDocument.MatlStkChangeQtyInBaseUnit,
  _InspLotMatlDocItem._GoodsMovementDocument._MaterialBaseUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E,
  
  //Follow the standard logic for the case when the vuale for the UnitOfMeasureNumberOfDecimals greater than 4 

  //e.g. UnitOfMeasureNumberOfDecimals = 99  

  case when _InspLotMatlDocItem._GoodsMovementDocument._MaterialBaseUnit.UnitOfMeasureNumberOfDecimals > 4
       then 4
       else _InspLotMatlDocItem._GoodsMovementDocument._MaterialBaseUnit.UnitOfMeasureNumberOfDecimals 
       end as InspLotMatlDocQtyUnitDecPlaces
}

Learn More