I_CustomerCompany

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_CustomerCompany.
-- 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.
-- SQL view name: ICUSTCMPY

CREATE VIEW I_CustomerCompany AS
SELECT
  kunnr AS Customer,
  bukrs AS CompanyCode,
  busab AS AccountingClerk,
  akont AS ReconciliationAccount,
  begru AS AuthorizationGroup,
  knrze AS CustomerHeadOffice,
  knrzb AS AlternativePayerAccount,
  zahls AS PaymentBlockingReason,
  vzskz AS InterestCalculationCode,
  zindt AS InterestCalculationDate,
  zinrt AS IntrstCalcFrequencyInMonths,
  kverm AS CustomerAccountNote,
  togru AS APARToleranceGroup,
  hbkid AS HouseBank,
  xpore AS ItemIsToBePaidSeparately,
  xedip AS PaytAdviceIsSentbyEDI,
  sperr AS PhysicalInventoryBlockInd,
  zsabe AS UserAtCustomer,
  tlfns AS AccountingClerkPhoneNumber,
  tlfxs AS AccountingClerkFaxNumber,
  intad AS AccountingClerkInternetAddress,
  eikto AS AccountByCustomer,
  xdezv AS IsToBeLocallyProcessed,
  perkz AS CollectiveInvoiceVariant,
  zuawa AS LayoutSortingRule,
  zterm AS PaymentTerms,
  xverr AS CustomerSupplierClearingIsUsed,
  xzver AS RecordPaymentHistoryIndicator,
  zwels AS PaymentMethodsList,
  loevm AS DeletionIndicator,
  guzte AS CreditMemoPaymentTerms,
  mgrup AS DunningNoticeGroup,
  datlz AS LastInterestCalcRunDate,
  altkn AS CustPreviousMasterRecordNumber,
  wbrsl AS ValueAdjustmentKey,
  fdgrv AS CashPlanningGroup,
  frgrp AS SupplierReleaseGroup,
  pernr AS PersonnelNumber,
  ekvbd AS BuyingGroupAccountNumber,
  wakon AS BillExchChargePaymentTerms,
  kultg AS CheckPaidDurationInDays,
  zahls AS CustomerPaymentBlockingReason,
  uzawe AS PaymentMethodSupplement,
  cession_kz AS AcctsReceivablePledgingCode,
  lockb AS LockboxInternalID,
  cvp_xblck_b AS IsBusinessPurposeCompleted,
  qland AS WithholdingTaxCountry,
  urlid AS KnownOrNegotiatedLeave,
  nodel AS DeletionIsBlocked,
  paymentclearinggrpid AS PaymentClearingGroup,
  paytrsn AS PaymentReason,
  xausz AS BPPeriodicAccountStatement,
  us_rec_country AS US_FrgnAcctTaxRcpntCntry,
  us_giin AS US_GlobIntermediaryIdnNumber,
  us_ftid AS US_RecipientForeignTaxID,
  us_lob_code AS US_LobTreatyCode,
  us_w8_recvdate AS US_FW8BENReceiveDate,
  us_w9_recvdate AS US_FW9ReceiveDate,
  us_tin_notice AS US_SecondTINNoticeIsIssued,
  us_partnership_ind AS US_FrgnRecipientHasPartnership,
  us_fatca_ind AS US_FrgnAcctTaxFilingIsRequired,
  us_chap4_status_code AS US_Chapter4StatusCode,
  _CustomerDefaultDunning.LastDunnedOn AS LastDunnedOn,
  _CustomerDefaultDunning.DunningProcedure AS DunningProcedure,
  _CustomerDefaultDunning.DunningLevel AS DunningLevel,
  _CustomerDefaultDunning.DunningBlock AS DunningBlock,
  _CustomerDefaultDunning.DunningRecipient AS DunningRecipient,
  _CustomerDefaultDunning.LegDunningProcedureOn AS LegDunningProcedureOn,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity
FROM knb1
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerDunning AS _CustomerDunning ON Customer = _CustomerDunning.Customer AND CompanyCode = _CustomerDunning.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_CustomerDunning AS _CustomerDefaultDunning ON Customer = _CustomerDefaultDunning.Customer AND CompanyCode = _CustomerDefaultDunning.CompanyCode AND _CustomerDefaultDunning.DunningArea = ''  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockValueHelp ON PaymentBlockingReason = _PaymentBlockValueHelp.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReasonText AS _PaymentBlockingReasonText ON PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason  -- association [0..*]
LEFT OUTER JOIN I_CashPlanningGroup AS _CashPlanningGroup ON CashPlanningGroup = _CashPlanningGroup.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN E_CUSCO_D AS _CustCoExt ON CompanyCode = _CustCoExt.CompanyCode AND Customer = _CustCoExt.Customer  -- association [0..1]
;