I_BusinessPartnerCustomerTP_2

DDL: I_BUSINESSPARTNERCUSTOMERTP_2 Type: view_entity TRANSACTIONAL
73 Fields 1 Data Sources 2 Associations

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 Sold-to Party
KEY BusinessPartner I_BusinessPartnerCustomer BusinessPartner Issuing Authority
CustomerForEdit I_BusinessPartnerCustomer Customer Sold-to Party
BusinessPartnerUUID I_BusinessPartnerCustomer BusinessPartnerUUID UUID
CustomerAccountGroup I_BusinessPartnerCustomer CustomerAccountGroup Account group
AlternativePayerAccount I_BusinessPartnerCustomer AlternativePayerAccount Alternat.payer
DataMediumExchangeIndicator I_BusinessPartnerCustomer DataMediumExchangeIndicator DME Rec. Code
Supplier I_BusinessPartnerCustomer Supplier Supplier
CustomerClassification I_BusinessPartnerCustomer CustomerClassification Customer Class.
VATLiability I_BusinessPartnerCustomer VATLiability Liable for VAT
PostingIsBlocked I_BusinessPartnerCustomer PostingIsBlocked Posting Block
DeliveryIsBlocked I_BusinessPartnerCustomer DeliveryIsBlocked Delivery block
BillingIsBlockedForCustomer I_BusinessPartnerCustomer BillingIsBlockedForCustomer Billing block
OrderIsBlockedForCustomer I_BusinessPartnerCustomer OrderIsBlockedForCustomer Order block
IsNaturalPerson I_BusinessPartnerCustomer IsNaturalPerson Natural person
BusinessPartnerGrouping I_BusinessPartnerCustomer BusinessPartnerGrouping Grouping
AuthorizationGroup I_BusinessPartnerCustomer AuthorizationGroup AuthorizGroup
DeliveryDateTypeRule I_BusinessPartnerCustomer DeliveryDateTypeRule Deliv Date Rule
ExpressTrainStationName I_BusinessPartnerCustomer ExpressTrainStationName Express station
TrainStationName I_BusinessPartnerCustomer TrainStationName Train station
CityLocationCoordinatesCode I_BusinessPartnerCustomer CityLocationCoordinatesCode Location code
Plant I_BusinessPartnerCustomer Plant Valuation Area
CustomerCorporateGroup I_BusinessPartnerCustomer CustomerCorporateGroup Group
DataExchangeInstructionKey I_BusinessPartnerCustomer DataExchangeInstructionKey Instruction Key
IndustryCode1 I_BusinessPartnerCustomer IndustryCode1 Industry code 1
IndustryCode2 I_BusinessPartnerCustomer IndustryCode2 Industry code 2
IndustryCode3 I_BusinessPartnerCustomer IndustryCode3 Industry code 3
IsCompetitor I_BusinessPartnerCustomer IsCompetitor Competitors
IsSalesPartner I_BusinessPartnerCustomer IsSalesPartner Sales partner
IsDefaultSoldToParty I_BusinessPartnerCustomer IsDefaultSoldToParty Default SP
IsConsumer I_BusinessPartnerCustomer IsConsumer Consumer
FiscalAddress I_BusinessPartnerCustomer FiscalAddress Fiscal address
FreeDefinedAttribute03 I_BusinessPartnerCustomer FreeDefinedAttribute03 Attribute 3
CustomerConditionGroup1 I_BusinessPartnerCustomer CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 I_BusinessPartnerCustomer CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 I_BusinessPartnerCustomer CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 I_BusinessPartnerCustomer CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 I_BusinessPartnerCustomer CustomerConditionGroup5 Condition grp 5
AddressID I_BusinessPartnerCustomer AddressID Ship-to address
InternationalLocationNumber1 I_BusinessPartnerCustomer InternationalLocationNumber1 Location no. 1
InternationalLocationNumber2 I_BusinessPartnerCustomer InternationalLocationNumber2 Location no. 2
InternationalLocationNumber3 I_BusinessPartnerCustomer InternationalLocationNumber3 Check digit
CityCode I_BusinessPartnerCustomer CityCode IATA: City
County I_BusinessPartnerCustomer County Wyoming County
CustomerHasUnloadingPoint I_BusinessPartnerCustomer CustomerHasUnloadingPoint Unloading pts
CustomerWorkingTimeCalendar I_BusinessPartnerCustomer CustomerWorkingTimeCalendar Working times
IsBusinessPurposeCompleted I_BusinessPartnerCustomer IsBusinessPurposeCompleted Purpose Completed
BPIsEqualizationTaxSubject I_BusinessPartnerCustomer BPIsEqualizationTaxSubject Equalizatn tax
Country I_BusinessPartnerCustomer Country Venue: Ctry/Reg
Region I_BusinessPartnerCustomer Region Venue Region
DeletionIndicator I_BusinessPartnerCustomer DeletionIndicator Deletion Ind.
Language I_BusinessPartnerCustomer Language Report Text Language
SalesIsBlockedForCustomer I_BusinessPartnerCustomer SalesIsBlockedForCustomer
PaymentReason I_BusinessPartnerCustomer PaymentReason Payment Reason
CustomerCentralDeletionIsBlock I_BusinessPartnerCustomer CustomerCentralDeletionIsBlock Deletion block
AlternativePayerIsAllowed I_BusinessPartnerCustomer AlternativePayerIsAllowed Al.payer in doc
BPPlannedAnnualSalesYear I_BusinessPartnerCustomer BPPlannedAnnualSalesYear Sales year
BPPlannedAnnualSalesCurrency I_BusinessPartnerCustomer BPPlannedAnnualSalesCurrency Currency
BPPlannedAnnualSalesAmount I_BusinessPartnerCustomer BPPlannedAnnualSalesAmount Annual sales
CustomerTradingPartnerID I_BusinessPartnerCustomer CustomerTradingPartnerId Trading Partner
FiscalYearVariant I_BusinessPartnerCustomer FiscalYearVariant FY Variant
AccountTaxType I_BusinessPartnerCustomer AccountTaxType Tax Type
IndustryCode4 I_BusinessPartnerCustomer IndustryCode4 Industry code 4
IndustryCode5 I_BusinessPartnerCustomer IndustryCode5 Industry code 5
TaxInvoiceRepresentativeName I_BusinessPartnerCustomer TaxInvoiceRepresentativeName Rep's Name
BusinessType I_BusinessPartnerCustomer BusinessType Type of Business
IndustryType I_BusinessPartnerCustomer IndustryType Type of Industry
LastChangedByUser _BusinessPartner LastChangedByUser User Name
LastChangeDate _BusinessPartner LastChangeDate Time Stamp
LastChangeTime _BusinessPartner LastChangeTime Time changed
_BusinessPartner _BusinessPartner
_SupplierValueHelp _SupplierValueHelp
_AlternativePayerValueHelp _AlternativePayerValueHelp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BusinessPartnerCustomerTP_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BusinessPartnerCustomerTP_2 AS
SELECT
  BusinessPartnerCustomer.Customer AS Customer,
  BusinessPartnerCustomer.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustomer.Customer AS CustomerForEdit,
  BusinessPartnerCustomer.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerCustomer.CustomerAccountGroup AS CustomerAccountGroup,
  BusinessPartnerCustomer.AlternativePayerAccount AS AlternativePayerAccount,
  BusinessPartnerCustomer.DataMediumExchangeIndicator AS DataMediumExchangeIndicator,
  BusinessPartnerCustomer.Supplier AS Supplier,
  BusinessPartnerCustomer.CustomerClassification AS CustomerClassification,
  BusinessPartnerCustomer.VATLiability AS VATLiability,
  BusinessPartnerCustomer.PostingIsBlocked AS PostingIsBlocked,
  BusinessPartnerCustomer.DeliveryIsBlocked AS DeliveryIsBlocked,
  BusinessPartnerCustomer.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  BusinessPartnerCustomer.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  BusinessPartnerCustomer.IsNaturalPerson AS IsNaturalPerson,
  BusinessPartnerCustomer.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  BusinessPartnerCustomer.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerCustomer.DeliveryDateTypeRule AS DeliveryDateTypeRule,
  BusinessPartnerCustomer.ExpressTrainStationName AS ExpressTrainStationName,
  BusinessPartnerCustomer.TrainStationName AS TrainStationName,
  BusinessPartnerCustomer.CityLocationCoordinatesCode AS CityLocationCoordinatesCode,
  BusinessPartnerCustomer.Plant AS Plant,
  BusinessPartnerCustomer.CustomerCorporateGroup AS CustomerCorporateGroup,
  BusinessPartnerCustomer.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  BusinessPartnerCustomer.IndustryCode1 AS IndustryCode1,
  BusinessPartnerCustomer.IndustryCode2 AS IndustryCode2,
  BusinessPartnerCustomer.IndustryCode3 AS IndustryCode3,
  BusinessPartnerCustomer.IsCompetitor AS IsCompetitor,
  BusinessPartnerCustomer.IsSalesPartner AS IsSalesPartner,
  BusinessPartnerCustomer.IsDefaultSoldToParty AS IsDefaultSoldToParty,
  BusinessPartnerCustomer.IsConsumer AS IsConsumer,
  BusinessPartnerCustomer.FiscalAddress AS FiscalAddress,
  BusinessPartnerCustomer.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  BusinessPartnerCustomer.CustomerConditionGroup1 AS CustomerConditionGroup1,
  BusinessPartnerCustomer.CustomerConditionGroup2 AS CustomerConditionGroup2,
  BusinessPartnerCustomer.CustomerConditionGroup3 AS CustomerConditionGroup3,
  BusinessPartnerCustomer.CustomerConditionGroup4 AS CustomerConditionGroup4,
  BusinessPartnerCustomer.CustomerConditionGroup5 AS CustomerConditionGroup5,
  BusinessPartnerCustomer.AddressID AS AddressID,
  BusinessPartnerCustomer.InternationalLocationNumber1 AS InternationalLocationNumber1,
  BusinessPartnerCustomer.InternationalLocationNumber2 AS InternationalLocationNumber2,
  BusinessPartnerCustomer.InternationalLocationNumber3 AS InternationalLocationNumber3,
  BusinessPartnerCustomer.CityCode AS CityCode,
  BusinessPartnerCustomer.County AS County,
  BusinessPartnerCustomer.CustomerHasUnloadingPoint AS CustomerHasUnloadingPoint,
  BusinessPartnerCustomer.CustomerWorkingTimeCalendar AS CustomerWorkingTimeCalendar,
  BusinessPartnerCustomer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BusinessPartnerCustomer.BPIsEqualizationTaxSubject AS BPIsEqualizationTaxSubject,
  BusinessPartnerCustomer.Country AS Country,
  BusinessPartnerCustomer.Region AS Region,
  BusinessPartnerCustomer.DeletionIndicator AS DeletionIndicator,
  BusinessPartnerCustomer.Language AS Language,
  BusinessPartnerCustomer.SalesIsBlockedForCustomer AS SalesIsBlockedForCustomer,
  BusinessPartnerCustomer.PaymentReason AS PaymentReason,
  BusinessPartnerCustomer.CustomerCentralDeletionIsBlock AS CustomerCentralDeletionIsBlock,
  BusinessPartnerCustomer.AlternativePayerIsAllowed AS AlternativePayerIsAllowed,
  BusinessPartnerCustomer.BPPlannedAnnualSalesYear AS BPPlannedAnnualSalesYear,
  BusinessPartnerCustomer.BPPlannedAnnualSalesCurrency AS BPPlannedAnnualSalesCurrency,
  BusinessPartnerCustomer.BPPlannedAnnualSalesAmount AS BPPlannedAnnualSalesAmount,
  BusinessPartnerCustomer.CustomerTradingPartnerId AS CustomerTradingPartnerID,
  BusinessPartnerCustomer.FiscalYearVariant AS FiscalYearVariant,
  BusinessPartnerCustomer.AccountTaxType AS AccountTaxType,
  BusinessPartnerCustomer.IndustryCode4 AS IndustryCode4,
  BusinessPartnerCustomer.IndustryCode5 AS IndustryCode5,
  BusinessPartnerCustomer.TaxInvoiceRepresentativeName AS TaxInvoiceRepresentativeName,
  BusinessPartnerCustomer.BusinessType AS BusinessType,
  BusinessPartnerCustomer.IndustryType AS IndustryType,
  _BusinessPartner.LastChangedByUser AS LastChangedByUser,
  _BusinessPartner.LastChangeDate AS LastChangeDate,
  _BusinessPartner.LastChangeTime AS LastChangeTime
FROM I_BusinessPartnerCustomer AS BusinessPartnerCustomer
LEFT OUTER JOIN I_Supplier_VH AS _SupplierValueHelp ON Supplier = _SupplierValueHelp.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer_VH AS _AlternativePayerValueHelp ON AlternativePayerAccount = _AlternativePayerValueHelp.Customer  -- association [0..1]
;

Learn More