I_ContractAccountPartner

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_ContractAccountPartner.
-- 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: ICTRACCPARTNER

CREATE VIEW I_ContractAccountPartner AS
SELECT
  vkont AS ContractAccount,
  gpart AS BusinessPartner,
  vkbez AS ContractAccountName,
  erdat AS CreationDate,
  ertim AS CreationTime,
  ernam AS CreatedByUser,
  cast( loevm as loevm preserving type ) AS IsMarkedForDeletion,
  aedatp AS LastChangeDate,
  aetimp AS LastChangeTime,
  aenamp AS LastChangedByUser,
  ebvty AS CABankIDForIncomingPayments,
  abvty AS CABankIDForOutgoingPayments,
  ezawe AS CAPaymentMethodForIncgPayment,
  azawe AS CACnctntdOutgPaymentMethods,
  cast (substring(azawe, 1, 1) as azawe1_conacct_kk preserving type) AS CAFirstOutgoingPaymentMethod,
  cast (substring(azawe, 2, 1) as azawe2_conacct_kk preserving type) AS CASecondOutgoingPaymentMethod,
  cast (substring(azawe, 3, 1) as azawe3_conacct_kk preserving type) AS CAThirdOutgoingPaymentMethod,
  cast (substring(azawe, 4, 1) as azawe4_conacct_kk preserving type) AS CAFourthOutgoingPaymentMethod,
  cast (substring(azawe, 5, 1) as azawe5_conacct_kk preserving type) AS CAFifthOutgoingPaymentMethod,
  eigbv AS CAHouseBankReference,
  ccard_id AS CAPaymentCardIDForIncomingPayt,
  ccard_out AS CAPaymentCardIDForOutgoingPayt,
  mndid AS SEPAMandate,
  mahnv AS CADunningProcedure,
  mgrup AS CADunningNoticeGroup,
  corr_mahnv AS CACorrespondenceDunningProced,
  persr AS CACollectionsClerk,
  cmgrp AS CACollectionsMasterDataGroup,
  strat AS CACollectionStrategy,
  cpers AS CACollectionsContactPerson,
  vkonv AS ContractAccountForPayment,
  gparv AS CABusinessPartnerForPayment,
  abwre AS CAAlternativePayer,
  abwra AS CAAlternativePayee,
  abwma AS CAAlternativeDunningRecipient,
  abwrh AS CAAlternativeInvoiceRecipient,
  def_rec AS CAAlternativeCorrespncRcpnt,
  adrre AS CAAddressIDOfAlternativePayer,
  adrra AS CAAddressIDOfAlternativePayee,
  adrma AS CAAddressIDOfAltvDunRecipient,
  adrrh AS CAAddressIDOfAltvInvoiceRcpnt,
  ddlcu AS CACurrencyForDirectDebitLimit,
  ddlam AS CADirectDebitLimit,
  ddlnm AS CANmbrMnthsForDirectDebitLimit,
  ddlxg AS CADirectDebitLimitCalcMode,
  inv_curr AS CATargetCurrencyForInvoicing,
  inv_category AS CAInvcgCategory,
  inv_schedule AS CAInvcgSchedule,
  inv_cycle AS CABillgCycle,
  inv_cycle_day AS CALastDayOfBillingPeriod,
  inv_form_det_key AS CADetnCodeForAltvInvoiceForm,
  gpart_inv AS CABusinessPartnerForPosting,
  vkont_inv AS ContractAccountForPosting,
  gpart_invlist AS CABusinessPartnerForInvcgList,
  vkont_invlist AS ContractAccountForInvcgList,
  makey AS CAMasterAgreement,
  ptsrl AS CAPartnerSettlementRule,
  qszdt AS ValdtyDateForWhldgTaxExmpCert,
  cast( txjcd as fis_txjcd preserving type ) AS TaxJurisdiction,
  qsskz_a AS CAWhldgTaxCodeOutgoingPayt,
  qsskz_e AS CAWhldgTaxCodeIncomingPayt,
  cast( qsznr as fis_wtcert preserving type ) AS WithholdingTaxCertificate,
  fdztg AS CAAdditionalDaysForCashMgmt,
  bpl_xpocl AS CABusinessPartnerLock,
  bpl_xpocl AS CABusPartnerPostgLockExstcCode,
  bpl_xaddl AS CABusPartnerAddlLockExstcCode,
  bpl_fdate AS CABusinessPartnerLockStartDate,
  bpl_tdate AS CABusinessPartnerLockEndDate,
  exvko AS CABPReferenceNumber,
  opbuk AS CACompanyCodeGroup,
  abwvk AS AltvContractAcctForCollvBills,
  ikey AS CAInterestCode,
  fdgrp AS CashPlanningGroup,
  vkpbz AS CARelationshipOfBPToContrAcct,
  adrnb AS AddressID,
  adrjdc AS CAAddressIDOfJurisdictionCode,
  begru AS CAAuthorizationGroup,
  togru AS CAToleranceGroup,
  coprc AS CACorrespondenceVariant,
  cast( vbund as fis_rassc preserving type ) AS PartnerCompany,
  def_rec_ind AS CACorrespondenceActivityCode,
  vertyp AS CAClearingCategory,
  augrs_def AS CAClearingRestriction,
  augrs_def AS CADefaultClearingRstrcnCode,
  cast( landl as fac_landl preserving type ) AS SupplyingCountry,
  cast( bupla as farp_bupla preserving type ) AS BusinessPlace,
  zahlkond AS PaymentCondition,
  cast( kofiz_sd as kofiz_kk preserving type ) AS CAAccountDeterminationCode,
  cast( gsber as fis_rbusa preserving type ) AS BusinessArea,
  _CompCodeGroup.CAPaymentCompanyCode AS CAPaymentCompanyCode,
  _CompCodeGroup._CompanyCode.Country AS Country,
  azawe AS CAPaymentMethodForOutgPayment
