C_BusinessPartnerTP_2

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_BusinessPartnerTP_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_BusinessPartnerTP_2 AS
SELECT
  BusinessPartner,
  BusinessPartnerUUID,
  FullName,
  BusinessPartnerForEdit,
  BusinessPartnerGrouping,
  _BusinessPartnerGrouping._Text.BusinessPartnerGroupingText : localized AS BusinessPartnerGroupingTextlocalized,
  BusinessPartnerCategory,
  _BusinessPartnerCategory._Text.BusinessPartnerCategoryText : localized AS BusinessPartnerCategoryTextlocalized,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  LastChangeDate,
  LastChangeTime,
  FormOfAddress,
  _FormOfAddress._Text.FormOfAddressName : localized AS FormOfAddressNamelocalized,
  FormOfAddressPerson,
  FirstName,
  LastName,
  AdditionalLastName,
  BusinessPartnerBirthName,
  MiddleName,
  AcademicTitle,
  _AcademicTitleValueHelp._Text.AcademicTitleName : localized AS AcademicTitleNamelocalized,
  AcademicTitle2,
  BusinessPartnerSupplementName,
  _BusPartSupplementName.BusPartSupplementNameText AS BusPartSupplementNameText,
  LastNamePrefix,
  _BusPartPrefixName.LastNamePrefixName AS LastNamePrefixName,
  LastNameSecondPrefix,
  _LastNameSecondPrefixName.LastNamePrefixName AS LastNameSecondPrefixName,
  PersonFullName,
  BusinessPartnerNicknameLabel,
  Initials,
  cast( IsNaturalPerson as boole_d preserving type ) AS IsNaturalPerson,
  Language,
  _Language.LanguageName AS LanguageName,
  CorrespondenceLanguage,
  _CorrespondenceLanguage.LanguageName AS CorrespondenceLanguageName,
  BirthDate,
  BusinessPartnerBirthplaceName,
  BusinessPartnerBirthDateStatus,
  _BusPartBirthDateStatus._Text.BusPartBirthDateStatusText : localized AS BusPartBirthDateStatusTextlocalized,
  BusinessPartnerDeathDate,
  BusinessPartnerOccupation,
  _Occupation._Text.OccupationDescription : localized AS OccupationDescriptionlocalized,
  BusPartNationality,
  _Nationality._Text.NationalityName : localized AS NationalityNamelocalized,
  BusPartMaritalStatus,
  _MaritalStatus._Text.MaritalStatusName : localized AS MaritalStatusNamelocalized,
  IsMale,
  IsFemale,
  IsSexUnknown,
  GenderCodeName,
  _BusinessPartnerGender._Text.GenderCodeNameText : localized AS GenderCodeNameTextlocalized,
  AdditionalName,
  BusinessPartnerIDByExtSystem,
  NonResidentCompanyOriginCntry,
  NaturalPersonEmployerName,
  BusinessPartnerSalutation,
  FormOfAddressOrganization,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  LegalForm,
  _BusinessPartnerLegalForm._Text.LegalFormShortName : localized AS LegalFormShortNamelocalized,
  LegalEntityOfOrganization,
  _BusinessPartnerLegalEntity._Text.BusinessPartnerOrgShortName : localized AS BusinessPartnerOrgShortNamelocalized,
  OrganizationFoundationDate,
  OrganizationLiquidationDate,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  ETag,
  FormOfAddressGroup,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  BusinessPartnerGroupType,
  _GroupType._Text.BusPartGroupTypeShortDesc : localized AS BusPartGroupTypeShortDesclocalized,
  AuthorizationGroup,
  _AuthorizationGroup._Text.AuthorizationGroupName : localized AS AuthorizationGroupNamelocalized,
  BusinessPartnerType AS BusinessPartnerKind,
  _BusinessPartnerType._Text.BusinessPartnerTypeDesc : localized AS BusinessPartnerTypeDesclocalized,
  BusinessPartnerPrintFormat,
  _PrintFormat._Text.BusinessPartnerPrintFormatText : localized AS BusinessPartnerPrintFormatTextlocalized,
  BusinessPartnerDataOriginType,
  _DataOriginType._Text.BusPartDataOriginTypeText : localized AS BusPartDataOriginTypeTextlocalized,
  BusinessPartnerIsBlocked,
  IsMarkedForArchiving,
  BusinessPartnerIsNotReleased,
  ContactPermission,
  _ContactPermission._Text.ContactPermissionName : localized AS ContactPermissionNamelocalized,
  IsBusinessPurposeCompleted,
  SearchTerm1,
  SearchTerm2,
  BPFirstNameSearchHelp,
  BPLastNameSearchHelp,
  NameFormat,
  _NameFormat._Text.NameFormatDescription : localized AS NameFormatDescriptionlocalized,
  NameCountry,
  _NameCountry._Text.CountryName as CountryFreeText : localized AS CountryNameasCountryFreeTextlocalized,
  BusPartPersonDataIsHidden,
  BusPartOrgDataIsHidden,
  BusPartGroupDataIsHidden,
  BusPartAddrLanguageIsHidden,
  virtual Role : abap.sstring( 260 ) AS sstring260,
  _BusinessPartnerStandardAddr.HouseNumber AS HouseNumber,
  _BusinessPartnerStandardAddr.StreetName AS StreetName,
  _BusinessPartnerStandardAddr.CityName AS CityName,
  _BusinessPartnerStandardAddr.PostalCode AS PostalCode,
  _BusinessPartnerStandardAddr.Region AS Region,
  _BusinessPartnerStandardAddr._Region._RegionText.RegionName : localized AS RegionNamelocalized,
  _BusinessPartnerStandardAddr.Country AS Country,
  _BusinessPartnerStandardAddr._Country._Text.CountryName : localized AS CountryNamelocalized,
  _BusinessPartnerStandardAddr.AddressLine1Text AS AddressLine1Text,
  _BusinessPartnerStandardAddr.AddressLine2Text AS AddressLine2Text,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_BusinessPartnerTP_2
;