I_BPSupplierProcess

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_BPSupplierProcess.
-- 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_BPSupplierProcess AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  assignment_id AS BPAssignmentID,
  lifnr AS Supplier,
  bahns AS TrainStationName,
  begru AS AuthorizationGroup,
  dtams AS DataMediumExchangeIndicator,
  dtaws AS DataExchangeInstructionKey,
  esrnr AS PaytSlipWthRefSubscriber,
  konzs AS SupplierCorporateGroup,
  ktokk AS SupplierAccountGroup,
  kunnr AS Customer,
  lnrza AS AlternativePayeeAccountNumber,
  loevm AS DeletionIndicator,
  sperr AS AccountIsBlockedForPosting,
  sperm AS PurchasingIsBlocked,
  stkza AS BPIsEqualizationTaxSubject,
  stkzu AS VATLiability,
  xzemp AS AlternativePayeeIsAllowed,
  vbund AS TradingPartner,
  fiskn AS FiscalAddress,
  sperq AS SupplierProcurementBlock,
  qssys AS SuplrQualityManagementSystem,
  werks AS SupplierPlant,
  ltsna AS SupplierIsSubRangeRelevant,
  werkr AS SupplierIsPlantRelevant,
  plkal AS FactoryCalendar,
  fityp AS ResponsibleType,
  ipisp AS BR_TaxIsSplit,
  taxbs AS BRSpcfcTaxBasePercentageCode,
  stgdl AS TranspServiceAgentStstcGrp,
  j_1kfrepre AS TaxInvoiceRepresentativeName,
  j_1kftbus AS BusinessType,
  j_1kftind AS IndustryType,
  nodel AS SupplierCentralDeletionIsBlock,
  qssysdat AS SuplrQltyInProcmtCertfnValidTo,
  podkzb AS SuplrProofOfDelivRlvtCode,
  fisku AS SuplrTaxAuthorityAccountNumber,
  weora AS IsToBeAcceptedAtOrigin,
  ktock AS ReferenceAccountGroup,
  paytrsn AS PaymentReason,
  sperz AS PaymentIsBlockedForSupplier,
  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 lfa1_prc
LEFT OUTER JOIN I_BusinessPartnerProcess AS _BusinessPartner ON lfa1_prc.process_id = _BusinessPartner.MasterDataChangeProcess AND lfa1_prc.process_step_no = _BusinessPartner.MDChgProcessStep AND lfa1_prc.source_system = _BusinessPartner.MDChgProcessSrceSystem AND lfa1_prc.source_id = _BusinessPartner.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN E_BPSupplierProcess AS _ExtBPSupplierProcess ON MasterDataChangeProcess = _ExtBPSupplierProcess.MasterDataChangeProcess AND MDChgProcessStep = _ExtBPSupplierProcess.MDChgProcessStep AND MDChgProcessSrceSystem = _ExtBPSupplierProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtBPSupplierProcess.MDChgProcessSrceObject AND BPAssignmentID = _ExtBPSupplierProcess.BPAssignmentID  -- association [0..1]
;