P_CN_TaxInputInvc

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_CN_TaxInputInvc.
-- 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 P_CN_TaxInputInvc AS
SELECT
  hdr.invc_uuid AS CN_TaxInvcUUID,
  hdr.invc_code AS CN_TaxInvcCode,
  hdr.invc_nmbr AS CN_TaxInvcNmbr,
  hdr.seller_tax_reg_nmbr AS CN_TaxSellerRegnNmbr,
  hdr.buyer_tax_reg_nmbr AS CN_TaxBuyerRegnNmbr,
  hdr.invc_type AS CN_TaxInvcType,
  hdr.invc_iss_date AS CN_TaxInvcDate,
  hdr.invc_crcy_code AS CN_TaxInvcCrcy,
  hdr.net_amount AS CN_TaxInvcNetAmtInInvcCrcy,
  hdr.tax_amount AS CN_TaxInvcTaxAmtInInvcCrcy,
  hdr.deduct_tax_amount AS CN_TaxInvcDeductAmtInInvcCrcy,
  hdr.cntax_entity_id AS CN_TaxEntityID,
  hdr.disc_net_amount AS CN_TaxInvcDiscNetAmtInInvcCrcy,
  hdr.disc_tax_amount AS CN_TaxInvcDiscTaxAmtInInvcCrcy,
  hdr.is_elec_flag AS CN_TaxInvcIsElectronic,
  hdr.tax_rate AS TaxRate,
  hdr.mark_as_delete AS IsDeleted,
  hdr.usage AS CN_TaxInvoiceUsage,
  hdr.data_source AS CN_TaxInvoiceDataSource,
  hdr.expnrpt_nmbr AS CN_TaxInvoiceExpenseReportNmbr,
  hdr.company_code AS CompanyCode,
  hdr.invc_gts_status AS CN_TaxInvcGldnTxSystSts,
  hdr.invc_gts_sync_time AS CN_TaxInvcGldnTxSystStsSyncTme,
  hdr.input_invc_proc_status AS CN_TaxInvcInptProcgSts,
  hdr.invc_deduct_type AS CN_TaxInvcDeductionType,
  hdr.invc_fiscal_year AS FiscalYear,
  hdr.seller_name AS CN_TaxSellerName,
  hdr.comments AS CN_TaxInvcComment,
  hdr.input_vat_cat AS TaxCategory,
  hdr.invc_decln_time AS CN_TaxDeclnTime,
  hdr.invc_decln_year AS CN_TaxDeclnYear,
  hdr.invc_decln_month AS CN_TaxDeclnMonth,
  hdr.buyer_addr_tel AS TaxInvoiceBuyerAddressPhone,
  hdr.buyer_bank AS TaxInvoiceBuyerBankAccount,
  hdr.seller_addr_tel AS TaxInvoiceSellerAddressPhone,
  hdr.seller_bank AS TaxInvoiceSellerBankAccount,
  hdr.is_tax_rebate AS TaxInvoiceIsTaxRebate,
  hdr.decln_type AS TaxInvoiceDeclarationTypeCode,
  hdr.invc_posted_indicator AS IsPostedOnAccount,
  hdr.invc_postg_period AS CN_InvoicePostingPeriod,
  hdr.invc_postg_type AS CN_InvoicePostingType,
  hdr.invc_postg_date AS CN_InvoiceLatestPostingDate,
  hdr.invc_gts_result AS CN_GoldenTaxSystemResultString,
  hdr.invc_gts_risk_level AS CN_GoldenTaxSystemRiskLevel,
  hdr.invc_gts_spcfc_elmnts AS CN_InvoiceSpecificElement,
  hdr.invc_blue_nmbr AS CN_BlueInvoiceNumber,
  hdr.vehicle_type AS CN_TaxInvoiceVehicleType,
  hdr.veh_factory_model AS CN_TaxInvoiceVehFactoryModel,
  hdr.veh_prodn_place AS CN_TaxInvoiceVehicleProdnPlace,
  hdr.veh_cert_nmbr AS CN_TaxInvoiceVehicleCertNumber,
  hdr.veh_imprtcert_nmbr AS CN_TaxInvoiceVehImportCertNmbr,
  hdr.veh_insp_nmbr AS CN_TaxInvoiceVehicleInspNumber,
  hdr.veh_engine_nmbr AS CN_TaxInvoiceVehicleEngineNmbr,
  hdr.vehicle_nmbr AS CN_TaxInvoiceVehicleNumber,
  hdr.veh_total_amount AS CN_TaxInvcVehTotAmtInInvcCrcy,
  hdr.veh_txn_recd_nmbr AS CN_TaxInvoiceVehTxnRecordNmbr,
  hdr.veh_tonnage AS CN_TaxInvoiceVehicleTonnage,
  hdr.veh_pssengr_limit AS CN_TaxInvoiceVehPassengerLimit,
  hdr.purchase_org AS PurchasingOrganization,
  hdr.purchase_grp AS PurchasingGroup,
  hdr.supplier AS Supplier,
  hdr.create_user AS CreatedByUser,
  hdr.create_time AS CreationUTCDateTime,
  hdr.change_user AS LastChangedByUser,
  hdr.change_time AS LastChangeDateTime
FROM txi_hdr AS hdr
LEFT OUTER JOIN P_CN_TaxInputInvoiceItem AS _InvoiceItem ON CN_TaxInvcUUID = _InvoiceItem.CN_TaxInvcUUID  -- association [1..*]
;