P_COLLABNAPPLCARRIERUSER

CDS View

P_COLLABNAPPLCARRIERUSER is a CDS View in S/4HANA. 17 CDS views read from this table.

Used by 17 CDS view(s)

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_CollabnApplFrtAgrmtRFQItem view_entity inner CONSUMPTION Freight Agreement RFQ Item
C_CollabnApplFrtOrdQtanItem view inner CONSUMPTION Transportation Order Item
C_CollabnApplFrtOrdQtanStop view inner CONSUMPTION Transportation Order Stop
C_CollabnApplFrtOrdRFQItem view inner CONSUMPTION Transportation Order Item
C_CollabnApplFrtOrdRFQStop view inner CONSUMPTION Transportation Order Stop
C_CollabnApplMngFrtOrdChrgItem view_entity inner CONSUMPTION Freight Order Item
C_CollabnApplMngFrtOrdChrgStge view_entity inner CONSUMPTION Freight Order Stage
C_CollabnApplTranspOrderItem view inner CONSUMPTION Transportation Order Item
C_CollabnApplTranspOrderStop view inner CONSUMPTION Transportation Order Stop
C_CollabnMngFrtOrdChrgElement view_entity inner CONSUMPTION Freight Order Charge Elements
P_CollabnApplFreightOrdForConf view inner CONSUMPTION Private view for confirm freight order
P_CollabnApplFreightQuotation view inner CONSUMPTION
P_CollabnApplFreightRFQ1 view inner CONSUMPTION
P_CollabnApplFrtAgrmtRFQ1 view inner CONSUMPTION Freight Agreement RFQ
P_CollabnApplFrtOrdExecStop view_entity inner CONSUMPTION Private View for FO Execution Stop
P_CollabnApplFrtOrdInExecution view_entity inner CONSUMPTION Freight Orders in Execution
P_CollabnApplMngFrtOrderCharge view inner CONSUMPTION Private View for Freight Order Charges 
@AbapCatalog.sqlViewName: 'PCOLLCARRUSR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM:   { viewType: #COMPOSITE,
          private: true
        }
define view P_CollabnApplCarrierUser
  as select from I_BPRelationship    as BPRelationship
    inner join   I_BusinessUserBasic as BusinessUser on  BPRelationship.BusinessPartnerPerson = BusinessUser.BusinessPartner
                                                     and BusinessUser.UserID                  = $session.user

{
  key BusinessPartnerCompany,
  key UserID

}
where
      BPRelationship.RelationshipCategory = 'BUR028'
  and BPRelationship.ValidityStartDate    <= $session.system_date
  and BPRelationship.ValidityEndDate      >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPRELATIONSHIP",
"I_BUSINESSUSERBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More