C_CO_DIANStRpFormat1001Cube

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 C_CO_DIANStRpFormat1001Cube.
-- 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 C_CO_DIANStRpFormat1001Cube AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  ReportedTaxNumber,
  TaxNumberType,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATRegistration,
  CO_DIANBPTaxLongNumber,
  CO_DIANTaxNumberType,
  Customer,
  Supplier,
  PurchasingDocument,
  BusinessPlace,
  AccountingDocumentType,
  BusinessPartnerCategory,
  BusinessPartner,
  FirstName,
  MiddleName,
  LastName,
  AdditionalLastName,
  cast(concat(OrganizationBPName1, OrganizationBPName2) as ficodian_bp_org_long_name ) AS BusinessPartnerOrgLongName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  IsNaturalPerson,
  BusinessPartnerCountry,
  CO_DIANCountry,
  Region,
  cast( right(CityCode, 3) as ficodian_city_code ) AS CityCode,
  CityName,
  StreetName,
  PostingDate,
  CreationUTCDateTime,
  GLAccount,
  GLAccountName,
  AlternativeGLAccount,
  Reference1IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  ReportingCurrency,
  DcblGLAcctPaytsAmtInRptgCrcy,
  NonDcblGLAcctPaytAmtInRptgCrcy,
  DcblVATIncrdCostInRptgCrcy,
  NonDcblVATIncrdCostInRptgCrcy,
  WhldgTxIncAmtInRptgCurrency,
  TakenWhldgTaxIncAmtInRptgCrcy,
  WhldgTaxCommonVATAmtInRptgCrcy,
  TknWhldgSimpfdVATAmtInRptgCrcy,
  WhldgTxForeignVATAmtInRptgCrcy,
  CO_WhldgCREEAmtInRptgCurrency,
  CO_TknWhldgCREEAmtInRptgCrcy,
  cast('' as ficodian_is_below_minimum_amt preserving type) AS IsBelowMinimumAmountThreshold
FROM P_CO_DIANStRpFormat1001
;