FROM fkkvkp
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _AlternativePayer ON CAAlternativePayer = _AlternativePayer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AlternativePayee ON CAAlternativePayee = _AlternativePayee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AltvDunningRecipient ON CAAlternativeDunningRecipient = _AltvDunningRecipient.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AltvInvoiceRecipient ON CAAlternativeInvoiceRecipient = _AltvInvoiceRecipient.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AltvCorrespncRcpnt ON CAAlternativeCorrespncRcpnt = _AltvCorrespncRcpnt.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BPForPayment ON CABusinessPartnerForPayment = _BPForPayment.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CollContactPerson ON CACollectionsContactPerson = _CollContactPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BPForPosting ON CABusinessPartnerForPosting = _BPForPosting.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BPForInvcgList ON CABusinessPartnerForInvcgList = _BPForInvcgList.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CAAccountDetnCode AS _AcctDetnCode ON CAAccountDeterminationCode = _AcctDetnCode.CAAccountDeterminationCode  -- association [0..1]
LEFT OUTER JOIN I_CAAuthorizationGroup AS _CAAuthorizationGroup ON CAAuthorizationGroup = _CAAuthorizationGroup.CAAuthorizationGroup AND _CAAuthorizationGroup.CAAuthorizationGroupObject = 'CA_CONTACC'  -- association [0..1]
LEFT OUTER JOIN I_CABillgCycle AS _BillgCycle ON CABillgCycle = _BillgCycle.CABillgCycle  -- association [1..1]
LEFT OUTER JOIN I_CABusPrtnAddlLockExstcCode AS _CABusPrtnAddlLockExstcCode ON CABusPartnerAddlLockExstcCode = _CABusPrtnAddlLockExstcCode.CABusPartnerAddlLockExstcCode  -- association [0..1]
LEFT OUTER JOIN I_CABusPrtnPostgLockExstcCode AS _CABusPrtnPostgLockExstcCode ON CABusPartnerPostgLockExstcCode = _CABusPrtnPostgLockExstcCode.CABusPartnerPostgLockExstcCode  -- association [0..1]
LEFT OUTER JOIN I_CAClearingCategory AS _ClearingCategory ON CAClearingCategory = _ClearingCategory.CAClearingCategory  -- association [0..1]
LEFT OUTER JOIN I_CACollectionStrategy AS _CollectionStrategy ON CACollectionStrategy = _CollectionStrategy.CACollectionStrategy  -- association [0..1]
LEFT OUTER JOIN I_CACollMasterDataGroup AS _CollMasterDataGroup ON CACollectionsMasterDataGroup = _CollMasterDataGroup.CACollectionsMasterDataGroup  -- association [0..1]
LEFT OUTER JOIN I_CACompanyCodeGroup AS _CompCodeGroup ON CACompanyCodeGroup = _CompCodeGroup.CACompanyCodeGroup  -- association [1..1]
LEFT OUTER JOIN I_CACorrespncActivityCode AS _CACorrespncActivityCode ON CACorrespondenceActivityCode = _CACorrespncActivityCode.CACorrespondenceActivityCode  -- association [0..1]
LEFT OUTER JOIN I_CACorrespondenceVariant AS _CorrVariant ON CACorrespondenceVariant = _CorrVariant.CACorrespondenceVariant  -- association [1..1]
LEFT OUTER JOIN I_CACorrespondenceVariant AS _CorrespncVar ON CACorrespondenceVariant = _CorrespncVar.CACorrespondenceVariant  -- association [1..1]
LEFT OUTER JOIN I_CADfltClearingRstrcnCode AS _CADfltClearingRstrcnCode ON CADefaultClearingRstrcnCode = _CADfltClearingRstrcnCode.CADefaultClearingRstrcnCode  -- association [1..1]
LEFT OUTER JOIN I_CADirectDebitLimitCalcMode AS _CADirectDebitLimitCalcMod ON CADirectDebitLimitCalcMode = _CADirectDebitLimitCalcMod.CADirectDebitLimitCalcMode  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _DunningProcedure ON CADunningProcedure = _DunningProcedure.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_CADunningNoticeGroup AS _DunNoticeGroup ON CADunningNoticeGroup = _DunNoticeGroup.CADunningNoticeGroup  -- association [0..1]
LEFT OUTER JOIN I_CAHouseBankReference AS _HouseBankRef ON capaymentcompanycode = _HouseBankRef.CAPaymentCompanyCode AND CAHouseBankReference = _HouseBankRef.CAHouseBankReference  -- association [0..1]
LEFT OUTER JOIN I_CAInterestCode AS _InterestCode ON CAInterestCode = _InterestCode.CAInterestCode  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCategory AS _InvcgCategory ON CAInvcgCategory = _InvcgCategory.CAInvcgCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgSchedule AS _InvcgSchedule ON CAInvcgSchedule = _InvcgSchedule.CAInvcgSchedule  -- association [1..1]
LEFT OUTER JOIN I_CAMasterAgreement AS _MasterAgreement ON CAMasterAgreement = _MasterAgreement.CAMasterAgreement  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentMethod AS _PaytMethodIncg ON country = _PaytMethodIncg.Country AND CAPaymentMethodForIncgPayment = _PaytMethodIncg.CAPaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_CAOutgoingPaymentMethod AS _CAFirstOutgoingPaymentMethod ON country = _CAFirstOutgoingPaymentMethod.Country AND CAFirstOutgoingPaymentMethod = _CAFirstOutgoingPaymentMethod.CAOutgoingPaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_CAOutgoingPaymentMethod AS _CASecondOutgoingPaymentMethod ON country = _CASecondOutgoingPaymentMethod.Country AND CASecondOutgoingPaymentMethod = _CASecondOutgoingPaymentMethod.CAOutgoingPaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_CAOutgoingPaymentMethod AS _CAThirdOutgoingPaymentMethod ON country = _CAThirdOutgoingPaymentMethod.Country AND CAThirdOutgoingPaymentMethod = _CAThirdOutgoingPaymentMethod.CAOutgoingPaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_CAOutgoingPaymentMethod AS _CAFourthOutgoingPaymentMethod ON country = _CAFourthOutgoingPaymentMethod.Country AND CAFourthOutgoingPaymentMethod = _CAFourthOutgoingPaymentMethod.CAOutgoingPaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_CAOutgoingPaymentMethod AS _CAFifthOutgoingPaymentMethod ON country = _CAFifthOutgoingPaymentMethod.Country AND CAFifthOutgoingPaymentMethod = _CAFifthOutgoingPaymentMethod.CAOutgoingPaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_CAToleranceGroup AS _ToleranceGroup ON CAToleranceGroup = _ToleranceGroup.CAToleranceGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CAStandardCompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _PaymentCompCode ON capaymentcompanycode = _PaymentCompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ContrAcctPrtnRelshpType AS _RelshpOfBP ON CARelationshipOfBPToContrAcct = _RelshpOfBP.CARelationshipOfBPToContrAcct  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContrAcc ON ContractAccount = _ContrAcc.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _AltvContrAcc ON AltvContractAcctForCollvBills = _AltvContrAcc.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContrAcctForPayt ON ContractAccountForPayment = _ContrAcctForPayt.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContrAcctForPosting ON ContractAccountForPosting = _ContrAcctForPosting.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContrAcctForInvcgList ON ContractAccountForInvcgList = _ContrAcctForInvcgList.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SupplyingCountry ON SupplyingCountry = _SupplyingCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CurrencyForDDL ON CACurrencyForDirectDebitLimit = _CurrencyForDDL.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CurrencyForInvoicing ON CATargetCurrencyForInvoicing = _CurrencyForInvoicing.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentCondition AS _PaymentCondition ON PaymentCondition = _PaymentCondition.PaymentCondition  -- association [0..1]
LEFT OUTER JOIN E_ContractAccountPartner AS _Extension ON ContractAccount = _Extension.ContractAccount AND BusinessPartner = _Extension.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentMethod AS _PaytMethodOutg ON country = _PaytMethodOutg.Country AND CAPaymentMethodForOutgPayment = _PaytMethodOutg.CAPaymentMethod  -- association [0..1]
;