P_CO_DIANStRpAggrgFormat1001

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_CO_DIANStRpAggrgFormat1001.
-- 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.
-- Parameters: P_Ledger : fins_ledger, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_CO_DIANStRpAggrgFormat1001 AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  ReportedTaxNumber,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATRegistration,
  CO_DIANBPTaxLongNumber,
  Reference1IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  TaxNumberType,
  cast( coalesce( _DIANTaxNumberTypeMapping.CO_DIANTaxNumberType, '00' ) as ficodian_doc_type preserving type ) AS CO_DIANTaxNumberType,
  Customer,
  Supplier,
  PurchasingDocument,
  BusinessPlace,
  AccountingDocumentType,
  BusinessPartnerCategory,
  BusinessPartner,
  FirstName,
  MiddleName,
  LastName,
  AdditionalLastName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  IsNaturalPerson,
  BusinessPartnerCountry,
  CompanyCodeCountry,
  _CO_DIANCountryMapping.CO_DIANCountry AS CO_DIANCountry,
  Region,
  CityCode,
  CityName,
  StreetName,
  PostingDate,
  cast( cast( 0 as abap.dec( 15 , 0 ) ) as timestamp preserving type) AS CreationUTCDateTime,
  GLAccount,
  AlternativeGLAccount,
  ReportingCurrency,
  DcblGLAcctPaytsAmtInRptgCrcy,
  NonDcblGLAcctPaytAmtInRptgCrcy,
  DcblVATIncrdCostInRptgCrcy,
  NonDcblVATIncrdCostInRptgCrcy,
  WhldgTxIncAmtInRptgCurrency,
  TakenWhldgTaxIncAmtInRptgCrcy,
  WhldgTaxCommonVATAmtInRptgCrcy,
  TknWhldgSimpfdVATAmtInRptgCrcy,
  WhldgTxForeignVATAmtInRptgCrcy,
  CO_WhldgCREEAmtInRptgCurrency,
  CO_TknWhldgCREEAmtInRptgCrcy,
  Employee._CompanyCode AS _CompanyCode,
  Employee._CompanyCodeCountryMapping AS _CompanyCodeCountryMapping
FROM P_CO_DIANFrmt1001JrnlEntrItem4
INNER JOIN I_CO_DIANItemType AS DIANItemType ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CO_DIANStRpEmplAggrgdPyrl
;