I_BusinessPartnerCustomerDEX

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 I_BusinessPartnerCustomerDEX.
-- 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 I_BusinessPartnerCustomerDEX AS
SELECT
  but000.partner AS BusinessPartner,
  kna1.kunnr AS Customer,
  cvi_cust_link.partner_guid AS BusinessPartnerUUID,
  kna1.ktokd AS CustomerAccountGroup,
  kna1.knrza AS AlternativePayerAccount,
  kna1.dtams AS DataMediumExchangeIndicator,
  kna1.lifnr AS Supplier,
  kna1.kukla AS CustomerClassification,
  kna1.stkzu AS VATLiability,
  kna1.sperr AS PostingIsBlocked,
  kna1.lifsd AS DeliveryIsBlocked,
  kna1.faksd AS BillingIsBlockedForCustomer,
  kna1.aufsd AS OrderIsBlockedForCustomer,
  kna1.stkzn AS IsNaturalPerson,
  but000.bu_group AS BusinessPartnerGrouping,
  kna1.begru AS AuthorizationGroup,
  kna1.delivery_date_rule AS DeliveryDateTypeRule,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  kna1.bahne AS ExpressTrainStationName,
  kna1.bahns AS TrainStationName,
  kna1.locco AS CityLocationCoordinatesCode,
  kna1.werks AS Plant,
  kna1.konzs AS CustomerCorporateGroup,
  kna1.dtaws AS DataExchangeInstructionKey,
  kna1.bran1 AS IndustryCode1,
  kna1.bran2 AS IndustryCode2,
  kna1.bran3 AS IndustryCode3,
  kna1.dear1 AS IsCompetitor,
  kna1.dear2 AS IsSalesPartner,
  kna1.dear5 AS IsDefaultSoldToParty,
  kna1.dear6 AS IsConsumer,
  kna1.fiskn AS FiscalAddress,
  kna1.katr3 AS FreeDefinedAttribute03,
  kna1.kdkg1 AS CustomerConditionGroup1,
  kna1.kdkg2 AS CustomerConditionGroup2,
  kna1.kdkg3 AS CustomerConditionGroup3,
  kna1.kdkg4 AS CustomerConditionGroup4,
  kna1.kdkg5 AS CustomerConditionGroup5,
  kna1.adrnr AS AddressID,
  kna1.bbbnr AS InternationalLocationNumber1,
  kna1.bbsnr AS InternationalLocationNumber2,
  kna1.bubkz AS InternationalLocationNumber3,
  kna1.cityc AS CityCode,
  kna1.counc AS County,
  kna1.exabl AS CustomerHasUnloadingPoint,
  kna1.knazk AS CustomerWorkingTimeCalendar,
  kna1.cvp_xblck AS IsBusinessPurposeCompleted,
  cast (kna1.stkza as xfeld preserving type) AS BPIsEqualizationTaxSubject,
  kna1.land1 AS Country,
  kna1.regio AS Region,
  kna1.loevm AS DeletionIndicator,
  kna1.spras AS Language,
  cast (kna1.cassd as abap.char(1)) AS SalesIsBlockedForCustomer,
  kna1.paytrsn AS PaymentReason,
  kna1.nodel AS CustomerCentralDeletionIsBlock,
  kna1.xzemp AS AlternativePayerIsAllowed,
  kna1.umjah AS BPPlannedAnnualSalesYear,
  kna1.uwaer AS BPPlannedAnnualSalesCurrency,
  kna1.umsat AS BPPlannedAnnualSalesAmount,
  kna1.vbund AS CustomerTradingPartnerID,
  kna1.periv AS FiscalYearVariant,
  kna1.stcdt AS AccountTaxType,
  kna1.bran4 AS IndustryCode4,
  kna1.bran5 AS IndustryCode5,
  kna1.j_1kfrepre AS TaxInvoiceRepresentativeName,
  kna1.j_1kftbus AS BusinessType,
  kna1.j_1kftind AS IndustryType,
  kna1.katr1 AS FreeDefinedAttribute01,
  kna1.katr2 AS FreeDefinedAttribute02,
  kna1.katr4 AS FreeDefinedAttribute04,
  kna1.katr5 AS FreeDefinedAttribute05,
  kna1.katr6 AS FreeDefinedAttribute06,
  kna1.katr7 AS FreeDefinedAttribute07,
  kna1.katr8 AS FreeDefinedAttribute08,
  kna1.katr9 AS FreeDefinedAttribute09,
  kna1.katr10 AS FreeDefinedAttribute10,
  kna1.xdcset AS DataControllerSet,
  kna1.data_ctrlr1 AS DataController1,
  kna1.data_ctrlr2 AS DataController2,
  kna1.data_ctrlr3 AS DataController3,
  kna1.data_ctrlr4 AS DataController4,
  kna1.data_ctrlr5 AS DataController5,
  kna1.data_ctrlr6 AS DataController6,
  kna1.data_ctrlr7 AS DataController7,
  kna1.data_ctrlr8 AS DataController8,
  kna1.data_ctrlr9 AS DataController9,
  kna1.data_ctrlr10 AS DataController10
FROM kna1
INNER JOIN cvi_cust_link ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON Customer = _CustomerToBusinessPartner.Customer  -- association [1..1]
;