C_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 C_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 C_CN_TaxInputInvcTP 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_TaxInvoiceIssueDateTime AS CN_TaxInvoiceIssueDateTime,
  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.CN_TaxInvoiceUsage AS CN_TaxInvoiceUsage,
  Document.CN_TaxInvoiceDataSource AS CN_TaxInvoiceDataSource,
  Document.CN_TaxInvoiceExpenseReportNmbr AS CN_TaxInvoiceExpenseReportNmbr,
  Document.TaxRate AS TaxRate,
  RatioUnit,
  Document.CompanyCode AS CompanyCode,
  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_InvoicePostingPeriod AS CN_InvoicePostingPeriod,
  Document.CN_InvoicePostingType AS CN_InvoicePostingType,
  Document.CN_InvoiceLatestPostingDate AS CN_InvoiceLatestPostingDate,
  Document.CN_GoldenTaxSystemResultString AS CN_GoldenTaxSystemResultString,
  Document.CN_GoldenTaxSystemRiskLevel AS CN_GoldenTaxSystemRiskLevel,
  Document.CN_InvoiceSpecificElement AS CN_InvoiceSpecificElement,
  Document.CN_BlueInvoiceNumber AS CN_BlueInvoiceNumber,
  Document.CN_TaxSellerName AS CN_TaxSellerName,
  Document.TaxCategory AS TaxCategory,
  Document.CN_TaxDeclnYear AS CN_TaxDeclnYear,
  Document.CN_TaxDeclnMonth AS CN_TaxDeclnMonth,
  Document.CN_TaxDeclnYearMonth AS CN_TaxDeclnYearMonth,
  Document.TaxInvoiceBuyerAddressPhone AS TaxInvoiceBuyerAddressPhone,
  Document.TaxInvoiceBuyerBankAccount AS TaxInvoiceBuyerBankAccount,
  Document.TaxInvoiceSellerAddressPhone AS TaxInvoiceSellerAddressPhone,
  Document.TaxInvoiceSellerBankAccount AS TaxInvoiceSellerBankAccount,
  Document.TaxInvoiceIsTaxRebate AS TaxInvoiceIsTaxRebate,
  Document.IsPostedOnAccount AS IsPostedOnAccount,
  Document.TaxInvoiceDeclarationTypeCode AS TaxInvoiceDeclarationTypeCode,
  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,
  Document.DocumentStatusDesc AS DocumentStatusDesc,
  Document.DocumentHeaderText AS DocumentHeaderText,
  Document.EditingStatusText AS EditingStatusText,
  Document.NumberOfAttachments AS NumberOfAttachments,
  Document.CN_TaxInvoiceVerificationType AS CN_TaxInvoiceVerificationType,
  Document.CN_TxInvoiceVerificationStatus AS CN_TxInvoiceVerificationStatus
FROM I_CN_TaxInputInvcTP
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_TaxTransfItemTP AS _TransferItem ON CN_TaxInvcUUID = _TransferItem.CN_TaxInvcUUID  -- association [0..*]
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_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_TaxInvcDeductionType AS _DeductionType ON CN_TaxInvcDeductionType = _DeductionType.CN_TaxInvcDeductionType  -- association [1]
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  -- association [0..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 C_CN_TaxInvoiceDeclnType AS _DeclnType ON TaxInvoiceDeclarationTypeCode = _DeclnType.TaxInvoiceDeclarationTypeCode  -- association [1..1]
LEFT OUTER JOIN I_CN_TaxInvoiceUsageVH AS _InvoiceUsage ON CN_TaxInvoiceUsage = _InvoiceUsage.CN_TaxInvoiceUsage  -- association [1]
;