I_BPSupplierCompanyGovTP

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_BPSupplierCompanyGovTP.
-- 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_BPSupplierCompanyGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS SupplierCompanyUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  CompanyCode,
  MDChgProcessStep,
  CompanyCode AS CompanyCodeForEdit,
  BPAssignmentID,
  Supplier,
  PersonnelNumber,
  SupplierIsBlockedForPosting,
  DeletionIndicator,
  LayoutSortingRule,
  ReconciliationAccount,
  AuthorizationGroup,
  InterestCalculationCode,
  PaymentMethodsList,
  ClearCustomerSupplier,
  PaymentBlockingReason,
  PaymentTerms,
  SupplierClerkIDBySupplier,
  SupplierClerk,
  SupplierAccountNote,
  CashPlanningGroup,
  AccountingClerk,
  SupplierHeadOffice,
  AlternativePayee,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  LastInterestCalcRunDate,
  IsToBeLocallyProcessed,
  Currency,
  BillOfExchLmtAmtInCoCodeCrcy,
  CheckPaidDurationInDays,
  IsDoubleInvoice,
  APARToleranceGroup,
  HouseBank,
  ItemIsToBePaidSeparately,
  MinorityGroup,
  PreviousAccountNumber,
  PaymentMethodSupplement,
  WithholdingTaxCountry,
  PaymentIsToBeSentByEDI,
  SupplierReleaseGroup,
  SuplrInvcVerificatTolGroup,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  CreditMemoPaymentTerms,
  SupplierCertificationDate,
  DeletionIsBlocked,
  AccountingClerkPhoneNumber,
  MasterDataIsCurrent,
  Origin
FROM I_BPSupplierCompanyGov AS BPSupplierCompanyGovernance
LEFT OUTER JOIN I_BusinessPartnerGovTP AS _BusinessPartnerGov ON MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess AND BusinessPartnerUUID = _BusinessPartnerGov.BusinessPartnerUUID AND MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaytBlkgRsnValueHelp ON PaymentBlockingReason = _PaytBlkgRsnValueHelp.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReasonText AS _PaymentBlockingReasonText ON PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroupText AS _CashPlanningGroupText ON CashPlanningGroup = _CashPlanningGroupText.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode2 ON CompanyCodeForEdit = _CompanyCode2.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BPChangeProcessGovTP AS _Process ON MasterDataChangeProcess = _Process.MasterDataChangeProcess AND BusinessPartnerUUID = _Process.BusinessPartnerUUID AND MDChgProcessSrceSystem = _Process.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Process.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN E_SUPCO_D AS _ExtBPSupplierCompanyActive ON CompanyCode = _ExtBPSupplierCompanyActive.CompanyCode AND Supplier = _ExtBPSupplierCompanyActive.Supplier  -- association [0..1]
LEFT OUTER JOIN E_BPSupplierCompanyProcess AS _ExtBPSupplierCompanyProcess ON MasterDataChangeProcess = _ExtBPSupplierCompanyProcess.MasterDataChangeProcess AND MDChgProcessStep = _ExtBPSupplierCompanyProcess.MDChgProcessStep AND MDChgProcessSrceSystem = _ExtBPSupplierCompanyProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtBPSupplierCompanyProcess.MDChgProcessSrceObject AND BPAssignmentID = _ExtBPSupplierCompanyProcess.BPAssignmentID AND CompanyCode = _ExtBPSupplierCompanyProcess.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BPSupplierDunningGovTP AS _SupplierDunning ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPSuplrWithholdingTaxGovTP AS _SupplierWithHoldingTax ON /* condition not available in parsed metadata */  -- association [0..*]
;