I_CN_TAXINPUTINVC

CDS View
64 Fields 6 CDS Views

Incoming VAT Invoice

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

CDS Views using this table (6)

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

Fields (64)

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

-- 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_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