I_CN_TaxInputInvcMng

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_TaxInputInvcMng.
-- 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_TaxInputInvcMng AS
SELECT
  hdr.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  hdr.CN_TaxInvcCode AS CN_TaxInvcCode,
  hdr.CN_TaxInvcNmbr AS CN_TaxInvcNmbr,
  cast ( hdr.CN_TaxSellerRegnNmbr as ficntax_slr_reg_nmbr ) AS CN_TaxSellerRegnNmbr,
  cast ( hdr.CN_TaxBuyerRegnNmbr as ficntax_buyr_reg_nmbr) 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_TaxEntityID AS CN_TaxEntityID,
  hdr.CN_TaxInvcDiscNetAmtInInvcCrcy AS CN_TaxInvcDiscNetAmtInInvcCrcy,
  hdr.CN_TaxInvcDiscTaxAmtInInvcCrcy AS CN_TaxInvcDiscTaxAmtInInvcCrcy,
  hdr.CN_TaxInvcIsElectronic AS CN_TaxInvcIsElectronic,
  hdr.TaxRate AS TaxRate,
  hdr.IsDeleted AS IsDeleted,
  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.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,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10,
  _Supplier.DataControllerSet AS DataControllerSet
FROM P_CN_TaxInputInvc AS hdr
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_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  -- association [0..1]
;