I_PubSecContractPartner

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_PubSecContractPartner.
-- 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_PubSecContractPartner AS
SELECT
  psobkey AS PublicSectorContract,
  partner AS ContractPartner,
  partneracctyp AS ContractAccountCategory,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  aenam AS LastChangedByUser,
  aedat AS LastChangedDate,
  xobsl AS ContractAccountIsObsolete,
  xdelp AS IsMarkedForArchiving,
  partneracc AS ContractAccount,
  kofiz AS CAAccountDeterminationCode,
  psob_pay_act AS PubSecContrPaytParamIsActv,
  eigbv AS CAHouseBankReference,
  adrnr AS AddressID,
  abwre AS CAAlternativePayer,
  adrre AS CAAddressIDOfAlternativePayer,
  ezawe AS CAPaymentMethodForIncgPayment,
  ebvty AS CABankIDForIncomingPayments,
  ccard_id AS CAPaymentCardIDForIncomingPayt,
  abwra AS CAAlternativePayee,
  adrra AS CAAddressIDOfAlternativePayee,
  azawe AS CAPaymentMethodForOutgPayment,
  abvty AS CABankIDForOutgoingPayments,
  ccard_out AS CAPaymentCardIDForOutgoingPayt,
  cmgrp AS CACollectionsMasterDataGroup,
  strat AS CACollectionStrategy,
  cpers AS CACollectionsContactPerson,
  mndid AS SEPAMandate,
  psob_corr_act AS ContrCorrespncParamIsActive,
  def_corr_partner AS CAAlternativeCorrespncRcpnt,
  def_corr_ackey AS CACorrespondenceActivityCode,
  coprc AS CACorrespondenceVariant,
  xsepinv AS SeparateInvoiceIsCreated,
  invtp AS PubSecContractInvoiceType,
  adrnum_corr AS CAAddrIDOfAltvCorrespncRcpnt,
  filstat AS InbCorrespncCreationStatus,
  coper AS CACorrespondenceRecurrence,
  filoffdy AS PostponementDays,
  filoffmt AS PostponementMonths,
  corr_mahnv AS CACorrespondenceDunningProced,
  firstper AS InboundCorrespncStartPeriod,
  firstper_yr AS InboundCorrespncStartYear,
  lastper AS InboundCorrespncEndPeriod,
  lastper_yr AS InboundCorrespncEndYear,
  individual AS InbCorrespncParamIsUsd,
  xreminder AS ReminderIsSent
FROM dpsob_bp_acc
LEFT OUTER JOIN I_PublicSectorContract AS _PublicSectorContract ON PublicSectorContract = _PublicSectorContract.PublicSectorContract  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountCategory AS _ContractAccountCategory ON ContractAccountCategory = _ContractAccountCategory.ContractAccountCategory AND _ContractAccountCategory.CAApplicationArea = 'P'  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ContractPartner ON ContractPartner = _ContractPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Address AS _ContractPartnerAddress ON AddressID = _ContractPartnerAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AlternativePayer ON CAAlternativePayer = _AlternativePayer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Address AS _AlternativePayerAddress ON CAAddressIDOfAlternativePayer = _AlternativePayerAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AlternativePayee ON CAAlternativePayee = _AlternativePayee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Address AS _AlternativePayeeAddress ON CAAddressIDOfAlternativePayee = _AlternativePayeeAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AlternativeCorrespncRcpnt ON CAAlternativeCorrespncRcpnt = _AlternativeCorrespncRcpnt.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Address AS _AltvCorrespncRcpntAddress ON CAAddrIDOfAltvCorrespncRcpnt = _AltvCorrespncRcpntAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_CACollMasterDataGroup AS _CACollectionsMasterDataGroup ON CACollectionsMasterDataGroup = _CACollectionsMasterDataGroup.CACollectionsMasterDataGroup  -- association [0..1]
;