P_PRODUCTSTORAGELOCATIOND
P_PRODUCTSTORAGELOCATIOND is a CDS View in S/4HANA. It contains 25 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ProductStorageLocationWD | view | left_outer | COMPOSITE | |
| P_ProductStorageLocationWD | view | union_all | COMPOSITE |
Fields (25)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ActivePlant | ActivePlant | 1 |
| KEY | ActiveProduct | ActiveProduct | 1 |
| KEY | ActiveStorageLocation | ActiveStorageLocation | 1 |
| creationdate | creationdate | 1 | |
| dateoflastpostedcntunrstrcdstk | dateoflastpostedcntunrstrcdstk | 1 | |
| fiscalmonthcurrentperiod | fiscalmonthcurrentperiod | 1 | |
| fiscalyearcurrentinvtryperiod | fiscalyearcurrentinvtryperiod | 1 | |
| fiscalyearcurrentperiod | fiscalyearcurrentperiod | 1 | |
| HasActiveEntity | HasActiveEntity | 1 | |
| hasinvtryblockstockprevperiod | hasinvtryblockstockprevperiod | 1 | |
| inventoryblockstockind | inventoryblockstockind | 1 | |
| inventorycorrectionfactor | inventorycorrectionfactor | 1 | |
| inventorystockprevperiod | inventorystockprevperiod | 1 | |
| invtrycurrentyearstockind | invtrycurrentyearstockind | 1 | |
| invtryqualinspcurrentyrstkind | invtryqualinspcurrentyrstkind | 1 | |
| invtryrestrictedusestockind | invtryrestrictedusestockind | 1 | |
| invtryreststockprevperiodind | invtryreststockprevperiodind | 1 | |
| invtrystockqltyinspprevperiod | invtrystockqltyinspprevperiod | 1 | |
| ismarkedfordeletion | ismarkedfordeletion | 1 | |
| maintenancestatus | maintenancestatus | 1 | |
| Parentdraftkey | ParentDraftKey | 1 | |
| physicalinventoryblockind | physicalinventoryblockind | 1 | |
| RootDraftKey | RootDraftKey | 1 | |
| storagelocation | storagelocation | 1 | |
| warehousestoragebin | warehousestoragebin | 1 |
//Product Storage Location (draft)
@AbapCatalog.sqlViewName: 'PPRDSTORAGELOCD'
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ProductStorageLocationD as select from prd_storage as DraftDocument
{
key DraftDocument.draftkey as Draftkey,
DraftDocument.parentdraftkey as Parentdraftkey,
DraftDocument.activeproduct as ActiveProduct,
DraftDocument.activeplant as ActivePlant,
DraftDocument.activestoragelocation as ActiveStorageLocation,
DraftDocument.storagelocation,
DraftDocument.warehousestoragebin,
DraftDocument.maintenancestatus,
DraftDocument.ismarkedfordeletion,
DraftDocument.physicalinventoryblockind,
DraftDocument.creationdate,
DraftDocument.dateoflastpostedcntunrstrcdstk,
DraftDocument.inventorycorrectionfactor,
DraftDocument.invtryrestrictedusestockind,
DraftDocument.invtrycurrentyearstockind,
DraftDocument.invtryqualinspcurrentyrstkind,
DraftDocument.inventoryblockstockind,
DraftDocument.invtryreststockprevperiodind,
DraftDocument.inventorystockprevperiod,
DraftDocument.invtrystockqltyinspprevperiod,
DraftDocument.hasinvtryblockstockprevperiod,
DraftDocument.fiscalyearcurrentperiod,
DraftDocument.fiscalmonthcurrentperiod,
DraftDocument.fiscalyearcurrentinvtryperiod,
DraftDocument.hasactiveentity as HasActiveEntity,
DraftDocument.rootdraftkey as RootDraftKey
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PRD_STORAGE"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/