I_CN_TAXINPUTINVOICEITEM

CDS View
19 Fields 2 CDS Views

Incoming VAT Invoice Item

I_CN_TAXINPUTINVOICEITEM is a CDS View in S/4HANA. Incoming VAT Invoice Item. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CN_TaxInputInvoiceItem view from BASIC China Input Tax Invoice Item
I_CN_TaxInputInvoiceItemTP view_entity from TRANSACTIONAL Incoming VAT Invoice Item

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CN_TaxInvcUUID CN_TaxInvcUUID 2
KEY TaxInvoiceItemUUID TaxInvoiceItemUUID 2
CN_TaxInvcCode CN_TaxInvcCode 2
CN_TaxInvcNmbr CN_TaxInvcNmbr 2
TaxInvoiceItem TaxInvoiceItem 2
TaxInvoiceItemGoodsNumber TaxInvoiceItemGoodsNumber 2
TaxInvoiceItemGoodsServiceName TaxInvoiceItemGoodsServiceName 2
TaxInvoiceItemNetAmount TaxInvoiceItemNetAmount 2
TaxInvoiceItemNetUnitPrice TaxInvoiceItemNetUnitPrice 2
TaxInvoiceItemQuantity TaxInvoiceItemQuantity 2
TaxInvoiceItemSpecModel TaxInvoiceItemSpecModel 2
TaxInvoiceItemTaxAmount TaxInvoiceItemTaxAmount 2
TaxInvoiceItemTaxRate TaxInvoiceItemTaxRate 2
TaxInvoiceItemTollCarCategory TaxInvoiceItemTollCarCategory 2
TaxInvoiceItemTollCarLicPlate TaxInvoiceItemTollCarLicPlate 2
TaxInvoiceItemTollEndDateTime TaxInvoiceItemTollEndDateTime 2
TaxInvoiceItemTollStrtDateTime TaxInvoiceItemTollStrtDateTime 2
TaxInvoiceItemUnitDescription TaxInvoiceItemUnitDescription 2
UnitOfMeasure UnitOfMeasure 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 Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CN_TAXINPUTINVOICEITEM (
    CN_TAXINVCUUID,
    TAXINVOICEITEMUUID,
    CN_TAXINVCCODE,
    CN_TAXINVCNMBR,
    TAXINVOICEITEM,
    TAXINVOICEITEMGOODSNUMBER,
    TAXINVOICEITEMGOODSSERVICENAME,
    TAXINVOICEITEMNETAMOUNT,
    TAXINVOICEITEMNETUNITPRICE,
    TAXINVOICEITEMQUANTITY,
    TAXINVOICEITEMSPECMODEL,
    TAXINVOICEITEMTAXAMOUNT,
    TAXINVOICEITEMTAXRATE,
    TAXINVOICEITEMTOLLCARCATEGORY,
    TAXINVOICEITEMTOLLCARLICPLATE,
    TAXINVOICEITEMTOLLENDDATETIME,
    TAXINVOICEITEMTOLLSTRTDATETIME,
    TAXINVOICEITEMUNITDESCRIPTION,
    UNITOFMEASURE,
    PRIMARY KEY (CN_TAXINVCUUID, TAXINVOICEITEMUUID)
);

Learn More