FAC_AUDIT_Z3_PROPOSE_TAX_VIEW

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 FAC_AUDIT_Z3_PROPOSE_TAX_VIEW.
-- 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: FACAUDPROTAXVIEW
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to

CREATE VIEW FAC_AUDIT_Z3_PROPOSE_TAX_VIEW AS
SELECT
  _header.ProposalTaxPostingIdentifier AS ProposalTaxPostingIdentifier,
  _item.ProposalTaxPostingItem AS ProposalTaxPostingItem,
  _taxItem.ProposalTaxPostingTaxItem AS ProposalTaxPostingTaxItem,
  _header.CrossBorderTaxProposalCategory AS CrossBorderTaxProposalCategory,
  _header.CrossBorderTaxPrpslSubcategory AS CrossBorderTaxPrpslSubcategory,
  _header.MaterialDocument AS MaterialDocument,
  _header.MaterialDocumentYear AS MaterialDocumentYear,
  _header.NrOfMaterialDocumentHeaders AS NrOfMaterialDocumentHeaders,
  _header.OutboundDelivery AS OutboundDelivery,
  _header.TransactionCurrency AS TransactionCurrency,
  _header.CompanyCode AS CompanyCode,
  _header.ReversedMaterialDocument AS ReversedMaterialDocument,
  _header.ReversedMaterialDocumentYear AS ReversedMaterialDocumentYear,
  _header.NrOfReversedMatlDocHeaders AS NrOfReversedMatlDocHeaders,
  _header.MaterialDocPostgDate AS MaterialDocPostgDate,
  _header.MaterialDocumentCreationDate AS MaterialDocumentCreationDate,
  _header.MaterialDocCreationTime AS MaterialDocCreationTime,
  _header.Customer AS Customer,
  _header.TaxDepartureCountry AS TaxDepartureCountry,
  _header.TaxDestinationCountry AS TaxDestinationCountry,
  _header.TaxPostingStatus AS TaxPostingStatus,
  _header.TaxPostingReverseCode AS TaxPostingReverseCode,
  _header.TaxPostingCancelCode AS TaxPostingCancelCode,
  _header.JournalEntry AS JournalEntry,
  _header.FiscalYear AS FiscalYear,
  _header.PostingDate AS PostingDate,
  _header.CustomerVATRegistration AS CustomerVATRegistration,
  _header.DeptrCtryCoCodeVATRegnNumber AS DeptrCtryCoCodeVATRegnNumber,
  _header.DestCtryCoCodeVATRegnNumber AS DestCtryCoCodeVATRegnNumber,
  _header.CreatedByUser AS CreatedByUser,
  _header.CreationDate AS CreationDate,
  _header.CreationTime AS CreationTime,
  _header.LastChangedByUser AS LastChangedByUser,
  _header.LastChangeDate AS LastChangeDate,
  _header.LastChangeTime AS LastChangeTime,
  _header.IncotermsPart1 AS IncotermsPart1,
  _header.AccountingExchangeRate AS AccountingExchangeRate,
  _header.TaxDestinationCountry AS DestinationCountry,
  _header.Region AS Region,
  _header.ForeignTradeStstclCurrency AS ForeignTradeStstclCurrency,
  _header.SalesOrganization AS SalesOrganization,
  _header.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  _header.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  _item.DeliveringPlant AS DeliveringPlant,
  _item.ReceivingPlant AS ReceivingPlant,
  _item.MaterialDocumentItem AS MaterialDocumentItem,
  _item.OutboundDeliveryItem AS OutboundDeliveryItem,
  _item.Batch AS Batch,
  _item.HigherLvlItmOfBatSpltItm AS HigherLvlItmOfBatSpltItm,
  _item.ReversedMaterialDocumentItem AS ReversedMaterialDocumentItem,
  _item.Material AS Material,
  _item.QuantityInEntryUnit AS QuantityInEntryUnit,
  _item.SalesUnit AS SalesUnit,
  _item.QuantityInEntryUnitBaseUnit AS QuantityInEntryUnitBaseUnit,
  _item.BaseUnit AS BaseUnit,
  _item.MaterialNetWeight AS MaterialNetWeight,
  _item.WeightUnit AS WeightUnit,
  _item.ServicesRenderedDate AS ServicesRenderedDate,
  _item.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  _item.ItemNetAmountOfBillingDoc AS ItemNetAmountOfBillingDoc,
  _item.PrecdgSDDocCategory AS PrecdgSDDocCategory,
  _item.SalesDocument AS SalesDocument,
  _item.SalesDocumentItem AS SalesDocumentItem,
  _item.SalesDocumentItemText AS SalesDocumentItemText,
  _item.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  _item.SDDocumentCategory AS SDDocumentCategory,
  _item.ItemGrossAmountOfBillingDoc AS ItemGrossAmountOfBillingDoc,
  _item.ForeignTradeStstclAmt AS ForeignTradeStstclAmt,
  _item.CountryOfOrigin AS CountryOfOrigin,
  _item.RegionOfOrigin AS RegionOfOrigin,
  _item.CommodityCode AS CommodityCode,
  _item.SpecialStockIdfgCustomer AS SpecialStockIdfgCustomer,
  _item.SoldToParty AS SoldToParty,
  _item.SoldToPartyAddressID AS SoldToPartyAddressID,
  _item.ShipToParty AS ShipToParty,
  _item.ShipToPartyAddressID AS ShipToPartyAddressID,
  _taxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  _taxItem.TaxCode AS TaxCode,
  _taxItem.ConditionType AS ConditionType,
  _taxItem.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  _taxItem.TaxProposalTaxationDate AS TaxProposalTaxationDate,
  _taxItem.TaxRate AS TaxRate,
  _taxItem.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  _taxItem.TaxCountry AS TaxCountry,
  _taxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  cast ( $session.client as char3 ) AS SystemClient,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant
FROM I_CsgnmtAndSTOTaxPrpsl AS _header
LEFT OUTER JOIN I_CsgnmtAndSTOTaxPrpslItem AS _item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CsgnmtAndSTOTxPrpslTaxItem AS _taxItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
;