I_InsuranceObjectPartner

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_InsuranceObjectPartner.
-- 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_InsuranceObjectPartner AS
SELECT
  insobject AS InsuranceObject,
  partner AS BusinessPartner,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  insobjecttyp AS InsuranceObjectCategory_2,
  partneracc AS ContractAccount,
  partneracctyp AS ContractAccountCategory,
  fdgrp AS CashPlanningGroup,
  fdztg AS CAAdditionalDaysForCashMgmt,
  xarchive AS IsMarkedForDeletion,
  augrp AS CAAuthorizationGroup,
  mvari AS InsCollDisbDunningVariant,
  cmgrp AS CACollectionsMasterDataGroup,
  strat AS CACollectionStrategy,
  cpers AS CACollectionsContactPerson,
  is_covar AS CACorrespondenceVariant,
  cpar_active AS InsurObjCorrespncParamIsActive,
  def_rec AS CAAlternativeCorrespncRcpnt,
  def_rec_ind AS CACorrespondenceActivityCode,
  corr_mahnv AS CACorrespondenceDunningProced,
  obj1x_x AS InsurObjPaymentParamIsActive,
  adrnr AS AddressID,
  abwre_x AS CAAlternativePayer,
  adrre_x AS CAAddressIDOfAlternativePayer,
  ezawe_x AS CAPaymentMethodForIncgPayment,
  ebvty_x AS CABankIDForIncomingPayments,
  abwra_x AS CAAlternativePayee,
  adrra_x AS CAAddressIDOfAlternativePayee,
  azawe_x AS CAPaymentMethodForOutgPayment,
  abvty_x AS CABankIDForOutgoingPayments,
  transfer_acc AS ClearingContractAccount,
  indirect_trans AS VariableClearingIsActive,
  ccard_id AS CAPaymentCardIDForIncomingPayt,
  ccard_out AS CAPaymentCardIDForOutgoingPayt,
  ikey AS CAInterestCode,
  vkonv AS ContractAccountForPayment,
  gparv AS CABusinessPartnerForPayment,
  eigbv AS CAHouseBankReference,
  mndid_x AS SEPAMandate,
  qsskz_e AS CAWhldgTaxCodeIncomingPayt,
  qsskz_a AS CAWhldgTaxCodeOutgoingPayt
FROM dimaiobpar
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _CAAlternativeCorrespncRcpnt ON CAAlternativeCorrespncRcpnt = _CAAlternativeCorrespncRcpnt.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CAAlternativePayee ON CAAlternativePayee = _CAAlternativePayee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CAAlternativePayer ON CAAlternativePayer = _CAAlternativePayer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CACollectionContactPerson ON CACollectionsContactPerson = _CACollectionContactPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CAPaymentBusinessPartner ON CABusinessPartnerForPayment = _CAPaymentBusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CAAuthorizationGroup AS _CAAuthorizationGroup ON CAAuthorizationGroup = _CAAuthorizationGroup.CAAuthorizationGroup AND _CAAuthorizationGroup.CAAuthorizationGroupObject = 'INS_INSOBJ'  -- association [0..1]
LEFT OUTER JOIN I_CACollectionStrategy AS _CACollectionStrategy ON CACollectionStrategy = _CACollectionStrategy.CACollectionStrategy  -- association [0..1]
LEFT OUTER JOIN I_CACollMasterDataGroup AS _CACollMasterDataGroup ON CACollectionsMasterDataGroup = _CACollMasterDataGroup.CACollectionsMasterDataGroup  -- association [0..1]
LEFT OUTER JOIN I_CAInterestCode AS _CAInterestCode ON CAInterestCode = _CAInterestCode.CAInterestCode  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ClearingContractAccount ON ClearingContractAccount = _ClearingContractAccount.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _PaymentContractAccount ON ContractAccountForPayment = _PaymentContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountCategory AS _ContractAccountCategory ON ContractAccountCategory = _ContractAccountCategory.ContractAccountCategory AND ( _ContractAccountCategory.CAApplicationArea = 'V' OR _ContractAccountCategory.CAApplicationArea = 'C' )  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CACorrespncActivityCode AS _CACorrespncActivityCode ON CACorrespondenceActivityCode = _CACorrespncActivityCode.CACorrespondenceActivityCode  -- association [0..1]
LEFT OUTER JOIN I_CACorrespondenceVariant AS _CACorrespondenceVariant ON CACorrespondenceVariant = _CACorrespondenceVariant.CACorrespondenceVariant  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _CACorrespncDunningProcedure ON CACorrespondenceDunningProced = _CACorrespncDunningProcedure.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_InsCollDisbDunVariant AS _InsCollDisbDunVariant ON InsCollDisbDunningVariant = _InsCollDisbDunVariant.InsCollDisbDunningVariant  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObject AS _InsuranceObject ON InsuranceObject = _InsuranceObject.InsuranceObject  -- association [1..1]
LEFT OUTER JOIN I_InsuranceObjectCategory AS _InsuranceObjectCategory ON InsuranceObjectCategory_2 = _InsuranceObjectCategory.InsuranceObjectCategory_2  -- association [1..1]
;