P_PRODUCTWORKSCHEDULINGD

CDS View

P_PRODUCTWORKSCHEDULINGD is a CDS View in S/4HANA. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ProductWorkSchedulingWD view left_outer COMPOSITE
P_ProductWorkSchedulingWD view union_all COMPOSITE

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ActivePlant ActivePlant 1
KEY ActiveProduct ActiveProduct 1
HasActiveEntity HasActiveEntity 1
materialbasequantity materialbasequantity 1
overdelivtolerancelimit overdelivtolerancelimit 1
ParentDraftKey ParentDraftKey 1
rootdraftkey rootdraftkey 1
underdelivtolerancelimit underdelivtolerancelimit 1
unlimitedoverdelivisallowed unlimitedoverdelivisallowed 1
// Product Work Scheduling (draft)

@AbapCatalog.sqlViewName: 'PPRDWORKSCHEDD'
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED 
define view P_ProductWorkSchedulingD as   select from prd_work as DraftDocument
        
{     
    key DraftDocument.draftkey                                              as DraftKey, 
    key DraftDocument.activeproduct                                         as ActiveProduct,
    key DraftDocument.activeplant                                           as ActivePlant,
        DraftDocument.parentdraftkey                                        as ParentDraftKey ,  
        DraftDocument.materialbasequantity,
        DraftDocument.unlimitedoverdelivisallowed,
        DraftDocument.overdelivtolerancelimit,
        DraftDocument.underdelivtolerancelimit,
        DraftDocument.hasactiveentity                                       as HasActiveEntity,
        DraftDocument.rootdraftkey    
                                              
}