I_BPCustDeptAddrDepdntInfoTP

DDL: I_BPCUSTDEPTADDRDEPDNTINFOTP SQL: ICUSDEPADDEPTP Type: view TRANSACTIONAL

TP view for CustDep AddrDepInfo

I_BPCustDeptAddrDepdntInfoTP is a Transactional CDS View that provides data about "TP view for CustDep AddrDepInfo" in SAP S/4HANA. It reads from 1 data source (I_CustDepartmentAddrDepdntInfo) and exposes 16 fields with key fields Customer, AddressID, BusinessPartner, CustomerDepartment. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustDepartmentAddrDepdntInfo BPCustDeptAddrDepdntInfoTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.businesspartner = _BusinessPartner.BusinessPartner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICUSDEPADDEPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence IBPADDRDEP_D view
ObjectModel.writeEnabled true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP view for CustDep AddrDepInfo 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 (16)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY AddressID AddressID
KEY BusinessPartner
KEY CustomerDepartment CustomerDepartment
AddressIDForEdit AddressID
CustomerForEdit Customer
CustomerDepartmentForEdit CustomerDepartment
ReceivingPoint ReceivingPoint
RetailLocationSellingAreaSize RetailLocationSellingAreaSize
RetailLocationSellingAreaUnit RetailLocationSellingAreaUnit
DepartmentLayout DepartmentLayout
DepartmentLayoutAreaSchema DepartmentLayoutAreaSchema
BusinessPartnerForEdit
FormattedAddress
_Customer _Customer
_BusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'ICUSDEPADDEPTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeDraftPersistence: 'IBPADDRDEP_D'
@ObjectModel.writeEnabled: true

@ObjectModel.semanticKey: ['Customer', 'AddressID', 'BusinessPartner', 'CustomerDepartment']
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP view for CustDep AddrDepInfo'
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true


define view I_BPCustDeptAddrDepdntInfoTP
  as select from I_CustDepartmentAddrDepdntInfo as BPCustDeptAddrDepdntInfoTP
  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.businesspartner = _BusinessPartner.BusinessPartner
  
{

  key Customer,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key AddressID,
  key _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
  key CustomerDepartment,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      AddressID                                                                  as AddressIDForEdit,

      Customer                                                                   as CustomerForEdit,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustomerDepartment                                                         as CustomerDepartmentForEdit,
      ReceivingPoint,
      RetailLocationSellingAreaSize,
      RetailLocationSellingAreaUnit,
      DepartmentLayout,
      DepartmentLayoutAreaSchema,
      _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner      as BusinessPartnerForEdit,

      cast( '                                        ' as abap.sstring( 260 )  ) as FormattedAddress,
      /* Associations */
    //  _Address,

      _Customer,

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTDEPARTMENTADDRDEPDNTINFO",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP",
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTDEPARTMENTADDRDEPDNTINFO"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/