I_CN_TAXINPUTINVC

CDS View
65 Fields 7 CDS Views

Incoming VAT Invoice

I_CN_TAXINPUTINVC is a CDS View in S/4HANA. Incoming VAT Invoice. It contains 65 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_CN_TaxInputInvoice view from BASIC China Input Tax Invoice
C_CN_TaxDeductionItemCube view from CONSUMPTION Input VAT Deduction Item
C_CN_TaxInputInvc view from CONSUMPTION Incoming VAT Invoice
C_CN_TaxInputInvcBind view from CONSUMPTION China Tax Invoice for Binding
C_CN_TaxTransferItemCube view left_outer CONSUMPTION Input VAT Transfer Item Cube
I_CN_TaxInputInvcTP view_entity from TRANSACTIONAL Incoming VAT Invoice
I_CN_TaxInvoiceHeader view_entity from COMPOSITE China Tax Invoice Header

Fields (65)

KeyField CDS FieldsUsed in Views
KEY CN_TaxInvcUUID CN_TaxInvcUUID 7
CN_BlueInvoiceNumber CN_BlueInvoiceNumber 3
CN_GoldenTaxSystemResultString CN_GoldenTaxSystemResultString 3
CN_GoldenTaxSystemRiskLevel CN_GoldenTaxSystemRiskLevel 3
CN_InvoiceLatestPostingDate CN_InvoiceLatestPostingDate 3
CN_InvoicePostingPeriod CN_InvoicePostingPeriod 3
CN_InvoicePostingType CN_InvoicePostingType 3
CN_InvoiceSpecificElement CN_InvoiceSpecificElement 3
CN_TaxBuyerRegnNmbr CN_TaxBuyerRegnNmbr 3
CN_TaxDeclnMonth CN_TaxDeclnMonth 4
CN_TaxDeclnTime CN_TaxDeclnTime 2
CN_TaxDeclnYear CN_TaxDeclnYear 4
CN_TaxEntityID BusinessPlace,CN_TaxEntityID 4
CN_TaxInvcCode CN_TaxInvcCode 5
CN_TaxInvcComment CN_TaxInvcComment,CN_TaxInvoiceCommentText 5
CN_TaxInvcCrcy CN_TaxInvcCrcy 6
CN_TaxInvcDate CN_TaxInvcDate 5
CN_TaxInvcDeductAmtInInvcCrcy CN_TaxInvcDeductAmtInInvcCrcy 4
CN_TaxInvcDeductionType CN_TaxInvcDeductionType 4
CN_TaxInvcDiscNetAmtInInvcCrcy CN_TaxInvcDiscNetAmtInInvcCrcy 5
CN_TaxInvcDiscTaxAmtInInvcCrcy CN_TaxInvcDiscTaxAmtInInvcCrcy 5
CN_TaxInvcGldnTxSystSts CN_TaxInvcGldnTxSystSts 5
CN_TaxInvcGldnTxSystStsSyncTme CN_TaxInvcGldnTxSystStsSyncTme 4
CN_TaxInvcInptProcgSts CN_TaxInvcInptProcgSts 6
CN_TaxInvcIsElectronic CN_TaxInvcIsElectronic 3
CN_TaxInvcNetAmtInInvcCrcy CN_TaxInvcNetAmtInInvcCrcy,ZeroTaxBaseAmountInCoCodeCrcy 6
CN_TaxInvcNmbr CN_TaxInvcNmbr 5
CN_TaxInvcTaxAmtInInvcCrcy CN_TaxInvcTaxAmtInInvcCrcy,TaxAmount 6
CN_TaxInvcType CN_TaxInvcType 3
CN_TaxInvcVehTotAmtInInvcCrcy CN_TaxInvcVehTotAmtInInvcCrcy 3
CN_TaxInvoiceDataSource CN_TaxInvoiceDataSource 5
CN_TaxInvoiceExpenseReportNmbr CN_TaxInvoiceExpenseReportNmbr 4
CN_TaxInvoiceIssueDateTime CN_TaxInvoiceIssueDateTime 3
CN_TaxInvoiceUsage CN_TaxInvoiceUsage 4
CN_TaxInvoiceVehFactoryModel CN_TaxInvoiceVehFactoryModel 3
CN_TaxInvoiceVehicleCertNumber CN_TaxInvoiceVehicleCertNumber 3
CN_TaxInvoiceVehicleEngineNmbr CN_TaxInvoiceVehicleEngineNmbr 3
CN_TaxInvoiceVehicleInspNumber CN_TaxInvoiceVehicleInspNumber 3
CN_TaxInvoiceVehicleNumber CN_TaxInvoiceVehicleNumber 3
CN_TaxInvoiceVehicleProdnPlace CN_TaxInvoiceVehicleProdnPlace 3
CN_TaxInvoiceVehicleTonnage CN_TaxInvoiceVehicleTonnage 3
CN_TaxInvoiceVehicleType CN_TaxInvoiceVehicleType 3
CN_TaxInvoiceVehImportCertNmbr CN_TaxInvoiceVehImportCertNmbr 3
CN_TaxInvoiceVehPassengerLimit CN_TaxInvoiceVehPassengerLimit 3
CN_TaxInvoiceVehTxnRecordNmbr CN_TaxInvoiceVehTxnRecordNmbr 3
CN_TaxSellerName CN_TaxSellerName 5
CN_TaxSellerRegnNmbr CN_TaxSellerRegnNmbr 3
CompanyCode CompanyCode 3
CreatedByUser CreatedByUser 4
CreationUTCDateTime CreationUTCDateTime 3
FiscalYear FiscalYear 1
IsPostedOnAccount IsPostedOnAccount 4
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
PurchasingGroup PurchasingGroup 4
PurchasingOrganization PurchasingOrganization 4
Supplier Supplier 4
TaxCategory TaxCategory 3
TaxInvoiceBuyerAddressPhone TaxInvoiceBuyerAddressPhone 3
TaxInvoiceBuyerBankAccount TaxInvoiceBuyerBankAccount 3
TaxInvoiceDeclarationTypeCode TaxInvoiceDeclarationTypeCode 1
TaxInvoiceIsTaxRebate TaxInvoiceIsTaxRebate 1
TaxInvoiceSellerAddressPhone TaxInvoiceSellerAddressPhone 3
TaxInvoiceSellerBankAccount TaxInvoiceSellerBankAccount 3
TaxRate TaxRate 3

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.

-- Incoming VAT Invoice
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CN_TAXINPUTINVC (
    CN_TAXINVCUUID,
    CN_BLUEINVOICENUMBER,
    CN_GOLDENTAXSYSTEMRESULTSTRING,
    CN_GOLDENTAXSYSTEMRISKLEVEL,
    CN_INVOICELATESTPOSTINGDATE,
    CN_INVOICEPOSTINGPERIOD,
    CN_INVOICEPOSTINGTYPE,
    CN_INVOICESPECIFICELEMENT,
    CN_TAXBUYERREGNNMBR,
    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_TAXINVOICEISSUEDATETIME,
    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,
    CN_TAXSELLERREGNNMBR,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONUTCDATETIME,
    FISCALYEAR,
    ISPOSTEDONACCOUNT,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    TAXCATEGORY,
    TAXINVOICEBUYERADDRESSPHONE,
    TAXINVOICEBUYERBANKACCOUNT,
    TAXINVOICEDECLARATIONTYPECODE,
    TAXINVOICEISTAXREBATE,
    TAXINVOICESELLERADDRESSPHONE,
    TAXINVOICESELLERBANKACCOUNT,
    TAXRATE,
    PRIMARY KEY (CN_TAXINVCUUID)
);

Learn More