C_BusinessPartner

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_BusinessPartner.
-- 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.
-- SQL view name: CBUSINESSPARTNER

CREATE VIEW C_BusinessPartner AS
SELECT
  cast( ' ' as abap.sstring( 260 ) ) AS Role,
  cast( ' ' as abap.sstring( 260 ) ) AS CityName,
  cast( ' ' as abap.sstring( 260 ) ) AS StreetName,
  cast( ' ' as abap.sstring( 260 ) ) AS CountryName,
  cast( ' ' as abap.sstring( 260 ) ) AS PostalCode,
  cast( ' ' as abap.sstring( 260 ) ) AS IndustrySector,
  cast( ' ' as abap.sstring( 260 ) ) AS HouseNumber,
  cast( ' ' as abap.sstring( 260 ) ) AS Region,
  cast( ' ' as abap.sstring( 260 ) ) AS BPIdentificationNumber,
  cast( ' ' as abap.sstring( 260 ) ) AS BPIdentificationType,
  cast( ' ' as abap.sstring( 260 ) ) AS DataControllerName,
  cast( ' ' as abap.sstring( 260 ) ) AS BPTaxNumber,
  cast(' ' as abap_boolean preserving type) AS BPCustMultiAddrIsActive,
  cast(' ' as abap_boolean preserving type) AS BPTaxNmbrMultiAddrIsActive,
  cast(' ' as abap_boolean preserving type) AS BPIntlLocNmbrMultiAddrIsActive,
  cast(' ' as abap_boolean preserving type) AS IsMultipleAccountAssignment,
  cast(' ' as abap_boolean preserving type) AS BPIsMltplAddrDepdntDataPresent,
  cast( '' as abap.sstring( 260 ) ) AS BusinessPartnerImageURL,
  BPHasEmployeeRoles,
  BusinessPartner.BusinessPartner AS BusinessPartner,
  BusinessPartner.FullName AS FullName,
  BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  BusinessPartner.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartner.OrganizationFoundationDate AS OrganizationFoundationDate,
  BusinessPartner.OrganizationLiquidationDate AS OrganizationLiquidationDate,
  BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  BusinessPartner.FormOfAddressPerson AS FormOfAddressPerson,
  BusinessPartner.FormOfAddressOrganization AS FormOfAddressOrganization,
  BusinessPartner.FirstName AS FirstName,
  BusinessPartner.LastName AS LastName,
  BusinessPartner.Name AS Name,
  BusinessPartner.AdditionalName AS AdditionalName,
  BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  BusinessPartner.LegalForm AS LegalForm,
  BusinessPartner.Industry AS Industry,
  BusinessPartner.GenderCodeName AS GenderCodeName,
  BusinessPartner.AcademicTitle AS AcademicTitle,
  BusinessPartner.BirthDate AS BirthDate,
  BusinessPartner.BusinessPartnerBirthDateStatus AS BusinessPartnerBirthDateStatus,
  BusinessPartner.BusinessPartnerBirthplaceName AS BusinessPartnerBirthplaceName,
  BusinessPartner.BPLastNameSearchHelp AS BPLastNameSearchHelp,
  BusinessPartner.BPFirstNameSearchHelp AS BPFirstNameSearchHelp,
  BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartner.CreatedByUser AS CreatedByUser,
  BusinessPartner.CreationTime AS CreationTime,
  BusinessPartner.LastChangedByUser AS LastChangedByUser,
  BusinessPartner.LastChangeDate AS LastChangeDate,
  BusinessPartner.LastChangeTime AS LastChangeTime,
  BusinessPartner.CreationDate AS CreationDate,
  BusinessPartner.SearchTerm1 AS SearchTerm1,
  BusinessPartner.SearchTerm2 AS SearchTerm2,
  BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  BusinessPartner.IsNaturalPerson AS IsNaturalPerson,
  BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  BusinessPartner.TradingPartner AS TradingPartner,
  BusinessPartner.BusinessPartnerIDByExtSystem AS BusinessPartnerIDByExtSystem,
  BusinessPartner.IsMarkedForArchiving AS IsMarkedForArchiving,
  BusinessPartner.InternationalLocationNoPart1 AS InternationalLocationNoPart1,
  BusinessPartner.InternationalLocationNoPart2 AS InternationalLocationNoPart2,
  BusinessPartner.InternationalLocationNoPart3 AS InternationalLocationNoPart3,
  BusinessPartner.IndependentAddressID AS IndependentAddressID,
  BusinessPartner.DataControllerSet AS DataControllerSet,
  BusinessPartner.DataController1 AS DataController1,
  BusinessPartner.DataController2 AS DataController2,
  BusinessPartner.DataController3 AS DataController3,
  BusinessPartner.DataController4 AS DataController4,
  BusinessPartner.DataController5 AS DataController5,
  BusinessPartner.DataController6 AS DataController6,
  BusinessPartner.DataController7 AS DataController7,
  BusinessPartner.DataController8 AS DataController8,
  BusinessPartner.DataController9 AS DataController9,
  BusinessPartner.DataController10 AS DataController10,
  BusinessPartner.BPDataControllerIsNotRequired AS BPDataControllerIsNotRequired,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  _LastChangedByUser.UserDescription AS LastChangedByUserName
