I_CN_TaxInputInvcTP

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_CN_TaxInputInvcTP.
-- 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_CN_TaxInputInvcTP 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,
  cast( $session.system_date as ficntaxinvc_decln_end_date) AS CN_TaxDeclnDeadline,
  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 CN_TaxEntityID,
  hdr.CN_TaxInvcDiscNetAmtInInvcCrcy AS CN_TaxInvcDiscNetAmtInInvcCrcy,
  hdr.CN_TaxInvcDiscTaxAmtInInvcCrcy AS CN_TaxInvcDiscTaxAmtInInvcCrcy,
  hdr.CN_TaxInvcIsElectronic AS CN_TaxInvcIsElectronic,
  hdr.CN_TaxInvoiceUsage AS CN_TaxInvoiceUsage,
  hdr.CN_TaxInvoiceDataSource AS CN_TaxInvoiceDataSource,
  hdr.CN_TaxInvoiceExpenseReportNmbr AS CN_TaxInvoiceExpenseReportNmbr,
  hdr.IsPostedOnAccount AS IsPostedOnAccount,
  hdr.TaxRate AS TaxRate,
  cast('%' as msehi) AS RatioUnit,
  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.FiscalYear AS FiscalYear,
  hdr.CN_TaxSellerName AS CN_TaxSellerName,
  hdr.CN_TaxInvcComment AS CN_TaxInvcComment,
  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.TaxInvoiceIsTaxRebate AS TaxInvoiceIsTaxRebate,
  hdr.TaxInvoiceDeclarationTypeCode AS TaxInvoiceDeclarationTypeCode,
  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,
  cast( concat( CN_TaxDeclnYear, CN_TaxDeclnMonth ) as ficntaxdecln_yearmonth) AS CN_TaxDeclnYearMonth,
  hdr.PurchasingOrganization AS PurchasingOrganization,
  hdr.PurchasingGroup AS PurchasingGroup,
  hdr.Supplier AS Supplier,
  hdr.CreatedByUser AS CreatedByUser,
  hdr.CreationUTCDateTime AS CreationUTCDateTime,
  hdr.LastChangedByUser AS LastChangedByUser,
  hdr.LastChangeDateTime AS LastChangeDateTime,
  cast('' as char40) AS DocumentStatusDesc,
  cast( '' as char512) AS DocumentHeaderText,
  cast( '' as val_text) AS EditingStatusText,
  cast( 0 as nmbrofattachments) AS NumberOfAttachments
FROM I_CN_TaxInputInvc AS hdr
LEFT OUTER JOIN I_CN_TaxInvcBindgRecd AS _BindingRecd ON CN_TaxInvcUUID = _BindingRecd.CN_TaxInvcUUID  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON CN_TaxInvcCrcy = _Currency.Currency  -- association [1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CN_TaxEntity AS _TaxEntity ON CN_TaxEntityID = _TaxEntity.CN_TaxEntityID AND CompanyCode = _TaxEntity.CompanyCode  -- association [1]
LEFT OUTER JOIN I_CN_TaxInvcType AS _InvoiceType ON CN_TaxInvcType = _InvoiceType.CN_TaxInvcType  -- association [1]
LEFT OUTER JOIN I_CN_TaxInvcDeductionType AS _DeductionType ON CN_TaxInvcDeductionType = _DeductionType.CN_TaxInvcDeductionType  -- association [1]
LEFT OUTER JOIN I_CN_TaxTransfItemTP AS _TransferItem ON CN_TaxInvcUUID = _TransferItem.CN_TaxInvcUUID  -- association [0..*]
LEFT OUTER JOIN I_CN_TaxInputInvcStsChgLg AS _ChangeLog ON CN_TaxInvcUUID = _ChangeLog.CN_TaxInvcUUID  -- association [0..*]
LEFT OUTER JOIN I_CN_TaxInvcInptProcgSts AS _InvoiceStatus ON CN_TaxInvcInptProcgSts = _InvoiceStatus.CN_TaxInvcInptProcgSts  -- association [1..1]
LEFT OUTER JOIN I_CN_TaxInvcGldnTxSystSts AS _GoldenTaxStatus ON CN_TaxInvcGldnTxSystSts = _GoldenTaxStatus.CN_TaxInvcGldnTxSystSts  -- association [1..1]
LEFT OUTER JOIN I_CN_TaxInptVATCat AS _VATCategory ON TaxCategory = _VATCategory.TaxCategory AND TaxRate = _VATCategory.TaxRate  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RatioUnit ON RatioUnit = _RatioUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_CN_TaxInvoiceDeclnType AS _DeclnType ON TaxInvoiceDeclarationTypeCode = _DeclnType.TaxInvoiceDeclarationTypeCode  -- association [1..1]
LEFT OUTER JOIN I_CN_TaxInvoicePostingType AS _PostingType ON CN_InvoicePostingType = _PostingType.CN_InvoicePostingType  -- association [1]
LEFT OUTER JOIN I_CN_TaxInvoiceRiskLevel AS _RiskLevel ON CN_GoldenTaxSystemRiskLevel = _RiskLevel.CN_GoldenTaxSystemRiskLevel  -- association [1]
LEFT OUTER JOIN I_CN_TaxInvoiceSpecificElmnt AS _SpecificElements ON CN_InvoiceSpecificElement = _SpecificElements.CN_InvoiceSpecificElement  -- association [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]
LEFT OUTER JOIN I_CN_TaxInvoiceUsageVH AS _InvoiceUsage ON CN_TaxInvoiceUsage = _InvoiceUsage.CN_TaxInvoiceUsage  -- association [1]
LEFT OUTER JOIN I_CN_TaxInputInvoiceItemTP AS _InvoiceItem ON /* condition not available in parsed metadata */  -- association [0..*]
;