I_EWM_WAREHOUSEREQUESTINBITEM

CDS View

Warehouse Request Inbound Item

I_EWM_WAREHOUSEREQUESTINBITEM is a CDS View in S/4HANA. Warehouse Request Inbound Item. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EWM_InbDeliveryItemBasic view_entity from COMPOSITE Inbound Delivery Item Basic
P_EWM_WhseReqInbItm_MigSts_SDM view_entity from COMPOSITE 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Warehouse Request Inbound Item'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType:#BASIC
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
define view entity I_EWM_WarehouseRequestInbItem 
  as select from /scdl/db_proci_i
{
  key docid                                                    as EWMWarehouseRequestUUID,
  key itemid                                                   as EWMWarehouseRequestItemUUID,
      /scwm/whno                                               as EWMWarehouse,
      docno                                                    as EWMWarehouseRequest,
      itemno                                                   as EWMWarehouseRequestItem,
      doccat                                                   as EWMWhseRequestDocumentCategory,
      itemcat                                                  as EWMWhseRequestItemCategory,
      itemtype                                                 as EWMWarehouseRequestItemType,
      /scwm/procty                                             as WarehouseProcessType,
      /scwm/door                                               as WarehouseDoor,
      /scwm/stagareagr                                         as StagingAreaGroup,
      /scwm/stagarea                                           as StagingArea,
      /scwm/stagarbin                                          as StagingBay,
      /scwm/psa                                                as EWMProductionSupplyArea,
      /scwm/gmbin                                              as GoodsMovementBin,
      /scwm/stobin                                             as EWMStorageBin,
      /scwm/goods_recipient                                    as EWMGoodsRecipient,
      /scwm/rcloc                                              as EWMRecipientLocationName,
      productno                                                as Product,
      cast( productno_ext as char40 preserving type )          as ProductExternalID,
      batchno                                                  as ProductBatch,
      req_seg_long                                             as RequirementSegment,
      stk_seg_long                                             as StockSegment,
      ocountry                                                 as CountryOfOrigin,
      entitled                                                 as EntitledToDisposeParty,
      stock_owner                                              as EWMStockOwner,
      stock_category                                           as EWMStockType,
      stock_usage                                              as StockUsage,
      stock_owner_role                                         as StockOwnerPartnerRole,
      stock_cat_ind                                            as EWMWhseReqItmStockTypeDetnCode,
      stock_doccat                                             as StockDocumentCategory,
      stock_docno                                              as StockDocumentNumber,
      stock_itmno                                              as StockItemNumber,
      
      /* Reference Documents */
      cast(substring(refdocno_po,1,10) as fis_ebeln )          as PurchasingDocument,
      cast(substring(refitemno_po,6,5) as fis_ebelp )          as PurchasingDocumentItem,
      status_compl                                             as CompletionStatus,
      status_gr                                                as GoodsReceiptStatus,
      /scwm/flp_status                                         as FldLogsStatus, // Introduced with 2202 CE for Field Logistic colleagues

      cast( chgtst as /scwm/de_ts_wocvt )                      as EWMWhseReqLastChangeUTCDteTme,
      cast( cretst as /scwm/de_ts_wocvt )                      as EWMWhseReqCreationUTCDateTime,
      
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      qty                                                      as ProductQuantity,
      uom                                                      as QuantityUnit,
      tstto_pd_gr_wh                                           as PlndGREndWhseTmznDateTime,
      tstto_unldg_wh                                           as UnloadingEndWhseTmznDateTime,
      tstto_ptwy_wh                                            as PutawayEndWhseTmznDateTime,
      tstto_gr_wh                                              as ActualGREndWhseTmznDateTime,
      tstto_compltn_wh                                         as EWMItmCmpltWhseTmznDteTme
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCDL/DB_PROCI_I"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More