I_BPCustAddressDependentInfoTP

DDL: I_BPCUSTADDRESSDEPENDENTINFOTP SQL: ICUSTADDRDEPTP Type: view TRANSACTIONAL Package: VDM_MD_BP

TP View for Addr Dep Customer General

I_BPCustAddressDependentInfoTP is a Transactional CDS View that provides data about "TP View for Addr Dep Customer General" in SAP S/4HANA. It reads from 1 data source (I_CustAddrDepdntInformation) and exposes 18 fields with key fields AddressID, BusinessPartner, Customer. It has 3 associations to related views. Part of development package VDM_MD_BP.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_CustAddrDepdntInformation CustAddrDepdntInformation from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.businesspartner = _BusinessPartner.BusinessPartner
[0..1] E_CustAddrDepdntInformation _ActiveExtension $projection.Customer = _ActiveExtension.Customer and $projection.AddressID = _ActiveExtension.AddressID
[0..1] E_CustAddrDepdntInformation _DraftExtension $projection.Customer = _DraftExtension.Customer and $projection.AddressID = _DraftExtension.AddressID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTADDRDEPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label TP View for Addr Dep Customer General view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BPCUSTADDRDTP_D view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_CustAddrDepdntInformation AddressID
KEY BusinessPartner
KEY Customer I_CustAddrDepdntInformation Customer
ExpressTrainStationName I_CustAddrDepdntInformation ExpressTrainStationName
TrainStationName I_CustAddrDepdntInformation TrainStationName
CityCode I_CustAddrDepdntInformation CityCode
County I_CustAddrDepdntInformation County
CustomerForEdit I_CustAddrDepdntInformation Customer
AddressIDForEdit I_CustAddrDepdntInformation AddressID
BusinessPartnerForEdit
BusinessPartnerUUID
BusinessPartnerCategory
Region
Country
FormattedAddress
ShipToPartyFormattedAddress
_Customer _Customer
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'ICUSTADDRDEPTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'TP View for Addr Dep Customer General'

@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.writeEnabled: true
@ObjectModel.writeDraftPersistence: 'BPCUSTADDRDTP_D'

@ObjectModel.semanticKey: ['BusinessPartner', 'AddressID', 'Customer']
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@Search.searchable: true
define view I_BPCustAddressDependentInfoTP
  as select from I_CustAddrDepdntInformation as CustAddrDepdntInformation

association [1..1] to I_BusinessPartnerTP as _BusinessPartner on  $projection.businesspartner = _BusinessPartner.BusinessPartner
association [0..1] to E_CustAddrDepdntInformation         as _ActiveExtension on $projection.Customer = _ActiveExtension.Customer
                                                                              and $projection.AddressID = _ActiveExtension.AddressID
association [0..1] to E_CustAddrDepdntInformation         as _DraftExtension  on $projection.Customer = _DraftExtension.Customer
                                                                              and $projection.AddressID = _DraftExtension.AddressID

{
      
  key CustAddrDepdntInformation.AddressID,
  key CustAddrDepdntInformation._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
  key CustAddrDepdntInformation.Customer,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      CustAddrDepdntInformation.ExpressTrainStationName,
      CustAddrDepdntInformation.TrainStationName,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustAddrDepdntInformation.CityCode,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustAddrDepdntInformation.County,

      CustAddrDepdntInformation.Customer                                                                      as CustomerForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustAddrDepdntInformation.AddressID                                                             as AddressIDForEdit,
      CustAddrDepdntInformation._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartnerForEdit,
      CustAddrDepdntInformation._Customer._CustomerToBusinessPartner.BusinessPartnerUUID,
      
      CustAddrDepdntInformation._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory,

      cast( '   ' as  regio ) as  Region,  
      cast( '   ' as  land1 ) as  Country,  
      

      cast( '                                           ' as  abap.sstring( 260 ) )                       as FormattedAddress,
      
      
      @ObjectModel.readOnly: true
      cast( '                                           ' as  abap.sstring( 260 ) )                       as ShipToPartyFormattedAddress,
 
           
      /* Associations */
      _Customer,
//      _Address,

 

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartner


}

Learn More