I_BUSINESSPARTNERTRANSP

CDS View

Core View for BP Transportation Data

I_BUSINESSPARTNERTRANSP is a CDS View in S/4HANA. Core View for BP Transportation Data. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BPTRANSPSTDCARRALPHACODE view_entity inner COMPOSITE
P_BusinessPartnerTranspIATA view_entity inner COMPOSITE 
@AbapCatalog.sqlViewName:              'IBPTRANSP'

@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 for BP Transportation Data'

define view I_BusinessPartnerTransp

  as select from /scmb/d_bptmgen as BusinessPartnerTranspData
  association [1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
{

  key BusinessPartnerTranspData.partner            as BusinessPartner,
      BusinessPartnerTranspData.carrier_conf       as CarrierConfirmationIsExpected,
      BusinessPartnerTranspData.cnfexp             as ConfirmationIsExpectedByCust,
      BusinessPartnerTranspData.carrier_cat        as CarrierCategory,
      BusinessPartnerTranspData.shipper_sec_sts    as ShipperSecurityStatus,
      BusinessPartnerTranspData.shipper_code       as KnownShipper,
      BusinessPartnerTranspData.shipper_validity   as KnownShipperExpiryDate,
      BusinessPartnerTranspData.known_date         as KnownShipperFromDate,
      BusinessPartnerTranspData.reg_ac             as RegulatedAgent,
      BusinessPartnerTranspData.reg_ag_validity    as RegulatedAgentExpiryDate,
      BusinessPartnerTranspData.cass_account       as CASSAccount,
      BusinessPartnerTranspData.iata_ac            as IATAAgent,
      BusinessPartnerTranspData.etd_offset         as EstdTimeOfDepartureOffsetHours,
      BusinessPartnerTranspData.calendar           as FactoryCalendar,
      BusinessPartnerTranspData.edi_comm_profile   as EDICommunicationProfile,
      BusinessPartnerTranspData.gr_block_by_vendor as SupplierProcurementBlock,
      _BusinessPartner.AuthorizationGroup,
      _BusinessPartner.IsBusinessPurposeCompleted,
      _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"/SCMB/D_BPTMGEN"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More