R_ContractAccountPartnerTP

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 R_ContractAccountPartnerTP.
-- 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 R_ContractAccountPartnerTP AS
SELECT
  ContractAccount,
  BusinessPartner,
  BusinessPartner AS BusinessPartnerForEdit,
  ContractAccountName,
  CreationDate,
  CreationTime,
  cast( dats_tims_to_tstmp( CreationDate, CreationTime, 'UTC', $session.client, 'NULL' ) as vdm_creationdatetime) AS ContrAcctPrtnCreationDateTime,
  CreatedByUser,
  IsMarkedForDeletion,
  LastChangeDate,
  LastChangeTime,
  cast( dats_tims_to_tstmp( LastChangeDate, LastChangeTime, 'UTC', $session.client, 'NULL' ) as vdm_lastchangedon) AS ContrAcctPrtnLastChgDateTime,
  LastChangedByUser,
  CABankIDForIncomingPayments,
  CABankIDForOutgoingPayments,
  CAIncomingPaymentMethod,
  CACnctntdOutgPaymentMethods,
  CAFirstOutgoingPaymentMethod,
  CASecondOutgoingPaymentMethod,
  CAThirdOutgoingPaymentMethod,
  CAFourthOutgoingPaymentMethod,
  CAFifthOutgoingPaymentMethod,
  CAHouseBankReference,
  CAPaymentCardIDForIncomingPayt,
  CAPaymentCardIDForOutgoingPayt,
  SEPAMandate,
  CADunningProcedure,
  CADunningNoticeGroup,
  CACorrespondenceDunningProced,
  CACollectionsClerk,
  CACollectionsMasterDataGroup,
  CACollectionStrategy,
  CACollectionsContactPerson,
  ContractAccountForPayment,
  CABusinessPartnerForPayment,
  CAAlternativePayer,
  CAAlternativePayee,
  CAAlternativeDunningRecipient,
  CAAlternativeInvoiceRecipient,
  CAAlternativeCorrespncRcpnt,
  CAAddressIDOfAlternativePayer,
  CAAddressIDOfAlternativePayee,
  CAAddressIDOfAltvDunRecipient,
  CAAddressIDOfAltvInvoiceRcpnt,
  CACurrencyForDirectDebitLimit,
  CADirectDebitLimit,
  CANmbrMnthsForDirectDebitLimit,
  CADirectDebitLimitCalcMode,
  ContrAcctPrtnHasInvcgChrgDsc,
  CATargetCurrencyForInvoicing,
  CAInvcgCategory,
  CAInvcgSchedule,
  CABillgCycle,
  CALastDayOfBillingPeriod,
  CADetnCodeForAltvInvoiceForm,
  CABusinessPartnerForPosting,
  ContractAccountForPosting,
  CABusinessPartnerForInvcgList,
  ContractAccountForInvcgList,
  CAMasterAgreement,
  CAPartnerSettlementRule,
  ValdtyDateForWhldgTaxExmpCert,
  TaxJurisdiction,
  OutgPaytWithholdingTaxCode,
  IncgPaytWithholdingTaxCode,
  WithholdingTaxCertificate,
  CAAdditionalDaysForCashMgmt,
  CABusPartnerPostgLockExstcCode,
  CABusPartnerAddlLockExstcCode,
  CABusinessPartnerLockStartDate,
  CABusinessPartnerLockEndDate,
  CABPReferenceNumber,
  CACompanyCodeGroup,
  AltvContractAcctForCollvBills,
  CAInterestCode,
  CashPlanningGroup,
  CARelationshipOfBPToContrAcct,
  AddressID,
  CAAddressIDOfJurisdictionCode,
  CAAuthorizationGroup,
  CAToleranceGroup,
  CACorrespondenceVariant,
  PartnerCompany,
  CACorrespondenceActivityCode,
  CAClearingCategory,
  CADefaultClearingRstrcnCode,
  SupplyingCountry,
  BusinessPlace,
  CASubledgerApplication,
  PaymentCondition,
  CAAccountDeterminationCode,
  BusinessArea,
  CAPaymentCompanyCode,
  Country
FROM I_ContractAccountPartner
LEFT OUTER JOIN I_ContractAccountPartnerUI AS _ContrAcctPrtnUI ON ContractAccount = _ContrAcctPrtnUI.ContractAccount AND BusinessPartner = _ContrAcctPrtnUI.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByContactCard ON LastChangedByUser = _LastChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartnerAddress AS _Address ON BusinessPartner = _Address.BusinessPartner AND AddressID = _Address.AddressNumber  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartnerAddress AS _AlternativePayerAddress ON CAAlternativePayer = _AlternativePayerAddress.BusinessPartner AND AddressID = _AlternativePayerAddress.AddressNumber  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartnerPaymentCard AS _PaytCardForIncomingPayment ON BusinessPartner = _PaytCardForIncomingPayment.BusinessPartner AND CAPaymentCardIDForIncomingPayt = _PaytCardForIncomingPayment.PaymentCardID  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartnerPaymentCard AS _PaytCardForOutgoingPayment ON BusinessPartner = _PaytCardForOutgoingPayment.BusinessPartner AND CAPaymentCardIDForOutgoingPayt = _PaytCardForOutgoingPayment.PaymentCardID  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartnerBank AS _BankForIncomingPayment ON BusinessPartner = _BankForIncomingPayment.BusinessPartner AND CABankIDForIncomingPayments = _BankForIncomingPayment.BankIdentification  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartnerBank AS _BankForOutgoingPayment ON BusinessPartner = _BankForOutgoingPayment.BusinessPartner AND CABankIDForOutgoingPayments = _BankForOutgoingPayment.BankIdentification  -- association [0..1]
LEFT OUTER JOIN I_CADetnCodeForAltvInvcFm AS _CADetnCodeForAltvInvcFm ON CADetnCodeForAltvInvoiceForm = _CADetnCodeForAltvInvcFm.CADetnCodeForAltvInvoiceForm  -- association [1..1]
LEFT OUTER JOIN I_CALastDayOfBillingPeriod AS _CALastDayOfBillingPeriod ON CALastDayOfBillingPeriod = _CALastDayOfBillingPeriod.CALastDayOfBillingPeriod  -- association [1..1]
LEFT OUTER JOIN E_ContractAccountPartner AS _Extension ON ContractAccount = _Extension.ContractAccount AND BusinessPartner = _Extension.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN R_ContrAcctPrtnBusinessLockTP AS _ContrAcctPrtnBusinessLock ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ContrAcctPrtnCorrespncTP AS _ContrAcctPrtnCorrespnc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ConAcctPrtnInvcgChrgDscTP AS _ContrAcctPrtnInvcgChrgAndDisc ON /* condition not available in parsed metadata */  -- association [0..*]
;