C_CN_TaxInputInvcProcTP

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 C_CN_TaxInputInvcProcTP.
-- 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 C_CN_TaxInputInvcProcTP AS
SELECT
  Document.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  Document.CN_TaxInvcCode AS CN_TaxInvcCode,
  Document.CN_TaxInvcNmbr AS CN_TaxInvcNmbr,
  Document.CN_TaxInvcCodeNmbr AS CN_TaxInvcCodeNmbr,
  Document.CN_TaxSellerRegnNmbr AS CN_TaxSellerRegnNmbr,
  Document.CN_TaxBuyerRegnNmbr AS CN_TaxBuyerRegnNmbr,
  Document.CN_TaxInvcType AS CN_TaxInvcType,
  Document.CN_TaxInvcDate AS CN_TaxInvcDate,
  Document.CN_TaxDeclnDeadline AS CN_TaxDeclnDeadline,
  Document.CN_TaxInvcCrcy AS CN_TaxInvcCrcy,
  Document.CN_TaxInvcNetAmtInInvcCrcy AS CN_TaxInvcNetAmtInInvcCrcy,
  Document.CN_TaxInvcTaxAmtInInvcCrcy AS CN_TaxInvcTaxAmtInInvcCrcy,
  Document.CN_TaxInvcDeductAmtInInvcCrcy AS CN_TaxInvcDeductAmtInInvcCrcy,
  Document.CN_TaxInvcTotAmtInInvcCrcy AS CN_TaxInvcTotAmtInInvcCrcy,
  Document.CN_TaxEntityID AS CN_TaxEntityID,
  Document.CN_TaxInvcDiscNetAmtInInvcCrcy AS CN_TaxInvcDiscNetAmtInInvcCrcy,
  Document.CN_TaxInvcDiscTaxAmtInInvcCrcy AS CN_TaxInvcDiscTaxAmtInInvcCrcy,
  Document.CN_TaxInvcIsElectronic AS CN_TaxInvcIsElectronic,
  Document.TaxRate AS TaxRate,
  RatioUnit,
  Document.CompanyCode AS CompanyCode,
  Document.CN_TaxInvoiceUsage AS CN_TaxInvoiceUsage,
  Document.CN_TaxInvoiceDataSource AS CN_TaxInvoiceDataSource,
  Document.CN_TaxInvoiceExpenseReportNmbr AS CN_TaxInvoiceExpenseReportNmbr,
  Document.CN_TaxInvcGldnTxSystSts AS CN_TaxInvcGldnTxSystSts,
  Document.CN_TaxInvcGldnTxSystStsSyncTme AS CN_TaxInvcGldnTxSystStsSyncTme,
  Document.CN_TaxInvcInptProcgSts AS CN_TaxInvcInptProcgSts,
  Document.CN_TaxInvcDeductionType AS CN_TaxInvcDeductionType,
  Document.FiscalYear AS FiscalYear,
  Document.CN_TaxSellerName AS CN_TaxSellerName,
  Document.TaxCategory AS TaxCategory,
  Document.CN_TaxDeclnYear AS CN_TaxDeclnYear,
  Document.CN_TaxDeclnMonth AS CN_TaxDeclnMonth,
  Document.TaxInvoiceBuyerAddressPhone AS TaxInvoiceBuyerAddressPhone,
  Document.TaxInvoiceBuyerBankAccount AS TaxInvoiceBuyerBankAccount,
  Document.TaxInvoiceSellerAddressPhone AS TaxInvoiceSellerAddressPhone,
  Document.TaxInvoiceSellerBankAccount AS TaxInvoiceSellerBankAccount,
  Document.TaxInvoiceIsTaxRebate AS TaxInvoiceIsTaxRebate,
  Document.CN_IsNotVehicleTaxInvoice AS CN_IsNotVehicleTaxInvoice,
  Document.CN_IsNotTollTaxInvoice AS CN_IsNotTollTaxInvoice,
  Document.CN_TaxInvoiceVehicleType AS CN_TaxInvoiceVehicleType,
  Document.CN_TaxInvoiceVehFactoryModel AS CN_TaxInvoiceVehFactoryModel,
  Document.CN_TaxInvoiceVehicleProdnPlace AS CN_TaxInvoiceVehicleProdnPlace,
  Document.CN_TaxInvoiceVehicleCertNumber AS CN_TaxInvoiceVehicleCertNumber,
  Document.CN_TaxInvoiceVehImportCertNmbr AS CN_TaxInvoiceVehImportCertNmbr,
  Document.CN_TaxInvoiceVehicleInspNumber AS CN_TaxInvoiceVehicleInspNumber,
  Document.CN_TaxInvoiceVehicleEngineNmbr AS CN_TaxInvoiceVehicleEngineNmbr,
  Document.CN_TaxInvoiceVehicleNumber AS CN_TaxInvoiceVehicleNumber,
  Document.CN_TaxInvcVehTotAmtInInvcCrcy AS CN_TaxInvcVehTotAmtInInvcCrcy,
  Document.CN_TaxInvoiceVehTxnRecordNmbr AS CN_TaxInvoiceVehTxnRecordNmbr,
  Document.CN_TaxInvoiceVehicleTonnage AS CN_TaxInvoiceVehicleTonnage,
  Document.CN_TaxInvoiceVehPassengerLimit AS CN_TaxInvoiceVehPassengerLimit,
  Document.CN_TaxInvcComment AS CN_TaxInvcComment,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Supplier AS Supplier,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationUTCDateTime AS CreationUTCDateTime,
  Document.LastChangedByUser AS LastChangedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime
