C_BPRelshpCntctMblNmbrTP_2

DDL: C_BPRELSHPCNTCTMBLNMBRTP_2 Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 1 OData Services

Projection for Contact Mobile Number

C_BPRelshpCntctMblNmbrTP_2 is a Consumption CDS View that provides data about "Projection for Contact Mobile Number" in SAP S/4HANA. It reads from 1 data source (I_BPRelshpCntctPersnMblNmbrTP) and exposes 20 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, AddressID. It is exposed through 1 OData service (C_BUSINESSPARTNERTP_2_SRV).

Data Sources (1)

SourceAliasJoin Type
I_BPRelshpCntctPersnMblNmbrTP I_BPRelshpCntctPersnMblNmbrTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Projection for Contact Mobile Number view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSINESSPARTNERTP_2_SRV C_BUSINESSPARTNERTP_2_SRV V2 C1 NOT_RELEASED

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartner1 Partner
KEY BusinessPartner2 BusinessPartner2 Partner
KEY ValidityEndDate ValidityEndDate ValidTo
KEY RelationshipCategory RelationshipCategory Relationsh.Cat.
KEY AddressID AddressID Ship-to address
KEY OrdinalNumber OrdinalNumber Sequence Number
KEY BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
OrdinalNumberForEdit OrdinalNumberForEdit Sequence Number
RelationshipNumber RelationshipNumber BP Rel. Number
DestinationLocationCountry DestinationLocationCountry Country/Region
TelephoneCountryPrefix TelephoneCountryPrefix Tel. to
IsDefaultPhoneNumber IsDefaultPhoneNumber TRUE
CommNumberIsNotUsed CommNumberIsNotUsed Do not use
PhoneNumber PhoneNumber Telephone no.
PhoneIsSMSEnabled PhoneIsSMSEnabled SMS-Enab.
PhoneNumberType PhoneNumberType Phone number type
AddressCommunicationRemarkText AddressCommunicationRemarkText Notes
CountryNameasCountryNamelocalized
_BusinessPartner1 _BusinessPartner1
_BusinessPartner2 _BusinessPartner2

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_BPRelshpCntctMblNmbrTP_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_BPRelshpCntctMblNmbrTP_2 AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  AddressID,
  OrdinalNumber,
  BPRelshpCatIsInFwdDirection,
  OrdinalNumberForEdit,
  RelationshipNumber,
  DestinationLocationCountry,
  TelephoneCountryPrefix,
  IsDefaultPhoneNumber,
  CommNumberIsNotUsed,
  PhoneNumber,
  PhoneIsSMSEnabled,
  PhoneNumberType,
  AddressCommunicationRemarkText,
  _CountryPrefix._CountryText.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized
FROM I_BPRelshpCntctPersnMblNmbrTP
;

Learn More