A_CN_TaxInputInvoice

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 A_CN_TaxInputInvoice.
-- 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: ACNTXIIPT

CREATE VIEW A_CN_TaxInputInvoice AS
SELECT
  hdr.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  hdr.CN_TaxInvcCode AS CN_TaxInvcCode,
  hdr.CN_TaxInvcNmbr AS CN_TaxInvcNmbr,
  hdr.CN_TaxSellerRegnNmbr AS CN_TaxSellerRegnNmbr,
  hdr.CN_TaxBuyerRegnNmbr AS CN_TaxBuyerRegnNmbr,
  hdr.CN_TaxInvcType AS CN_TaxInvcType,
  hdr.CN_TaxInvcDate AS CN_TaxInvcDate,
  hdr.CN_TaxInvcCrcy AS CN_TaxInvcCrcy,
  hdr.CN_TaxInvcNetAmtInInvcCrcy AS CN_TaxInvcNetAmtInInvcCrcy,
  hdr.CN_TaxInvcTaxAmtInInvcCrcy AS CN_TaxInvcTaxAmtInInvcCrcy,
  hdr.CN_TaxInvcDeductAmtInInvcCrcy AS CN_TaxInvcDeductAmtInInvcCrcy,
  hdr.CN_TaxEntityID AS BusinessPlace,
  hdr.CN_TaxInvcDiscNetAmtInInvcCrcy AS CN_TaxInvcDiscNetAmtInInvcCrcy,
  hdr.CN_TaxInvcDiscTaxAmtInInvcCrcy AS CN_TaxInvcDiscTaxAmtInInvcCrcy,
  hdr.TaxRate AS TaxRate,
  hdr.CompanyCode AS CompanyCode,
  hdr.CN_TaxInvcGldnTxSystSts AS CN_TaxInvcGldnTxSystSts,
  hdr.CN_TaxInvcGldnTxSystStsSyncTme AS CN_TaxInvcGldnTxSystStsSyncTme,
  hdr.CN_TaxInvcInptProcgSts AS CN_TaxInvcInptProcgSts,
  hdr.CN_TaxInvcDeductionType AS CN_TaxInvcDeductionType,
  hdr.CN_TaxSellerName AS CN_TaxSellerName,
  cast( hdr.CN_TaxInvcComment as ficntaxinvc_comments_255 ) AS CN_TaxInvcComment,
  hdr.CN_TaxInvcComment AS CN_TaxInvoiceCommentText,
  hdr.CN_TaxInvoiceUsage AS CN_TaxInvoiceUsage,
  hdr.CN_TaxInvoiceDataSource AS CN_TaxInvoiceDataSource,
  hdr.CN_TaxInvoiceExpenseReportNmbr AS CN_TaxInvoiceExpenseReportNmbr,
  hdr.IsPostedOnAccount AS IsPostedOnAccount,
  hdr.TaxCategory AS TaxCategory,
  hdr.CN_TaxDeclnTime AS CN_TaxDeclnTime,
  hdr.CN_TaxDeclnYear AS CN_TaxDeclnYear,
  hdr.CN_TaxDeclnMonth AS CN_TaxDeclnMonth,
  hdr.TaxInvoiceBuyerAddressPhone AS TaxInvoiceBuyerAddressPhone,
  hdr.TaxInvoiceBuyerBankAccount AS TaxInvoiceBuyerBankAccount,
  hdr.TaxInvoiceSellerAddressPhone AS TaxInvoiceSellerAddressPhone,
  hdr.TaxInvoiceSellerBankAccount AS TaxInvoiceSellerBankAccount,
  hdr.CN_InvoicePostingPeriod AS CN_InvoicePostingPeriod,
  hdr.CN_InvoicePostingType AS CN_InvoicePostingType,
  hdr.CN_InvoiceLatestPostingDate AS CN_InvoiceLatestPostingDate,
  hdr.CN_GoldenTaxSystemResultString AS CN_GoldenTaxSystemResultString,
  hdr.CN_GoldenTaxSystemRiskLevel AS CN_GoldenTaxSystemRiskLevel,
  hdr.CN_InvoiceSpecificElement AS CN_InvoiceSpecificElement,
  hdr.CN_BlueInvoiceNumber AS CN_BlueInvoiceNumber,
  hdr.CN_TaxInvoiceVehicleType AS CN_TaxInvoiceVehicleType,
  hdr.CN_TaxInvoiceVehFactoryModel AS CN_TaxInvoiceVehFactoryModel,
  hdr.CN_TaxInvoiceVehicleProdnPlace AS CN_TaxInvoiceVehicleProdnPlace,
  hdr.CN_TaxInvoiceVehicleCertNumber AS CN_TaxInvoiceVehicleCertNumber,
  hdr.CN_TaxInvoiceVehImportCertNmbr AS CN_TaxInvoiceVehImportCertNmbr,
  hdr.CN_TaxInvoiceVehicleInspNumber AS CN_TaxInvoiceVehicleInspNumber,
  hdr.CN_TaxInvoiceVehicleEngineNmbr AS CN_TaxInvoiceVehicleEngineNmbr,
  hdr.CN_TaxInvoiceVehicleNumber AS CN_TaxInvoiceVehicleNumber,
  hdr.CN_TaxInvcVehTotAmtInInvcCrcy AS CN_TaxInvcVehTotAmtInInvcCrcy,
  hdr.CN_TaxInvoiceVehTxnRecordNmbr AS CN_TaxInvoiceVehTxnRecordNmbr,
  hdr.CN_TaxInvoiceVehicleTonnage AS CN_TaxInvoiceVehicleTonnage,
  hdr.CN_TaxInvoiceVehPassengerLimit AS CN_TaxInvoiceVehPassengerLimit,
  hdr.PurchasingOrganization AS PurchasingOrganization,
  hdr.PurchasingGroup AS PurchasingGroup,
  hdr.Supplier AS Supplier
FROM I_CN_TaxInputInvc AS hdr
LEFT OUTER JOIN A_CN_TaxInputInvoiceItem AS _Item ON CN_TaxInvcUUID = _Item.CN_TaxInvcUUID  -- association [1..*]
LEFT OUTER JOIN A_CN_TaxInvoiceBindingRecord AS _Binding ON CN_TaxInvcUUID = _Binding.CN_TaxInvcUUID  -- association [1..*]
LEFT OUTER JOIN A_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN E_CN_TaxInputInvc AS _CommonExtension ON CN_TaxInvcUUID = _CommonExtension.CN_TaxInvcUUID  -- association [1..1]
LEFT OUTER JOIN E_CN_TaxInputInvcMng AS _ManageExtension ON CN_TaxInvcUUID = _ManageExtension.CN_TaxInvcUUID  -- association [1..1]
;