FISTRPGSTR3BITEM

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 FISTRPGSTR3BITEM.
-- 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: FISRGSTR3BITM
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW FISTRPGSTR3BITEM AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxRate,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  ReportingDate,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  AmountInReportingCurrency,
  AmountInTransactionCurrency,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  I_StRpTaxReturnBoxCube.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  TaxType,
  TaxCalculationProcedure,
  TargetTaxCode,
  ConditionType,
  TaxNumber1,
  TaxNumber2,
  case when _bseg.koart = 'K' then _lfa1.stcd3 when _bseg.koart = 'D' then _CustomerToBusinessPartner._Customer.TaxNumber3 end as TaxNumber3 AS TaxNumber3endasTaxNumber3,
  I_StRpTaxReturnBoxCube.BusinessPartner AS BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxIsNotDeductible,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  TaxGroup,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation,
  _AccountingDocument.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  cond_name,
  _mbseg.matnr AS matnr,
  _mbseg.werks AS werks,
  _mbseg.hkont AS hkont,
  _hbseg.hsn_sac AS hsn_sac,
  _bseg.plc_sup AS plc_sup,
  _bseg.gst_part AS gst_part,
  _lfa1.ven_class AS ven_class,
  rec_cgst,
  rec_cgst_con,
  rec_sgst,
  rec_sgst_con,
  rec_ugst,
  rec_ugst_con,
  rec_igst,
  rec_igst_con,
  rec_cess,
  rec_cess_con,
  _JV.rev_amt AS rev_amt,
  _JV.jv_type AS jv_type,
  case when (_lfa1.stcd3 is null or _lfa1.stcd3 = '') and ( _CustomerToBusinessPartner._Customer.TaxNumber3 is null or _CustomerToBusinessPartner._Customer.TaxNumber3 = '' ) then 'U' else 'R' end as RegisteredInd AS TaxNumber3thenUelseRendasRegisteredInd,
  case when _bseg.koart = 'D' then _DFKKBPTAXNUM_ADR.BPTaxNumber else '' end as BPTaxNumber AS BPTaxNumberelseendasBPTaxNumber
LEFT OUTER JOIN j_1iexcdefn AS _CodeName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bseg AS _bseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FIACCDOCINHSN AS _hbseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bseg AS _mbseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 AS _lfa1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerCustomer AS _BUSINESSPARTNERCUSTOMER ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusPartAddrDepdntTaxNmbr AS _DFKKBPTAXNUM_ADR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN j_1ig_isd_distr AS _ISD ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN knvi AS _knvi ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustSlsAreaAddrDepdntTaxInfo AS knvi_addr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN j_1ig_gst_jv AS _JV ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN j_1istatecdm AS _StateCode ON /* join condition not captured in parsed metadata */
;