I_ALIGNSALESSCHEDLINECAT

CDS View

Sale Account assignment type indicator

I_ALIGNSALESSCHEDLINECAT is a CDS View in S/4HANA. Sale Account assignment type indicator. It contains 1 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AlignSlsOrdAcctAssgdSl view inner BASIC Sales Order Schedule line data

Fields (1)

KeyField CDS FieldsUsed in Views
SalesAccountAssignmentType SalesAccountAssignmentType 1
@AbapCatalog.sqlViewName: 'IALNSLSSCHELICAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sale Account assignment type indicator'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #M
   }
}
@AbapCatalog.preserveKey:true
define view I_AlignSalesSchedLineCat
  as select from tvep
{
  key tvep.ettyp           as ScheduleLineCategory,
      case when  tvep.pstyp = '0' and tvep.knttp = 'M'
                 then cast( 'P' as char1 )
           when  tvep.pstyp = '5' and tvep.knttp = 'X'
                 then cast( 'T' as char1 )
        end                as SalesAccountAssignmentType
}
where
  (
        tvep.pstyp = '0'
    and tvep.knttp = 'M'
  )
  or(
        tvep.pstyp = '5'
    and tvep.knttp = 'X'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVEP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/