P_SCHEDULELINECONFIRMATION

CDS View

P_ScheduleLineConfirmation

P_SCHEDULELINECONFIRMATION is a CDS View in S/4HANA. P_ScheduleLineConfirmation. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_OverdueNotReleased view left_outer CONSUMPTION P_OverdueNotReleased 
@AbapCatalog.sqlViewName: 'PMMSSCHLINECONF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_ScheduleLineConfirmation as select from P_PurgDocSchedline {
    P_PurgDocSchedline.PurchasingDocument as PurchaseOrder, 
    P_PurgDocSchedline.PurchasingDocumentItem as PurchaseOrderItem, 
    P_PurgDocSchedline.ScheduleLine, 
    cast( 'X' as boolean    ) as IsConfirmedScheduleLine ,
//    P_PurgDocSchedline.AccountAssignmentCategory, 

//    P_PurgDocSchedline.CompanyCodeName, 

    P_PurgDocSchedline.PurchasingGroup, 
//    P_PurgDocSchedline.ConfirmationControl, 

    P_PurgDocSchedline.PurchasingOrganization, 
//    P_PurgDocSchedline.PurchasingDocumentType, 

//    P_PurgDocSchedline.DocumentDate, 

//    P_PurgDocSchedline.DelivDateCategory, 

//    P_PurgDocSchedline.Supplier, 

//    P_PurgDocSchedline.DocumentCurrency, 

//    P_PurgDocSchedline.SupplierName, 

//    P_PurgDocSchedline.PurchasingDocumentCategory, 

//    P_PurgDocSchedline.OrderQuantity, 

//    P_PurgDocSchedline.NetAmount, 

//    P_PurgDocSchedline.PurchasingDocumentDeletionCode, 

    P_PurgDocSchedline.CompanyCode, 
//    P_PurgDocSchedline.PurchasingDocumentItemCategory, 

//    P_PurgDocSchedline.MaterialNumber, 

//    P_PurgDocSchedline.ShortText, 

    P_PurgDocSchedline.Plant
//    P_PurgDocSchedline.OrderUnit, 

//    P_PurgDocSchedline.CummulativeSheduleQuantity, 

//    P_PurgDocSchedline.DeliveryDate, 

//    P_PurgDocSchedline.SupplierConfirmationCategory, 

//    P_PurgDocSchedline.OrderedQuantity, 

//    P_PurgDocSchedline.CommittedQuantity, 

//    P_PurgDocSchedline.BalanceQuantity, 

//    P_PurgDocSchedline.KeyDate

}
where 
OrderedQuantity != 0
  and(
          BalanceQuantity is null
    or(
          BalanceQuantity is not null
      and OrderedQuantity > BalanceQuantity
    )
  )

Learn More