P_RTPCORDERWIPRESERVEOFFSET

CDS View

P_RTPCORDERWIPRESERVEOFFSET is a CDS View in S/4HANA. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RTPCOrderWIPReserve view inner COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
KEY GLAccountType OffsetAccountType 1 
@AbapCatalog.sqlViewName: 'PRTPCWIPRSRVOFF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'RTPC Order WIP Reserve'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_RTPCOrderWIPReserveOffset
  as select distinct from I_GLAccountLineItemRawData
{
  key  OrderID,
  key  OrderItem,
  key  CompanyCode,
  key  SourceLedger as Ledger,
  key  FiscalYear,
  key  AccountingDocument,
  key  GLAccountType,
       GLAccount

}
where
        GLBusinessTransactionType =  'EBWP'
  and(
        SubLedgerAcctLineItemType <> '09100'
    and SubLedgerAcctLineItemType <> '09110'
  )

Learn More