I_PublicSectorFormBundle

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_PublicSectorFormBundle.
-- 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_PublicSectorFormBundle AS
SELECT
  PublicSectorFormBundle.case_guid AS PublicSectorFormBundleUUID,
  cast(PublicSectorFormBundle.fbnum as ps_formbundle_number preserving type) AS PublicSectorFormBundle,
  cast(PublicSectorFormBundle.formproc as ps_form_process preserving type) AS PublicSectorFormProcess,
  cast(PublicSectorFormBundle.fbtyp as ps_formbundletype preserving type ) AS PublicSectorFormBundleType,
  PublicSectorFormBundle.revenue_type AS PublicSectorRevenueType,
  PublicSectorFormBundle.begru AS AuthorizationGroup,
  cast(PublicSectorFormBundle.taxpayer as ps_taxpayer preserving type) AS Taxpayer,
  cast(PublicSectorFormBundle.taxpayer_id as ps_taxpayer_id_number preserving type ) AS TaxpayerIdentification,
  cast(PublicSectorFormBundle.bu_id_type as ps_taxpayer_id_type preserving type ) AS TaxpayerIdentificationType,
  cast(PublicSectorFormBundle.account as ps_taxpayer_account preserving type ) AS TaxpayerAccount,
  cast(PublicSectorFormBundle.reg_id as ps_taxpayer_contract preserving type ) AS TaxpayerContract,
  cast(PublicSectorFormBundle.reg_type as ps_taxpayer_subap preserving type ) AS TaxpayerSubapplication,
  cast(PublicSectorFormBundle.joint_filer as ps_joint_taxpayer preserving type ) AS JointTaxpayer,
  cast(PublicSectorFormBundle.joint_filer_id as ps_joint_taxpayer_id_number preserving type ) AS JointTaxpayerIdentification,
  cast(PublicSectorFormBundle.joint_id_type as ps_joint_taxpayer_id_type preserving type ) AS JointTaxpayerIdnType,
  cast(PublicSectorFormBundle.joint_account as ps_joint_taxpayer_account preserving type ) AS JointTaxpayerAccount,
  cast(PublicSectorFormBundle.joint_reg_id as ps_joint_taxpayer_contract preserving type ) AS JointTaxpayerContract,
  cast(PublicSectorFormBundle.joint_reg_type as ps_joint_taxpayer_subap preserving type ) AS JointTaxpayerSubapplication,
  PublicSectorFormBundle.period_key AS CAPeriodCode,
  cast(PublicSectorFormBundle.apply_to as ps_billing_period_to preserving type ) AS CAEndDateOfBillingPeriod,
  PublicSectorFormBundle.betrw AS TaxAmountInTransCrcy,
  PublicSectorFormBundle.waers AS TransactionCurrency,
  PublicSectorFormBundle.fbsta AS PubSecFormBundleSystSts1,
  PublicSectorFormBundle.fbstb AS PubSecFormBundleSystSts2,
  PublicSectorFormBundle.fbust AS PubSecFormBundleUserStatus,
  cast(PublicSectorFormBundle.fbstz as ps_status_replicated preserving type ) AS FormBndlSystStsIsReplicated,
  cast(PublicSectorFormBundle.receipt as ps_received_on preserving type ) AS ReceiptDateTime,
  PublicSectorFormBundle.postmark AS PostmarkDateTime,
  PublicSectorFormBundle.validation AS ValidationDateTime,
  cast(PublicSectorFormBundle.due_date as ps_tax_due_date preserving type ) AS DueDate,
  PublicSectorFormBundle.deferral_date AS FormSubmissionDeferralDate,
  PublicSectorFormBundle.refund_complete AS RefundDate,
  PublicSectorFormBundle.postmark_ext AS PostmarkExtensionDate,
  PublicSectorFormBundle.reconciliation AS ReconciliationDate,
  PublicSectorFormBundle.last_filing AS FilingDate,
  cast(PublicSectorFormBundle.date_sol as ps_date_sol preserving type ) AS StatuteOfLimitationDate,
  PublicSectorFormBundle.keydt AS KeyDate,
  PublicSectorFormBundle.ernam AS CreatedByUser,
  cast( PublicSectorFormBundle.ertsp as ps_ertsp preserving type ) AS CreationDateTime,
  PublicSectorFormBundle.aenam AS LastChangedByUser,
  cast (PublicSectorFormBundle.aetsp as ps_aetsp preserving type ) AS LastChangeDateTime,
  PublicSectorFormBundle.transaction_type AS PublicSectorTransactionType,
  cast( PublicSectorFormBundle.in_channel as ps_communicationchannel preserving type) AS CACommunicationChannel,
  PublicSectorFormBundle.current_version AS PubSecFormBundleCurVersion,
  PublicSectorFormBundle.x_cons AS PubSecFormBundleIsCnsldtd,
  PublicSectorFormBundle.x_estimated AS PubSecFormBundleIsEstimated,
  PublicSectorFormBundle.consolidated_by AS ConsolidatingFormBundleUUID,
  PublicSectorFormBundle.duplicate_to AS DuplicateToFormBundleUUID,
  PublicSectorFormBundle.as_filed_ext AS DeferralRequestDate,
  PublicSectorFormBundle.locator_number AS CADocMgmtSrvcStorageLocation,
  PublicSectorFormBundle.batch_id AS CADocMgmtSrvcBatch,
  PublicSectorFormBundle.tax_preparer AS TaxAdviser,
  PublicSectorFormBundle.keypp AS CASubAreaForParallelization,
  PublicSectorFormBundle.indpr AS PublicSectorMassProcessingCode
