P_CN_TAXINPUTINVC

CDS View

P_CN_TAXINPUTINVC is a CDS View in S/4HANA. It contains 59 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CN_TaxInputInvc view from BASIC Incoming VAT Invoice
I_CN_TaxInputInvcMng view from BASIC Incoming VAT Invoice

Fields (59)

KeyField CDS FieldsUsed in Views
KEY CN_TaxInvcUUID CN_TaxInvcUUID 2
CN_BlueInvoiceNumber CN_BlueInvoiceNumber 1
CN_GoldenTaxSystemResultString CN_GoldenTaxSystemResultString 1
CN_GoldenTaxSystemRiskLevel CN_GoldenTaxSystemRiskLevel 1
CN_InvoiceLatestPostingDate CN_InvoiceLatestPostingDate 1
CN_InvoicePostingPeriod CN_InvoicePostingPeriod 1
CN_InvoicePostingType CN_InvoicePostingType 1
CN_InvoiceSpecificElement CN_InvoiceSpecificElement 1
CN_TaxDeclnMonth CN_TaxDeclnMonth 2
CN_TaxDeclnTime CN_TaxDeclnTime 2
CN_TaxDeclnYear CN_TaxDeclnYear 2
CN_TaxEntityID CN_TaxEntityID 2
CN_TaxInvcCode CN_TaxInvcCode 2
CN_TaxInvcComment CN_TaxInvcComment 2
CN_TaxInvcCrcy CN_TaxInvcCrcy 2
CN_TaxInvcDate CN_TaxInvcDate 2
CN_TaxInvcDeductAmtInInvcCrcy CN_TaxInvcDeductAmtInInvcCrcy 1
CN_TaxInvcDeductionType CN_TaxInvcDeductionType 2
CN_TaxInvcDiscNetAmtInInvcCrcy CN_TaxInvcDiscNetAmtInInvcCrcy 2
CN_TaxInvcDiscTaxAmtInInvcCrcy CN_TaxInvcDiscTaxAmtInInvcCrcy 2
CN_TaxInvcGldnTxSystSts CN_TaxInvcGldnTxSystSts 2
CN_TaxInvcGldnTxSystStsSyncTme CN_TaxInvcGldnTxSystStsSyncTme 2
CN_TaxInvcInptProcgSts CN_TaxInvcInptProcgSts 2
CN_TaxInvcIsElectronic CN_TaxInvcIsElectronic 2
CN_TaxInvcNetAmtInInvcCrcy CN_TaxInvcNetAmtInInvcCrcy 2
CN_TaxInvcNmbr CN_TaxInvcNmbr 2
CN_TaxInvcTaxAmtInInvcCrcy CN_TaxInvcTaxAmtInInvcCrcy 2
CN_TaxInvcType CN_TaxInvcType 2
CN_TaxInvcVehTotAmtInInvcCrcy CN_TaxInvcVehTotAmtInInvcCrcy 1
CN_TaxInvoiceDataSource CN_TaxInvoiceDataSource 1
CN_TaxInvoiceExpenseReportNmbr CN_TaxInvoiceExpenseReportNmbr 1
CN_TaxInvoiceUsage CN_TaxInvoiceUsage 1
CN_TaxInvoiceVehFactoryModel CN_TaxInvoiceVehFactoryModel 1
CN_TaxInvoiceVehicleCertNumber CN_TaxInvoiceVehicleCertNumber 1
CN_TaxInvoiceVehicleEngineNmbr CN_TaxInvoiceVehicleEngineNmbr 1
CN_TaxInvoiceVehicleInspNumber CN_TaxInvoiceVehicleInspNumber 1
CN_TaxInvoiceVehicleNumber CN_TaxInvoiceVehicleNumber 1
CN_TaxInvoiceVehicleProdnPlace CN_TaxInvoiceVehicleProdnPlace 1
CN_TaxInvoiceVehicleTonnage CN_TaxInvoiceVehicleTonnage 1
CN_TaxInvoiceVehicleType CN_TaxInvoiceVehicleType 1
CN_TaxInvoiceVehImportCertNmbr CN_TaxInvoiceVehImportCertNmbr 1
CN_TaxInvoiceVehPassengerLimit CN_TaxInvoiceVehPassengerLimit 1
CN_TaxInvoiceVehTxnRecordNmbr CN_TaxInvoiceVehTxnRecordNmbr 1
CN_TaxSellerName CN_TaxSellerName 2
CompanyCode CompanyCode 2
CreatedByUser CreatedByUser 2
CreationUTCDateTime CreationUTCDateTime 2
FiscalYear FiscalYear 2
IsDeleted IsDeleted 2
IsPostedOnAccount IsPostedOnAccount 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
Supplier Supplier 2
TaxCategory TaxCategory 2
TaxInvoiceDeclarationTypeCode TaxInvoiceDeclarationTypeCode 1
TaxInvoiceIsTaxRebate TaxInvoiceIsTaxRebate 1
TaxRate TaxRate 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CN_TAXINPUTINVC (
    CN_TAXINVCUUID,
    CN_BLUEINVOICENUMBER,
    CN_GOLDENTAXSYSTEMRESULTSTRING,
    CN_GOLDENTAXSYSTEMRISKLEVEL,
    CN_INVOICELATESTPOSTINGDATE,
    CN_INVOICEPOSTINGPERIOD,
    CN_INVOICEPOSTINGTYPE,
    CN_INVOICESPECIFICELEMENT,
    CN_TAXDECLNMONTH,
    CN_TAXDECLNTIME,
    CN_TAXDECLNYEAR,
    CN_TAXENTITYID,
    CN_TAXINVCCODE,
    CN_TAXINVCCOMMENT,
    CN_TAXINVCCRCY,
    CN_TAXINVCDATE,
    CN_TAXINVCDEDUCTAMTININVCCRCY,
    CN_TAXINVCDEDUCTIONTYPE,
    CN_TAXINVCDISCNETAMTININVCCRCY,
    CN_TAXINVCDISCTAXAMTININVCCRCY,
    CN_TAXINVCGLDNTXSYSTSTS,
    CN_TAXINVCGLDNTXSYSTSTSSYNCTME,
    CN_TAXINVCINPTPROCGSTS,
    CN_TAXINVCISELECTRONIC,
    CN_TAXINVCNETAMTININVCCRCY,
    CN_TAXINVCNMBR,
    CN_TAXINVCTAXAMTININVCCRCY,
    CN_TAXINVCTYPE,
    CN_TAXINVCVEHTOTAMTININVCCRCY,
    CN_TAXINVOICEDATASOURCE,
    CN_TAXINVOICEEXPENSEREPORTNMBR,
    CN_TAXINVOICEUSAGE,
    CN_TAXINVOICEVEHFACTORYMODEL,
    CN_TAXINVOICEVEHICLECERTNUMBER,
    CN_TAXINVOICEVEHICLEENGINENMBR,
    CN_TAXINVOICEVEHICLEINSPNUMBER,
    CN_TAXINVOICEVEHICLENUMBER,
    CN_TAXINVOICEVEHICLEPRODNPLACE,
    CN_TAXINVOICEVEHICLETONNAGE,
    CN_TAXINVOICEVEHICLETYPE,
    CN_TAXINVOICEVEHIMPORTCERTNMBR,
    CN_TAXINVOICEVEHPASSENGERLIMIT,
    CN_TAXINVOICEVEHTXNRECORDNMBR,
    CN_TAXSELLERNAME,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONUTCDATETIME,
    FISCALYEAR,
    ISDELETED,
    ISPOSTEDONACCOUNT,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    TAXCATEGORY,
    TAXINVOICEDECLARATIONTYPECODE,
    TAXINVOICEISTAXREBATE,
    TAXRATE,
    PRIMARY KEY (CN_TAXINVCUUID)
);