I_SupplierCompanyCodeTP

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_SupplierCompanyCodeTP.
-- 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_SupplierCompanyCodeTP AS
SELECT
  BusinessPartner,
  CompanyCode,
  Supplier,
  BusinessPartnerUUID,
  CompanyCode AS CompanyCodeForEdit,
  BusinessPartner AS BusinessPartnerForEdit,
  SupplierIsBlockedForPosting,
  AuthorizationGroup,
  AccountingClerk,
  SupplierClerk,
  AccountingClerkPhoneNumber,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  SupplierClerkIDBySupplier,
  IsToBeLocallyProcessed,
  SupplierAccountNote,
  PaymentTerms,
  APARToleranceGroup,
  SuplrInvcVerificatTolGroup,
  CheckPaidDurationInDays,
  IsDoubleInvoice,
  CustomerSupplierClearingIsUsed,
  ReconciliationAccount,
  SupplierHeadOffice,
  LayoutSortingRule,
  SupplierCertificationDate,
  PaymentMethodsList,
  CashPlanningGroup,
  PaymentBlockingReason,
  AlternativePayee,
  HouseBank,
  BillOfExchLmtAmtInCoCodeCrcy,
  ItemIsToBePaidSeparately,
  PaymentIsToBeSentByEDI,
  WithholdingTaxCountry,
  InterestCalculationCode,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  LastInterestCalcRunDate,
  SupplierReleaseGroup,
  CreditMemoPaymentTerms,
  PaymentMethodSupplement,
  PaymentClearingGroup,
  PreviousAccountNumber,
  PaymentReason,
  DeletionIsBlocked,
  ExtendedWhldgTaxIsActive,
  PersonnelNumber,
  Country,
  CompanyCodeName,
  cast( 'X' as sdraft_is_active preserving type ) AS BPHasActiveEntity,
  IsBusinessPurposeCompleted,
  Currency,
  MinorityGroup,
  DeletionIndicator,
  _SupplierToBusinessPartner._Supplier.SupplierAccountGroup AS SupplierAccountGroup
FROM I_BusinessPartnerSuplrCo AS SupplierCompanyCode
LEFT OUTER JOIN I_BusinessPartnerTP_2 AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_Alternativepayeevhtemp AS _AlternativePayeeValueHelp ON AlternativePayee = _AlternativePayeeValueHelp.AlternativePayee AND CompanyCodeForEdit = _AlternativePayeeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ToleranceGroupText AS _ToleranceGroupText ON _ToleranceGroupText.CompanyCode = CompanyCode AND _ToleranceGroupText.APARToleranceGroup = APARToleranceGroup  -- association [0..1]
LEFT OUTER JOIN I_SuplrInvcSuplrTolSettingsVH AS _SuplrInvcVerificatTolGrpVH ON SuplrInvcVerificatTolGroup = _SuplrInvcVerificatTolGrpVH.SuplrInvcVerificatTolGroup AND CompanyCodeForEdit = _SuplrInvcVerificatTolGrpVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierWithHoldingTaxTP AS _SupplierWithholdingTax ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SuplrPmtdAltvPayeeTP AS _SupplierPermittedAltvPayee ON /* condition not available in parsed metadata */  -- association [0..*]
;