I_EWM_PINVDOCBUSKEYITEM
Bus Keys of Whse Physical Inventory Item
I_EWM_PINVDOCBUSKEYITEM is a CDS View in S/4HANA. Bus Keys of Whse Physical Inventory Item. It contains 39 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_EWM_PInvDocBusKeyItem | view_entity | from | COMPOSITE | Private view for Row of PInv Item with Quantity in Whse |
Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | LineIndexOfPInvItem | LineIndexOfPInvItem | 1 |
| KEY | PhysicalInventoryChangeVersion | PhysicalInventoryChangeVersion | 1 |
| KEY | PhysicalInventoryDocumentUUID | PhysicalInventoryDocumentUUID | 1 |
| KEY | PhysicalInventoryItemNumber | PhysicalInventoryItemNumber | 1 |
| KEY | PInvDocumentItemType | PInvDocumentItemType | 1 |
| BatchUUID | BatchUUID | 1 | |
| BusinessPartner | BusinessPartner | 1 | |
| CounterForStockSeparation | CounterForStockSeparation | 1 | |
| DocumentReltdStockDocCat | DocumentReltdStockDocCat | 1 | |
| EntitledToDisposePartnerRole | EntitledToDisposePartnerRole | 1 | |
| EntitledToDisposeParty | EntitledToDisposeParty | 1 | |
| EWMMeansOfTransport | EWMMeansOfTransport | 1 | |
| EWMStockOwner | EWMStockOwner | 1 | |
| EWMStockType | EWMStockType | 1 | |
| EWMStockUsage | EWMStockUsage | 1 | |
| EWMStorageBin | EWMStorageBin | 1 | |
| EWMStorageType | EWMStorageType | 1 | |
| EWMWarehouse | EWMWarehouse | 1 | |
| GlobalLocationNumber | GlobalLocationNumber | 1 | |
| GlobalTradeItemNumber | GlobalTradeItemNumber | 1 | |
| GlobalTradeItemNumberVariant | GlobalTradeItemNumberVariant | 1 | |
| HandlingUnitIndicator | HandlingUnitIndicator | 1 | |
| HandlingUnitNumber | HandlingUnitNumber | 1 | |
| InventorySpclStockWBSElement | InventorySpclStockWBSElement | 1 | |
| LocationPlant | LocationPlant | 1 | |
| PlanningVersionUUID | PlanningVersionUUID | 1 | |
| ProducedMaterial | ProducedMaterial | 1 | |
| ProductUUID | ProductUUID | 1 | |
| SerialShippingContainerCode | SerialShippingContainerCode | 1 | |
| SourceResource | SourceResource | 1 | |
| StockItemNumber | StockItemNumber | 1 | |
| StockOwnerPartnerRole | StockOwnerPartnerRole | 1 | |
| StockUsage | StockUsage | 1 | |
| StorageLocation | StorageLocation | 1 | |
| StorageType | StorageType | 1 | |
| WarehouseLocation | WarehouseLocation | 1 | |
| WarehouseLocationRole | WarehouseLocationRole | 1 | |
| WarehouseLocationUUID | WarehouseLocationUUID | 1 | |
| WarehouseViewForGlobalStocks | WarehouseViewForGlobalStocks | 1 |
@AbapCatalog.sqlViewName: 'IEWMPIITBIZ'
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #CHECK
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType:#BASIC
@EndUserText.label: 'Bus Keys of Whse Physical Inventory Item'
@ObjectModel.usageType: {serviceQuality: #A,
dataClass: #TRANSACTIONAL,
sizeCategory: #M}
define view I_EWM_PInvDocBusKeyItem
as select from /lime/pi_it_biz
{
key guid_doc as PhysicalInventoryDocumentUUID,
key item_no as PhysicalInventoryItemNumber,
key line_idx as LineIndexOfPInvItem,
key change_seq as PhysicalInventoryChangeVersion,
key item_type as PInvDocumentItemType,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'Batch'
charg as ProductBatch,
charg as Batch,
owner as EWMStockOwner,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMStockOwner'
owner as StockOwner,
owner_role as StockOwnerPartnerRole,
gtin as GlobalTradeItemNumber,
gtin_variant as GlobalTradeItemNumberVariant,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMStockType'
cat as StockType,
cat as EWMStockType,
stock_usage as EWMStockUsage,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMStockUsage'
stock_usage as StockUsage,
sales_ord_stock as SpecialStockIdfgSalesOrder,
s_ord_item_stock as SpecialStockIdfgSalesOrderItem,
wbs_stock as InventorySpclStockWBSElement,
vrsioid as PlanningVersionUUID,
apo_matnr as ProducedMaterial,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMWarehouse'
case
when lgnum_stock is not null and lgnum_stock <> ''
then lgnum_stock
when lgnum_hu is not null and lgnum_hu <> ''
then lgnum_hu
else lgnum
end as Warehouse,
case
when lgnum_stock is not null and lgnum_stock <> ''
then lgnum_stock
when lgnum_hu is not null and lgnum_hu <> ''
then lgnum_hu
else lgnum
end as EWMWarehouse,
cast( matid as matid_no_conv preserving type ) as ProductUUID,
batchid as BatchUUID,
stock_doccat as StockDocumentCategory,
stock_docno as StockDocumentNumber,
stock_itmno as StockItemNumber,
doccat as DocumentReltdStockDocCat,
entitled as EntitledToDisposeParty,
entitled_role as EntitledToDisposePartnerRole,
stock_cnt as CounterForStockSeparation,
sscc as SerialShippingContainerCode,
huident as HandlingUnitNumber,
vhi as HandlingUnitIndicator,
werks as LocationPlant,
lgort as StorageLocation,
gln as GlobalLocationNumber,
locid as WarehouseLocationUUID,
apo_locno as WarehouseLocation,
partner as BusinessPartner,
partner_role as WarehouseLocationRole,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMMeansOfTransport'
motid as MeansOfTransport,
cast (motid as /scdl/dl_transmeans_id ) as EWMMeansOfTransport,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMStorageType'
lgtyp as StorageType,
lgtyp as EWMStorageType,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMStorageBin'
lgpla as StorageBin,
lgpla as EWMStorageBin,
rsrc as SourceResource,
tu_num as TranspUnitInternalNumber,
lgnum_view as WarehouseViewForGlobalStocks,
hu_pmat as PackagingMaterial,
hu_type as HandlingUnitType
}