FROM I_CN_TaxInputInvcTP
LEFT OUTER JOIN C_CN_TaxEntity AS _TaxEntity ON CN_TaxEntityID = _TaxEntity.CN_TaxEntityID AND CompanyCode = _TaxEntity.CompanyCode  -- association [1]
LEFT OUTER JOIN C_CN_TaxInvcDeductionType AS _DeductionType ON CN_TaxInvcDeductionType = _DeductionType.CN_TaxInvcDeductionType  -- association [0..1]
LEFT OUTER JOIN C_CN_TaxInvcBindgRecd AS _BindingRecd ON CN_TaxInvcUUID = _BindingRecd.CN_TaxInvcUUID  -- association [0..*]
LEFT OUTER JOIN C_CN_TaxInputInvcStsChgLg AS _ChangeLog ON CN_TaxInvcUUID = _ChangeLog.CN_TaxInvcUUID  -- association [0..*]
LEFT OUTER JOIN C_CN_TaxCurrency AS _Currency ON CN_TaxInvcCrcy = _Currency.Currency  -- association [1]
LEFT OUTER JOIN C_CN_TaxCompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN C_CN_TaxInvcPurchasingOrg AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_CN_TaxInvcPurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_CN_TaxInvcSupplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN C_CN_TaxInvcType AS _InvoiceType ON CN_TaxInvcType = _InvoiceType.CN_TaxInvcType  -- association [1]
LEFT OUTER JOIN C_CN_TaxTransfItemTP AS _TransferItem ON CN_TaxInvcUUID = _TransferItem.CN_TaxInvcUUID  -- association [0..*]
LEFT OUTER JOIN C_CN_TaxInvcInptProcgSts AS _InvoiceStatus ON CN_TaxInvcInptProcgSts = _InvoiceStatus.CN_TaxInvcInptProcgSts  -- association [1..1]
LEFT OUTER JOIN C_CN_TaxInvcGldnTxSystSts AS _GoldenTaxStatus ON CN_TaxInvcGldnTxSystSts = _GoldenTaxStatus.CN_TaxInvcGldnTxSystSts  -- association [1..1]
LEFT OUTER JOIN C_CN_TaxInptVATCat AS _VATCategory ON TaxCategory = _VATCategory.TaxCategory AND ( TaxRate = _VATCategory.TaxRate OR _VATCategory.TaxRate = 0 )  -- association [0..1]
LEFT OUTER JOIN I_CN_TaxInvoiceUsageVH AS _InvoiceUsage ON CN_TaxInvoiceUsage = _InvoiceUsage.CN_TaxInvoiceUsage  -- association [1]
;