I_BusinessPartnerCustomerTP_2

DDL: I_BUSINESSPARTNERCUSTOMERTP_2 Type: view_entity TRANSACTIONAL

Business Partner Customer

I_BusinessPartnerCustomerTP_2 is a Transactional CDS View that provides data about "Business Partner Customer" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerCustomer) and exposes 73 fields with key fields Customer, BusinessPartner. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerCustomer BusinessPartnerCustomer from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Supplier_VH _SupplierValueHelp $projection.Supplier = _SupplierValueHelp.Supplier
[0..1] I_Customer_VH _AlternativePayerValueHelp $projection.AlternativePayerAccount = _AlternativePayerValueHelp.Customer

Annotations (8)

NameValueLevelField
EndUserText.label Business Partner Customer view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY Customer I_BusinessPartnerCustomer Customer
KEY BusinessPartner I_BusinessPartnerCustomer BusinessPartner
CustomerForEdit I_BusinessPartnerCustomer Customer
BusinessPartnerUUID I_BusinessPartnerCustomer BusinessPartnerUUID
CustomerAccountGroup I_BusinessPartnerCustomer CustomerAccountGroup
AlternativePayerAccount I_BusinessPartnerCustomer AlternativePayerAccount
DataMediumExchangeIndicator I_BusinessPartnerCustomer DataMediumExchangeIndicator
Supplier I_BusinessPartnerCustomer Supplier
CustomerClassification I_BusinessPartnerCustomer CustomerClassification
VATLiability I_BusinessPartnerCustomer VATLiability
PostingIsBlocked I_BusinessPartnerCustomer PostingIsBlocked
DeliveryIsBlocked I_BusinessPartnerCustomer DeliveryIsBlocked
BillingIsBlockedForCustomer I_BusinessPartnerCustomer BillingIsBlockedForCustomer
OrderIsBlockedForCustomer I_BusinessPartnerCustomer OrderIsBlockedForCustomer
IsNaturalPerson I_BusinessPartnerCustomer IsNaturalPerson
BusinessPartnerGrouping I_BusinessPartnerCustomer BusinessPartnerGrouping
AuthorizationGroup I_BusinessPartnerCustomer AuthorizationGroup
DeliveryDateTypeRule I_BusinessPartnerCustomer DeliveryDateTypeRule
ExpressTrainStationName I_BusinessPartnerCustomer ExpressTrainStationName
TrainStationName I_BusinessPartnerCustomer TrainStationName
CityLocationCoordinatesCode I_BusinessPartnerCustomer CityLocationCoordinatesCode
Plant I_BusinessPartnerCustomer Plant
CustomerCorporateGroup I_BusinessPartnerCustomer CustomerCorporateGroup
DataExchangeInstructionKey I_BusinessPartnerCustomer DataExchangeInstructionKey
IndustryCode1 I_BusinessPartnerCustomer IndustryCode1
IndustryCode2 I_BusinessPartnerCustomer IndustryCode2
IndustryCode3 I_BusinessPartnerCustomer IndustryCode3
IsCompetitor I_BusinessPartnerCustomer IsCompetitor
IsSalesPartner I_BusinessPartnerCustomer IsSalesPartner
IsDefaultSoldToParty I_BusinessPartnerCustomer IsDefaultSoldToParty
IsConsumer I_BusinessPartnerCustomer IsConsumer
FiscalAddress I_BusinessPartnerCustomer FiscalAddress
FreeDefinedAttribute03 I_BusinessPartnerCustomer FreeDefinedAttribute03
CustomerConditionGroup1 I_BusinessPartnerCustomer CustomerConditionGroup1
CustomerConditionGroup2 I_BusinessPartnerCustomer CustomerConditionGroup2
CustomerConditionGroup3 I_BusinessPartnerCustomer CustomerConditionGroup3
CustomerConditionGroup4 I_BusinessPartnerCustomer CustomerConditionGroup4
CustomerConditionGroup5 I_BusinessPartnerCustomer CustomerConditionGroup5
AddressID I_BusinessPartnerCustomer AddressID
InternationalLocationNumber1 I_BusinessPartnerCustomer InternationalLocationNumber1
InternationalLocationNumber2 I_BusinessPartnerCustomer InternationalLocationNumber2
InternationalLocationNumber3 I_BusinessPartnerCustomer InternationalLocationNumber3
CityCode I_BusinessPartnerCustomer CityCode
County I_BusinessPartnerCustomer County
CustomerHasUnloadingPoint I_BusinessPartnerCustomer CustomerHasUnloadingPoint
CustomerWorkingTimeCalendar I_BusinessPartnerCustomer CustomerWorkingTimeCalendar
IsBusinessPurposeCompleted I_BusinessPartnerCustomer IsBusinessPurposeCompleted
BPIsEqualizationTaxSubject I_BusinessPartnerCustomer BPIsEqualizationTaxSubject
Country I_BusinessPartnerCustomer Country
Region I_BusinessPartnerCustomer Region
DeletionIndicator I_BusinessPartnerCustomer DeletionIndicator
Language I_BusinessPartnerCustomer Language
SalesIsBlockedForCustomer I_BusinessPartnerCustomer SalesIsBlockedForCustomer
PaymentReason I_BusinessPartnerCustomer PaymentReason
CustomerCentralDeletionIsBlock I_BusinessPartnerCustomer CustomerCentralDeletionIsBlock
AlternativePayerIsAllowed I_BusinessPartnerCustomer AlternativePayerIsAllowed
BPPlannedAnnualSalesYear I_BusinessPartnerCustomer BPPlannedAnnualSalesYear
BPPlannedAnnualSalesCurrency I_BusinessPartnerCustomer BPPlannedAnnualSalesCurrency
BPPlannedAnnualSalesAmount I_BusinessPartnerCustomer BPPlannedAnnualSalesAmount
CustomerTradingPartnerID I_BusinessPartnerCustomer CustomerTradingPartnerId
FiscalYearVariant I_BusinessPartnerCustomer FiscalYearVariant
AccountTaxType I_BusinessPartnerCustomer AccountTaxType
IndustryCode4 I_BusinessPartnerCustomer IndustryCode4
IndustryCode5 I_BusinessPartnerCustomer IndustryCode5
TaxInvoiceRepresentativeName I_BusinessPartnerCustomer TaxInvoiceRepresentativeName
BusinessType I_BusinessPartnerCustomer BusinessType
IndustryType I_BusinessPartnerCustomer IndustryType
LastChangedByUser _BusinessPartner LastChangedByUser
LastChangeDate _BusinessPartner LastChangeDate
LastChangeTime _BusinessPartner LastChangeTime
_BusinessPartner _BusinessPartner
_SupplierValueHelp _SupplierValueHelp
_AlternativePayerValueHelp _AlternativePayerValueHelp
@EndUserText.label: 'Business Partner Customer'
@VDM.viewType: #TRANSACTIONAL
@AccessControl: {
   authorizationCheck: #CHECK,
   personalData.blocking: #REQUIRED
}
@ObjectModel:{
 usageType: {
   serviceQuality: #D,
   sizeCategory: #XXL,
   dataClass: #TRANSACTIONAL
  }
}
@Metadata.ignorePropagatedAnnotations: true
define view entity I_BusinessPartnerCustomerTP_2 as select from I_BusinessPartnerCustomer  as BusinessPartnerCustomer

 association to parent I_BusinessPartnerTP_2          as _BusinessPartner      on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
                                                                                 //and $projection.bpdrftuuid  = _BusinessPartner.BPDrftUUID


