C_BusinessPartnerCustomerTP_2

DDL: C_BUSINESSPARTNERCUSTOMERTP_2 Type: view_entity CONSUMPTION
67 Fields 1 Data Sources 2 OData Services

Business Partner Customer

C_BusinessPartnerCustomerTP_2 is a Consumption CDS View that provides data about "Business Partner Customer" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerCustomerTP_2) and exposes 67 fields with key fields Customer, BusinessPartner. It is exposed through 2 OData services (BUSINESSPARTNERCUSTOMER_SRV, X_C_BUSPARTCUSTOMERTP_2_SRV).

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerCustomerTP_2 I_BusinessPartnerCustomerTP_2 projection

Annotations (8)

NameValueLevelField
EndUserText.label Business Partner Customer 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.allowExtensions true view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
BUSINESSPARTNERCUSTOMER_SRV BUSINESSPARTNERCUSTOMER V2 C1 NOT_RELEASED
X_C_BUSPARTCUSTOMERTP_2_SRV X_C_BUSPARTCUSTOMERTP_SRV V2 C1 NOT_RELEASED

Fields (67)

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

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 C_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 C_BusinessPartnerCustomerTP_2 AS
SELECT
  Customer,
  BusinessPartner,
  CustomerForEdit,
  BusinessPartnerUUID,
  CustomerAccountGroup,
  AlternativePayerAccount,
  DataMediumExchangeIndicator,
  Supplier,
  CustomerClassification,
  VATLiability,
  PostingIsBlocked,
  DeliveryIsBlocked,
  BillingIsBlockedForCustomer,
  OrderIsBlockedForCustomer,
  IsNaturalPerson,
  BusinessPartnerGrouping,
  AuthorizationGroup,
  DeliveryDateTypeRule,
  ExpressTrainStationName,
  TrainStationName,
  CityLocationCoordinatesCode,
  Plant,
  CustomerCorporateGroup,
  DataExchangeInstructionKey,
  IndustryCode1,
  IndustryCode2,
  IndustryCode3,
  IndustryCode4,
  IndustryCode5,
  IsCompetitor,
  IsSalesPartner,
  IsDefaultSoldToParty,
  IsConsumer,
  FiscalAddress,
  FreeDefinedAttribute03,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  AddressID,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  CityCode,
  County,
  CustomerHasUnloadingPoint,
  CustomerWorkingTimeCalendar,
  IsBusinessPurposeCompleted,
  BPIsEqualizationTaxSubject,
  Country,
  Region,
  DeletionIndicator,
  Language,
  SalesIsBlockedForCustomer,
  PaymentReason,
  CustomerCentralDeletionIsBlock,
  AlternativePayerIsAllowed,
  BPPlannedAnnualSalesYear,
  BPPlannedAnnualSalesCurrency,
  BPPlannedAnnualSalesAmount,
  CustomerTradingPartnerID,
  FiscalYearVariant,
  AccountTaxType,
  TaxInvoiceRepresentativeName,
  BusinessType,
  IndustryType
FROM I_BusinessPartnerCustomerTP_2
;

Learn More