I_BusinessPartnerCustomerTP_2
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)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartnerCustomer | BusinessPartnerCustomer | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Supplier_VH | _SupplierValueHelp | $projection.Supplier = _SupplierValueHelp.Supplier |
| [0..1] | I_Customer_VH | _AlternativePayerValueHelp | $projection.AlternativePayerAccount = _AlternativePayerValueHelp.Customer |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA