C_InsurPlcyBusPartner

DDL: C_INSURPLCYBUSPARTNER Type: view_entity CONSUMPTION
29 Fields 1 Data Sources 1 Associations

Geschäftspartner

C_InsurPlcyBusPartner is a Consumption CDS View that provides data about "Geschäftspartner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 29 fields with key field BusinessPartner. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BPGenderValueHelpText _BPGenderText $projection.GenderCodeName = _BPGenderText.GenderCodeName

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BusinessPartner view
EndUserText.label Geschäftspartner view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerCategory BusinessPartnerCategory Partner Cat.
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
BusinessPartnerName BusinessPartnerName Extracted Customer Name
LastName LastName Last Name
FirstName FirstName First Name
BirthDate BirthDate Date of Birth
PhoneNumber
EmailAddress
IsFemale IsFemale Female
IsMale IsMale Male
IsSexUnknown IsSexUnknown Unknown
GenderCodeNameText
GenderCodeName I_BusinessPartner GenderCodeName Sex
Country1asInsurCustFullAddr Adresse
DataControllerSet DataControllerSet Data Ctrlr. Set
DataController1 DataController1 Data Controller
DataController2 DataController2 Data Controller
DataController3 DataController3 Data Controller
DataController4 DataController4 Data Controller
DataController5 DataController5 Data Controller
DataController6 DataController6 Data Controller
DataController7 DataController7 Data Controller
DataController8 DataController8 Data Controller
DataController9 DataController9 Data Controller
DataController10 DataController10 Data Controller
_BPGenderText _BPGenderText
_CurrentDefaultAddress _CurrentDefaultAddress

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_InsurPlcyBusPartner.
-- 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_InsurPlcyBusPartner AS
SELECT
  BusinessPartner,
  BusinessPartnerCategory,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  BusinessPartnerName,
  LastName,
  FirstName,
  BirthDate,
  _CurrentDefaultAddress._Address._DefaultPhoneNumber.PhoneNumber AS PhoneNumber,
  _CurrentDefaultAddress._Address._DefaultEmailAddress.EmailAddress AS EmailAddress,
  IsFemale,
  IsMale,
  IsSexUnknown,
  _BPGenderText[ Language = $session.system_language ].GenderCodeNameText AS GenderCodeNameText,
  _BusinessPartner.GenderCodeName AS GenderCodeName,
  concat_with_space ( concat_with_space ( concat( concat_with_space( _CurrentDefaultAddress._Address.StreetName, _CurrentDefaultAddress._Address.HouseNumber, 1), ','), concat( concat_with_space( _CurrentDefaultAddress._Address.PostalCode, _CurrentDefaultAddress._Address.CityName, 1), ','), 1 ), _CurrentDefaultAddress._Address.Country, 1 ) as InsurCustFullAddr AS Country1asInsurCustFullAddr,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_BusinessPartner AS _BusinessPartner
LEFT OUTER JOIN I_BPGenderValueHelpText AS _BPGenderText ON GenderCodeName = _BPGenderText.GenderCodeName  -- association [0..*]
;

Learn More