// composition [0..*] of I_CustomerSalesAreaTP           as _CustomerSalesArea

// composition [0..*] of I_CustomerCompanyCodeTP         as _CustomerCompanyCode

// composition [0..*] of I_CustomerUnloadingPointTP      as _CustomerUnloadingPoint

 association [0..1] to I_Supplier_VH                   as _SupplierValueHelp           on  $projection.Supplier = _SupplierValueHelp.Supplier
 association [0..1] to I_Customer_VH                   as _AlternativePayerValueHelp   on  $projection.AlternativePayerAccount = _AlternativePayerValueHelp.Customer
 {
  //key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

  //key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as CustomerDrftUUID,

  key BusinessPartnerCustomer.Customer,
  key BusinessPartnerCustomer.BusinessPartner,
      @ObjectModel.editableFieldFor: 'Customer'
      BusinessPartnerCustomer.Customer as CustomerForEdit,
      BusinessPartnerCustomer.BusinessPartnerUUID,
      BusinessPartnerCustomer.CustomerAccountGroup,
      @Consumption.valueHelp: '_AlternativePayerValueHelp'
      @ObjectModel.foreignKey.association: '_AlternativePayerValueHelp'
      BusinessPartnerCustomer.AlternativePayerAccount,
      BusinessPartnerCustomer.DataMediumExchangeIndicator,
      @Consumption.valueHelp: '_SupplierValueHelp'
      @ObjectModel.foreignKey.association: '_SupplierValueHelp'
      BusinessPartnerCustomer.Supplier,
      BusinessPartnerCustomer.CustomerClassification,
      BusinessPartnerCustomer.VATLiability,
      BusinessPartnerCustomer.PostingIsBlocked,
      BusinessPartnerCustomer.DeliveryIsBlocked,
      BusinessPartnerCustomer.BillingIsBlockedForCustomer,
      BusinessPartnerCustomer.OrderIsBlockedForCustomer,
      @Semantics.booleanIndicator:true
      BusinessPartnerCustomer.IsNaturalPerson,
      BusinessPartnerCustomer.BusinessPartnerGrouping,
      BusinessPartnerCustomer.AuthorizationGroup,
      BusinessPartnerCustomer.DeliveryDateTypeRule,
      BusinessPartnerCustomer.ExpressTrainStationName,
      BusinessPartnerCustomer.TrainStationName,
      BusinessPartnerCustomer.CityLocationCoordinatesCode,
      BusinessPartnerCustomer.Plant,
      BusinessPartnerCustomer.CustomerCorporateGroup,
      BusinessPartnerCustomer.DataExchangeInstructionKey,
      BusinessPartnerCustomer.IndustryCode1,
      BusinessPartnerCustomer.IndustryCode2,
      BusinessPartnerCustomer.IndustryCode3,
      BusinessPartnerCustomer.IsCompetitor,
      BusinessPartnerCustomer.IsSalesPartner,
      BusinessPartnerCustomer.IsDefaultSoldToParty,
      BusinessPartnerCustomer.IsConsumer,
      BusinessPartnerCustomer.FiscalAddress,
      BusinessPartnerCustomer.FreeDefinedAttribute03,
      BusinessPartnerCustomer.CustomerConditionGroup1,
      BusinessPartnerCustomer.CustomerConditionGroup2,
      BusinessPartnerCustomer.CustomerConditionGroup3,
      BusinessPartnerCustomer.CustomerConditionGroup4,
      BusinessPartnerCustomer.CustomerConditionGroup5,
      BusinessPartnerCustomer.AddressID,
      BusinessPartnerCustomer.InternationalLocationNumber1,
      BusinessPartnerCustomer.InternationalLocationNumber2,
      BusinessPartnerCustomer.InternationalLocationNumber3,
      BusinessPartnerCustomer.CityCode,
      BusinessPartnerCustomer.County,
      BusinessPartnerCustomer.CustomerHasUnloadingPoint,
      BusinessPartnerCustomer.CustomerWorkingTimeCalendar,
      @Semantics.booleanIndicator:true
      BusinessPartnerCustomer.IsBusinessPurposeCompleted,
      BusinessPartnerCustomer.BPIsEqualizationTaxSubject,
      BusinessPartnerCustomer.Country,
      BusinessPartnerCustomer.Region,
      BusinessPartnerCustomer.DeletionIndicator,
      BusinessPartnerCustomer.Language,
      @Semantics.booleanIndicator:true
      BusinessPartnerCustomer.SalesIsBlockedForCustomer,
      BusinessPartnerCustomer.PaymentReason,
      BusinessPartnerCustomer.CustomerCentralDeletionIsBlock,
      //Field addition for ODM-MDI mapping

      BusinessPartnerCustomer.AlternativePayerIsAllowed,
      BusinessPartnerCustomer.BPPlannedAnnualSalesYear,
      BusinessPartnerCustomer.BPPlannedAnnualSalesCurrency,
      @Semantics.amount.currencyCode: 'BPPlannedAnnualSalesCurrency'
      BusinessPartnerCustomer.BPPlannedAnnualSalesAmount,
      BusinessPartnerCustomer.CustomerTradingPartnerId as CustomerTradingPartnerID,
      BusinessPartnerCustomer.FiscalYearVariant,
      BusinessPartnerCustomer.AccountTaxType,
      BusinessPartnerCustomer.IndustryCode4,
      BusinessPartnerCustomer.IndustryCode5,
      BusinessPartnerCustomer.TaxInvoiceRepresentativeName,
      BusinessPartnerCustomer.BusinessType,
      BusinessPartnerCustomer.IndustryType, 
      _BusinessPartner.LastChangedByUser, 
      _BusinessPartner.LastChangeDate,
      _BusinessPartner.LastChangeTime,  
      
      
      _BusinessPartner,
//      _CustomerSalesArea,

//      _CustomerCompanyCode,

   //   _CustomerUnloadingPoint,

      _SupplierValueHelp,
      _AlternativePayerValueHelp
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERCUSTOMER",
"I_BUSINESSPARTNERTP_2"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP_2",
"I_CUSTOMER_VH",
"I_SUPPLIER_VH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/