FROM I_BusinessPartnerTP AS BusinessPartner
LEFT OUTER JOIN C_Businesspartnersupplierco AS _BusinessPartnerSupplierCo ON BusinessPartner = _BusinessPartnerSupplierCo.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BusinessPartnerSuplr AS _BusinessPartnerSupplier ON BusinessPartner = _BusinessPartnerSupplier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_BusinessPartnerPurgOrg AS _BusinessPartnerPurgOrg ON BusinessPartner = _BusinessPartnerPurgOrg.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BusinessPartnerSupplierRole AS _BusinessPartnerSuplrRole ON BusinessPartner = _BusinessPartnerSuplrRole.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BusinessPartnerRole AS _BusinessPartnerRole ON BusinessPartner = _BusinessPartnerRole.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BusinessPartnerCust AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerAddress AS _BusinessPartnerAddress ON BusinessPartner = _BusinessPartnerAddress.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerBank AS _BusinessPartnerBank ON BusinessPartner = _BusinessPartnerBank.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_Businesspartnertaxnumber AS _BusinessPartnerTaxNumber ON BusinessPartner = _BusinessPartnerTaxNumber.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerContact AS _BusinessPartnerContact ON BusinessPartner = _BusinessPartnerContact.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerCustCo AS _BusinessPartnerCustomerCo ON BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerSalesArea AS _BusinessPartnerSalesArea ON BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerCustomerRole AS _BusinessPartnerCustRole ON BusinessPartner = _BusinessPartnerCustRole.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerAddress AS _BusinessPartnerAddrFilter ON BusinessPartner = _BusinessPartnerAddrFilter.BusinessPartner AND _BusinessPartnerAddrFilter.StandardUsage = 'X'  -- association [1..1]
LEFT OUTER JOIN C_PaymentCard AS _PaymentCard ON BusinessPartner = _PaymentCard.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BuPaIdentification AS _BPIdentificationNumbers ON BusinessPartner = _BPIdentificationNumbers.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BuPaIndustry AS _BPIndustry ON BusinessPartner = _BPIndustry.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPUnloadingPoint AS _BusinessPartnerUnloadingPoint ON BusinessPartner = _BusinessPartnerUnloadingPoint.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPSiteReceivingPoint AS _BPCustReceivingPoint ON BusinessPartner = _BPCustReceivingPoint.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPCustRcvgPtAddrDepdntInfo AS _BPCustRcvgPtAddrDepdntInfo ON BusinessPartner = _BPCustRcvgPtAddrDepdntInfo.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_CustomerDepartment AS _CustomerDepartment ON BusinessPartner = _CustomerDepartment.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPCustDepartmentAddrDepdnt AS _BPCustDepartmentAddrDepdnt ON BusinessPartner = _BPCustDepartmentAddrDepdnt.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BPSupplierTaxGrouping AS _BPSupplierTaxGrouping ON BusinessPartner = _BPSupplierTaxGrouping.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPCustomerTaxGrouping AS _BPCustomerTaxGrouping ON BusinessPartner = _BPCustomerTaxGrouping.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerCustomerTxt AS _BusinessPartnerCustomerTxt ON BusinessPartner = _BusinessPartnerCustomerTxt.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN I_BPGenderValueHelp AS _GenderValueHelp ON GenderCodeName = _GenderValueHelp.GenderCodeName  -- association [0..1]
LEFT OUTER JOIN C_BPGroupingTextVhTemp AS _BPGroupingText ON BusinessPartnerGrouping = _BPGroupingText.BusinessPartnerGrouping  -- association [0..*]
LEFT OUTER JOIN C_BPCatHelpTextVhTemp AS _BPCatHelpText ON BusinessPartnerCategory = _BPCatHelpText.BusinessPartnerCategory  -- association [0..*]
LEFT OUTER JOIN C_LegalFormTextVHTemp AS _LegalFormText ON LegalForm = _LegalFormText.LegalForm  -- association [0..*]
LEFT OUTER JOIN I_BPGenderValueHelpText AS _BPGenderText ON GenderCodeName = _BPGenderText.GenderCodeName  -- association [0..*]
LEFT OUTER JOIN I_BusPartAuthorizationGroupTxt AS _AuthorizationGroupText ON AuthorizationGroup = _AuthorizationGroupText.AuthorizationGroup AND _AuthorizationGroupText.AuthorizationObject = 'BUPA'  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerSupplierText AS _BusinessPartnerSupplierTxt ON BusinessPartner = _BusinessPartnerSupplierTxt.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BusPartRelationship AS _BusPartRelationship ON BusinessPartner = _BusPartRelationship.BusinessPartner1  -- association [0..*]
LEFT OUTER JOIN C_BPAddressIndependentPhone AS _BPAddressIndependentPhone ON BusinessPartner = _BPAddressIndependentPhone.BusinessPartner AND IndependentAddressID = _BPAddressIndependentPhone.AddressID  -- association [1..*]
LEFT OUTER JOIN C_BPAddressIndependentMobile AS _BPAddressIndependentMobile ON BusinessPartner = _BPAddressIndependentMobile.BusinessPartner AND IndependentAddressID = _BPAddressIndependentMobile.AddressID  -- association [1..*]
LEFT OUTER JOIN C_BPAddressIndependentEmail AS _BPAddressIndependentEmail ON BusinessPartner = _BPAddressIndependentEmail.BusinessPartner AND IndependentAddressID = _BPAddressIndependentEmail.AddressID  -- association [1..*]
LEFT OUTER JOIN I_Globalcompany AS _TradingPartnerValueHelp ON TradingPartner = _TradingPartnerValueHelp.Company  -- association [0..1]
LEFT OUTER JOIN C_BusinessPartnerLongText AS _BusinessPartnerLongText ON BusinessPartner = _BusinessPartnerLongText.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN I_BusinessPartnerCustomerVH AS _BusinessPartnerCustomerVH ON BusinessPartner = _BusinessPartnerCustomerVH.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN I_BusinessPartnerSupplierVH AS _BusinessPartnerSupplierVH ON BusinessPartner = _BusinessPartnerSupplierVH.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN I_BusinessPartnerCustSuplrVH AS _BusinessPartnerCustSuplrVH ON BusinessPartner = _BusinessPartnerCustSuplrVH.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPCustAddrDepdntInformation AS _BPCustAddressDependentInfo ON BusinessPartner = _BPCustAddressDependentInfo.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BPDataController AS _BPDataController ON BusinessPartner = _BPDataController.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BPAdditionalSupplier AS _BPAdditionalSupplier ON BusinessPartner = _BPAdditionalSupplier.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPAdditionalCustomer AS _BPAdditionalCustomer ON BusinessPartner = _BPAdditionalCustomer.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN C_BPCustUnldgPtAddrDepdntInfo AS _BPCustUnldgPtAddrDepdnt ON BusinessPartner = _BPCustUnldgPtAddrDepdnt.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BusPartAddrDepdntTaxNmbr AS _BusinessPartnerTaxNumberAdr ON BusinessPartner = _BusinessPartnerTaxNumberAdr.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_CustAddrDepdntExtIdentifier AS _CustAddrDepdntExtIdentifier ON BusinessPartner = _CustAddrDepdntExtIdentifier.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_BPAddrDepdntIntlLocNumber AS _BusinessPartnerAddrDepILN ON BusinessPartner = _BusinessPartnerAddrDepILN.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BusPartBirthDateStatusText AS _BirthDateStatusTxt ON BusinessPartnerBirthDateStatus = _BirthDateStatusTxt.BusinessPartnerBirthDateStatus  -- association [0..*]
LEFT OUTER JOIN C_BPEmplWorkplaceAddr AS _BPEmplWorkplaceAddr ON BusinessPartner = _BPEmplWorkplaceAddr.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerTypeText AS _BusinessPartnerTypeText ON BusinessPartnerType = _BusinessPartnerTypeText.BusinessPartnerType  -- association [0..*]
;