I_BPCustomerProcess

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_BPCustomerProcess.
-- 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_BPCustomerProcess AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  assignment_id AS BPAssignmentID,
  kunnr AS Customer,
  aufsd AS OrderIsBlockedForCustomer,
  bahne AS ExpressTrainStationName,
  bahns AS TrainStationName,
  begru AS AuthorizationGroup,
  faksd AS BillingIsBlockedForCustomer,
  fiskn AS FiscalAddress,
  knrza AS AlternativePayerAccount,
  konzs AS CustomerCorporateGroup,
  ktokd AS CustomerAccountGroup,
  kukla AS CustomerClassification,
  lifnr AS Supplier,
  lifsd AS DeliveryIsBlocked,
  locco AS CityCoordinates,
  loevm AS DeletionIndicator,
  niels AS NielsenRegion,
  counc AS County,
  cityc AS CityCode,
  sperr AS PostingIsBlocked,
  stkza AS BPSubjectToEqualizationTax,
  stkzu AS VATLiability,
  xzemp AS AlternativePayeeIsAllowed,
  bran1 AS IndustryCode1,
  bran2 AS IndustryCode2,
  bran3 AS IndustryCode3,
  bran4 AS IndustryCode4,
  bran5 AS IndustryCode5,
  umjah AS YearForWhichSalesGiven,
  jmzah AS CustYearlyNumberOfEmployees,
  jmjah AS EmployeesNumberGivenForYear,
  katr1 AS FreeDefinedAttribute01,
  katr2 AS FreeDefinedAttribute02,
  katr3 AS FreeDefinedAttribute03,
  katr4 AS FreeDefinedAttribute04,
  katr5 AS FreeDefinedAttribute05,
  katr6 AS FreeDefinedAttribute06,
  katr7 AS FreeDefinedAttribute07,
  katr8 AS FreeDefinedAttribute08,
  katr9 AS FreeDefinedAttribute09,
  katr10 AS FreeDefinedAttribute10,
  periv AS CustomerFiscalYearVariant,
  dtams AS DataMediumExchangeIndicator,
  dtaws AS DataMediumExchangeKey,
  civve AS CustomerIsForCivilUse,
  milve AS CustomerIdentityForMilitaryUse,
  kdkg1 AS CustomerConditionGroup1,
  kdkg2 AS CustomerConditionGroup2,
  kdkg3 AS CustomerConditionGroup3,
  kdkg4 AS CustomerConditionGroup4,
  kdkg5 AS CustomerConditionGroup5,
  fityp AS ResponsibleType,
  xicms AS CustomerExempt1,
  xxipi AS CustomerExempt,
  xsubt AS CustomerGroupForCalculation,
  cfopc AS CustomerCategory,
  ccc01 AS BioChemicalWarfareLegal,
  ccc02 AS NuclearNonProliferationLegal,
  ccc03 AS NationalSecurityLegalControl,
  ccc04 AS MissileTechnologyLegalControl,
  cassd AS CustomerCentralSalesBlock,
  j_1kfrepre AS TaxInvoiceRepresentativeName,
  j_1kftbus AS BusinessType,
  j_1kftind AS IndustryType,
  nodel AS CustomerCentralDeletionIsBlock,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  source_recency AS MDChgProcSrceLastChgdDateTime,
  xdcset AS DataControllerSet,
  data_ctrlr1 AS DataController1,
  data_ctrlr2 AS DataController2,
  data_ctrlr3 AS DataController3,
  data_ctrlr4 AS DataController4,
  data_ctrlr5 AS DataController5,
  data_ctrlr6 AS DataController6,
  data_ctrlr7 AS DataController7,
  data_ctrlr8 AS DataController8,
  data_ctrlr9 AS DataController9,
  data_ctrlr10 AS DataController10
FROM kna1_prc
LEFT OUTER JOIN I_BusinessPartnerProcess AS _BusinessPartner ON MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartner.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN E_BPCustomerProcess AS _ExtBPCustomerProcess ON MasterDataChangeProcess = _ExtBPCustomerProcess.MasterDataChangeProcess AND MDChgProcessStep = _ExtBPCustomerProcess.MDChgProcessStep AND MDChgProcessSrceSystem = _ExtBPCustomerProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtBPCustomerProcess.MDChgProcessSrceObject AND BPAssignmentID = _ExtBPCustomerProcess.BPAssignmentID  -- association [0..1]
;