I_ProductStorageLocationWD

DDL: I_PRODUCTSTORAGELOCATIONWD SQL: IPRDSTORAGELOCWD Type: view TRANSACTIONAL Package: VDM_MD_PRODUCT
23 Fields 1 Data Sources 4 Associations

Product BO Storage Location Node (draft)

I_ProductStorageLocationWD is a Transactional CDS View that provides data about "Product BO Storage Location Node (draft)" in SAP S/4HANA. It reads from 1 data source (I_ProductStorageLocationBasic) and exposes 23 fields with key fields Product, Plant, StorageLocation. It has 4 associations to related views. Part of development package VDM_MD_PRODUCT.

Data Sources (1)

SourceAliasJoin Type
I_ProductStorageLocationBasic StorageLocation from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_Productstoragelocation _ActiveExtension $projection.Product = _ActiveExtension.Product and $projection.Plant = _ActiveExtension.Plant and $projection.StorageLocation = _ActiveExtension.StorageLocation
[0..1] E_Productstoragelocation _DraftExtension $projection.Product = _DraftExtension.Product and $projection.Plant = _DraftExtension.Plant and $projection.StorageLocation = _DraftExtension.StorageLocation
[1..1] I_ProductWD _Product $projection.Product = _Product.Product
[1..1] I_ProductPlantWD _Plant $projection.Product = _Plant.Product and $projection.Plant = _Plant.Plant

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPRDSTORAGELOCWD view
EndUserText.label Product BO Storage Location Node (draft) view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PROD_PLNT_SLSTOR view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductStorageLocationBasic Product Product Sold
KEY Plant I_ProductStorageLocationBasic Plant Valuation Area
KEY StorageLocation I_ProductStorageLocationBasic StorageLocation StorageLocation
PlantForEdit I_ProductStorageLocationBasic Plant Valuation Area
StorageLocationForEdit I_ProductStorageLocationBasic StorageLocation StorageLocation
WarehouseStorageBin I_ProductStorageLocationBasic WarehouseStorageBin Storage Bin
MaintenanceStatus I_ProductStorageLocationBasic MaintenanceStatus Maint. status
IsMarkedForDeletion I_ProductStorageLocationBasic IsMarkedForDeletion Purch.org. data
PhysicalInventoryBlockInd I_ProductStorageLocationBasic PhysicalInventoryBlockInd Phys. Inv. Blk
CreationDate I_ProductStorageLocationBasic CreationDate Time Stamp
DateOfLastPostedCntUnRstrcdStk I_ProductStorageLocationBasic DateOfLastPostedCntUnRstrcdStk Last Count Date
InventoryCorrectionFactor I_ProductStorageLocationBasic InventoryCorrectionFactor Inven.cor.fact.
InvtryRestrictedUseStockInd I_ProductStorageLocationBasic InvtryRestrictedUseStockInd Restricted-use
InvtryCurrentYearStockInd I_ProductStorageLocationBasic InvtryCurrentYearStockInd Warehouse stock
InvtryQualInspCurrentYrStkInd I_ProductStorageLocationBasic InvtryQualInspCurrentYrStkInd QualInspStock
InventoryBlockStockInd I_ProductStorageLocationBasic InventoryBlockStockInd Blocked stock
InvtryRestStockPrevPeriodInd I_ProductStorageLocationBasic InvtryRestStockPrevPeriodInd Restricted use
InventoryStockPrevPeriod I_ProductStorageLocationBasic InventoryStockPrevPeriod Warehouse stock
InvtryStockQltyInspPrevPeriod I_ProductStorageLocationBasic InvtryStockQltyInspPrevPeriod QualInspStock
HasInvtryBlockStockPrevPeriod I_ProductStorageLocationBasic HasInvtryBlockStockPrevPeriod Blocked stock
FiscalYearCurrentInvtryPeriod I_ProductStorageLocationBasic FiscalYearCurrentInvtryPeriod Fiscal Year of Current Physical Inventory Indicator
_Product _Product
_Plant _Plant

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 I_ProductStorageLocationWD.
-- 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: IPRDSTORAGELOCWD

CREATE VIEW I_ProductStorageLocationWD AS
SELECT
  StorageLocation.Product AS Product,
  StorageLocation.Plant AS Plant,
  StorageLocation.StorageLocation AS StorageLocation,
  StorageLocation.Plant AS PlantForEdit,
  StorageLocation.StorageLocation AS StorageLocationForEdit,
  StorageLocation.WarehouseStorageBin AS WarehouseStorageBin,
  StorageLocation.MaintenanceStatus AS MaintenanceStatus,
  StorageLocation.IsMarkedForDeletion AS IsMarkedForDeletion,
  StorageLocation.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  StorageLocation.CreationDate AS CreationDate,
  StorageLocation.DateOfLastPostedCntUnRstrcdStk AS DateOfLastPostedCntUnRstrcdStk,
  StorageLocation.InventoryCorrectionFactor AS InventoryCorrectionFactor,
  StorageLocation.InvtryRestrictedUseStockInd AS InvtryRestrictedUseStockInd,
  StorageLocation.InvtryCurrentYearStockInd AS InvtryCurrentYearStockInd,
  StorageLocation.InvtryQualInspCurrentYrStkInd AS InvtryQualInspCurrentYrStkInd,
  StorageLocation.InventoryBlockStockInd AS InventoryBlockStockInd,
  StorageLocation.InvtryRestStockPrevPeriodInd AS InvtryRestStockPrevPeriodInd,
  StorageLocation.InventoryStockPrevPeriod AS InventoryStockPrevPeriod,
  StorageLocation.InvtryStockQltyInspPrevPeriod AS InvtryStockQltyInspPrevPeriod,
  StorageLocation.HasInvtryBlockStockPrevPeriod AS HasInvtryBlockStockPrevPeriod,
  StorageLocation.FiscalYearCurrentInvtryPeriod AS FiscalYearCurrentInvtryPeriod
FROM I_ProductStorageLocationBasic AS StorageLocation
LEFT OUTER JOIN E_Productstoragelocation AS _ActiveExtension ON Product = _ActiveExtension.Product AND Plant = _ActiveExtension.Plant AND StorageLocation = _ActiveExtension.StorageLocation  -- association [0..1]
LEFT OUTER JOIN E_Productstoragelocation AS _DraftExtension ON Product = _DraftExtension.Product AND Plant = _DraftExtension.Plant AND StorageLocation = _DraftExtension.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantWD AS _Plant ON Product = _Plant.Product AND Plant = _Plant.Plant  -- association [1..1]
;

Learn More