P_PubSecActiveTaxObligation

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 P_PubSecActiveTaxObligation.
-- 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: PPSACTTAXOBL
-- Parameters: P_KeyDate : abap.dats

CREATE VIEW P_PubSecActiveTaxObligation AS
SELECT
  PublicSectorObjectType,
  PublicSectorObject,
  PublicSectorFactTypeSequence,
  PubSecFactTypeRepetition,
  PubSecFactValdtyEndDteTme,
  PubSecFactValdStartDteTme,
  PublicSectorFactSet,
  PublicSectorFactType,
  PublicSectorObjectNumber,
  cast (_FactTypeTaxPayer.PublicSectorFactValue as ps_taxpayer) AS Taxpayer,
  cast (_FactTypeContractAccount.PublicSectorFactValue as ps_taxpayer_account) AS TaxpayerAccount,
  cast (_FactTypeContractObject.PublicSectorFactValue as ps_taxpayer_contract) AS TaxpayerContract,
  PubSecRegnValdtyStartDate,
  PubSecRegnValdtyEndDate
FROM P_PubSecActiveTaxObligationRaw
LEFT OUTER JOIN I_PublicSectorFact AS _FactTypeTaxPayer ON PublicSectorObjectType = _FactTypeTaxPayer.PublicSectorObjectType AND PublicSectorObject = _FactTypeTaxPayer.PublicSectorObject AND PublicSectorFactTypeSequence = _FactTypeTaxPayer.PublicSectorFactTypeSequence AND PubSecFactTypeRepetition = _FactTypeTaxPayer.PubSecFactTypeRepetition AND _FactTypeTaxPayer.PublicSectorFactCatSqnc = '10' AND _FactTypeTaxPayer.PubSecFactCatRepetition = '0000' AND PubSecFactValdtyEndDteTme = _FactTypeTaxPayer.PubSecFactValdtyEndDteTme  -- association [0..1]
LEFT OUTER JOIN I_PublicSectorFact AS _FactTypeContractAccount ON PublicSectorObjectType = _FactTypeContractAccount.PublicSectorObjectType AND PublicSectorObject = _FactTypeContractAccount.PublicSectorObject AND PublicSectorFactTypeSequence = _FactTypeContractAccount.PublicSectorFactTypeSequence AND PubSecFactTypeRepetition = _FactTypeContractAccount.PubSecFactTypeRepetition AND _FactTypeContractAccount.PublicSectorFactCatSqnc = '20' AND _FactTypeContractAccount.PubSecFactCatRepetition = '0000' AND PubSecFactValdtyEndDteTme = _FactTypeContractAccount.PubSecFactValdtyEndDteTme  -- association [0..1]
LEFT OUTER JOIN I_PublicSectorFact AS _FactTypeContractObject ON PublicSectorObjectType = _FactTypeContractObject.PublicSectorObjectType AND PublicSectorObject = _FactTypeContractObject.PublicSectorObject AND PublicSectorFactTypeSequence = _FactTypeContractObject.PublicSectorFactTypeSequence AND PubSecFactTypeRepetition = _FactTypeContractObject.PubSecFactTypeRepetition AND _FactTypeContractObject.PublicSectorFactCatSqnc = '30' AND _FactTypeContractObject.PubSecFactCatRepetition = '0000' AND PubSecFactValdtyEndDteTme = _FactTypeContractObject.PubSecFactValdtyEndDteTme  -- association [0..1]
;