I_RU_AssetTaxCncsnDocBasic

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 I_RU_AssetTaxCncsnDocBasic.
-- 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.

CREATE VIEW I_RU_AssetTaxCncsnDocBasic AS
SELECT
  document_id AS RU_AstTxCncsnDocUUID,
  company_code AS CompanyCode,
  license_num AS RU_VehicleLicensePlateNumber,
  cadastral_num AS RU_LandPlotCadastrNumber,
  MasterFixedAsset,
  FixedAsset,
  concession_code AS RU_AssetTaxConcessionLegalCode,
  document_relevance AS RU_AstTxCncsnDocRlvnce,
  document_full_name AS RU_AstTxCncsnDocFullName,
  document_issuer AS RU_AstTxDocIssuerName,
  document_date AS RU_AssetTaxDocumentDate,
  document_number AS RU_AssetTaxDocumentNumber,
  term_type AS RU_AssetTaxDocumentTermType,
  date_from AS ValidityStartDate,
  date_to AS ValidityEndDate,
  createdby AS CreatedByUserName,
  createdat AS CreationDateTime,
  locallastchangedby AS ChangedByUserName,
  locallastchangedat AS ChangedDateTime,
  lastchangedat AS DraftLastChangedDateTime
FROM firud_atxcncdoc
;