FROM dfmca_return AS PublicSectorFormBundle
LEFT OUTER JOIN I_PublicSectorFormProcess AS _PublicSectorFormProcess ON PublicSectorFormProcess = _PublicSectorFormProcess.PublicSectorFormProcess  -- association [0..1]
LEFT OUTER JOIN I_PubSecFormBundleType AS _PublicSectorFormBundleType ON PublicSectorFormBundleType = _PublicSectorFormBundleType.PublicSectorFormBundleType  -- association [0..1]
LEFT OUTER JOIN I_PublicSectorRevenueType AS _PublicSectorRevenueType ON PublicSectorRevenueType = _PublicSectorRevenueType.PublicSectorRevenueType  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Taxpayer ON Taxpayer = _Taxpayer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BuPaIdentification AS _TaxpayerIdentification ON Taxpayer = _TaxpayerIdentification.BusinessPartner AND TaxpayerIdentificationType = _TaxpayerIdentification.BPIdentificationType AND TaxpayerIdentification = _TaxpayerIdentification.BPIdentificationNumber  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _TaxpayerAccountHeader ON TaxpayerAccount = _TaxpayerAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _TaxpayerAccount ON Taxpayer = _TaxpayerAccount.BusinessPartner AND TaxpayerAccount = _TaxpayerAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_PublicSectorContract AS _TaxpayerContractHeader ON TaxpayerContract = _TaxpayerContractHeader.PublicSectorContract  -- association [0..1]
LEFT OUTER JOIN I_PubSecContractPartner AS _TaxpayerContract ON TaxpayerContract = _TaxpayerContract.PublicSectorContract AND Taxpayer = _TaxpayerContract.ContractPartner AND TaxpayerAccount = _TaxpayerContract.ContractAccount  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _JointTaxpayer ON JointTaxpayer = _JointTaxpayer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BuPaIdentification AS _JointTaxpayerIdentification ON JointTaxpayer = _JointTaxpayerIdentification.BusinessPartner AND JointTaxpayerIdnType = _JointTaxpayerIdentification.BPIdentificationType AND JointTaxpayerIdentification = _JointTaxpayerIdentification.BPIdentificationNumber  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _JointTaxpayerAccountHeader ON JointTaxpayerAccount = _JointTaxpayerAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _JointTaxpayerAccount ON JointTaxpayer = _JointTaxpayerAccount.BusinessPartner AND JointTaxpayerAccount = _JointTaxpayerAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_PublicSectorContract AS _JointTaxpayerContractHeader ON JointTaxpayerContract = _JointTaxpayerContractHeader.PublicSectorContract  -- association [0..1]
LEFT OUTER JOIN I_PubSecContractPartner AS _JointTaxpayerContract ON JointTaxpayerContract = _JointTaxpayerContract.PublicSectorContract AND JointTaxpayer = _JointTaxpayerContract.ContractPartner AND JointTaxpayerAccount = _JointTaxpayerContract.ContractAccount  -- association [0..*]
LEFT OUTER JOIN I_CAPeriodCode AS _CAPeriodCode ON CAPeriodCode = _CAPeriodCode.CAPeriodCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SystemStatus AS _PubSecFormBundleSystSts1 ON PubSecFormBundleSystSts1 = _PubSecFormBundleSystSts1.SystemStatus  -- association [0..1]
LEFT OUTER JOIN I_SystemStatus AS _PubSecFormBundleSystSts2 ON PubSecFormBundleSystSts2 = _PubSecFormBundleSystSts2.SystemStatus  -- association [0..1]
LEFT OUTER JOIN I_CACommunicationChannel AS _CACommunicationChannel ON CACommunicationChannel = _CACommunicationChannel.CACommunicationChannel  -- 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]
;