I_BPTRANSPSALESREPRESENTATIVE

CDS View

Core View BP Transp Sales Representative

I_BPTRANSPSALESREPRESENTATIVE is a CDS View in S/4HANA. Core View BP Transp Sales Representative. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BPTRANSPSTDCARRALPHACODE view_entity union COMPOSITE Private View for BP Transp SCAC
P_BusinessPartnerTranspIATA view_entity union COMPOSITE Private View for BP Transp IATA Code

Fields (1)

KeyField CDS FieldsUsed in Views
TranspSalesRepresentative Carrier 2 
@AbapCatalog.sqlViewName:              'IBPTPSLSREP'

@AbapCatalog.compiler.compareFilter:   true
@AbapCatalog.preserveKey:              true
@AccessControl.authorizationCheck:     #CHECK
@AccessControl.personalData.blocking:  #REQUIRED
@ClientHandling.algorithm:             #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory:   #L
@ObjectModel.usageType.dataClass:      #MASTER
@VDM.viewType:                         #BASIC 
@VDM.lifecycle.contract.type:          #NONE

@EndUserText.label:                    'Core View BP Transp Sales Representative'


define view I_BPTranspSalesRepresentative
  //There is no general basic view for but050. Replace when available so that we do not directly access database table but050!

  as select from but050
  association [1..1] to I_BusinessPartner as _BusinessPartnerTranspSalesRep on _BusinessPartnerTranspSalesRep.BusinessPartner = $projection.TranspSalesRepresentative
  association [1..1] to I_BusinessPartner as _BusinessPartner               on _BusinessPartner.BusinessPartner               = $projection.BusinessPartner

{
  key  but050.relnr         as             RelationshipNumber,
       @ObjectModel.foreignKey.association: '_BusinessPartnerTranspSalesRep'
  key  partner1             as             TranspSalesRepresentative,
       @ObjectModel.foreignKey.association: '_BusinessPartner'
  key  partner2             as             BusinessPartner,
       @Semantics.businessDate.to
  key  date_to              as             ValidityEndDate,
       @Semantics.businessDate.from
       date_from            as             ValidityStartDate,
       reltyp               as             RelationshipCategory,
       _BusinessPartnerTranspSalesRep,
       _BusinessPartner,
       _BusinessPartner.AuthorizationGroup,
       _BusinessPartner.IsBusinessPurposeCompleted
}
where
  reltyp = 'TM0001' //Relationship Is Sales Representative (Subsidiary/ Agent)

Learn More