SAP ABAP Table BILL_ACC_ITL_NFLIN (Transfer Structure: Nota Fiscal Item)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOC-BR (Application Component) Brazil
⤷ BEA_BRAZIL (Package) CRM Billing International - Brazil Specific
⤷ CRM-LOC-BR (Application Component) Brazil
⤷ BEA_BRAZIL (Package) CRM Billing International - Brazil Specific
Basic Data
Table Category | INTTAB | Structure |
Structure | BILL_ACC_ITL_NFLIN | Table Relationship Diagram |
Short Description | Transfer Structure: Nota Fiscal Item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Billing Header Number | |||||
2 | BE_HEAD_NO | ACC_BE_HEAD_NO | ACC_BE_HEAD_NO | CHAR | 12 | 0 | Header Number for BE Object (Transfer to Accounting) | ||
3 | .INCLUDE | 0 | 0 | Data Part: Nota Fiscal Item Details | |||||
4 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | DOCNUM | ITL_NFDOCNUM | NUMC10 | NUMC | 10 | 0 | Nota Fiscal Document Number | ||
6 | ITMNUM | ITL_NFITMNUM | NUMC6 | NUMC | 6 | 0 | Nota Fiscal Item Number | ||
7 | PRODUCT | MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
8 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
9 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | ||
10 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | ||
11 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
12 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
13 | DOCREF | ITL_NF_DOCREF | NUMC10 | NUMC | 10 | 0 | Reference to NF | ||
14 | ITMREF | ITL_NF_ITMREF | NUMC6 | NUMC | 6 | 0 | Reference to item number (Return) | ||
15 | CFOP_5 | ITL_CFOP_5 | ITL_CFOP_5 | CHAR | 5 | 0 | CFOP Code and Extension (Length 5) | ||
16 | NCM | CRMT_TAX_TARIFF_CODE | CHAR16 | CHAR | 16 | 0 | Tax Tariff Code | ||
17 | MATORG | ITL_NF_MATORG | ITL_NF_MATORG | CHAR | 1 | 0 | Origin of the material | ||
18 | TAXSIT_ICMS | ITL_TAXSIT1 | ITL_TAXSIT1 | CHAR | 1 | 0 | ICMS Taxability | ||
19 | TAXSIT_IPI | ITL_TAXSIT2 | ITL_TAXSIT_IPI | NUMC | 5 | 0 | IPI Tax situation | ||
20 | OWNPRO | ITL_OWNPRO | XFELD | CHAR | 1 | 0 | Produced in-house | ||
21 | MATUSE | ITL_MAT_USAGE | ITL_MAT_USAGE | CHAR | 1 | 0 | Material Usage | ||
22 | REFTYP | ITL_REFTYP | ITL_REFTYP | CHAR | 2 | 0 | Reference type | ||
23 | REFKEY | ITL_REFKEY | ITL_REFKEY | CHAR | 35 | 0 | Reference to source document | ||
24 | REFITM | ITL_REFITM | ITL_REFITM | NUMC | 6 | 0 | Reference item to source document | ||
25 | MENGE | ITL_NFNETQTY | MENGE13 | QUAN | 13 | 3 | Quantity | ||
26 | MEINS | ITL_BASE_UOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
27 | NETPR | ITL_NET_PRICE | ITL_NET_PRICE | DEC | 16 | 6 | Net price | ||
28 | NETWR | ITL_NET_VALUE | ITL_AMOUNT | CURR | 15 | 2 | Net Value | ||
29 | TAXLAW_ICMS | ITL_TAXLAW1 | ITL_TAXLAW1 | CHAR | 3 | 0 | ICMS Tax Law ID | * | |
30 | TAXLAW_IPI | ITL_TAXLAW2 | ITL_TAXLAW2 | CHAR | 3 | 0 | IPI Tax Law ID | * | |
31 | TMISS | ITL_NF_TMISS | XFELD | CHAR | 1 | 0 | Service tax - no ICMS/IPI calculation | ||
32 | NETFRE | ITL_NF_NETFRE | ITL_AMOUNT | CURR | 15 | 2 | Net freight value in document currency | ||
33 | NETINS | ITL_NF_NETINS | ITL_AMOUNT | CURR | 15 | 2 | Net insurance value in document currency | ||
34 | NETOTH | ITL_NF_NETOTH | ITL_AMOUNT | CURR | 15 | 2 | Net expenses in document currency | ||
35 | INDUS3 | ITL_NF_INDUS3 | ITL_NF_INDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
36 | ITMTYP | ITL_NFITMTYP | ITL_NFITMTYP | CHAR | 2 | 0 | Nota Fiscal Item Type | * | |
37 | NETDIS | ITL_NF_NETDIS | ITL_AMOUNT | CURR | 15 | 2 | Net discount value in document currency | ||
38 | SPCSTO | ITL_NF_SPCSTO | ITL_NF_SPCSTO | CHAR | 2 | 0 | Nota Fiscal Special Case for CFOP Determination | ||
39 | INCLTX | ITL_NF_INCLTX | XFELD | CHAR | 1 | 0 | Value and price including ICMS/ISS | ||
40 | STATIT | ITL_STATTX | XFELD | CHAR | 1 | 0 | Indicator: Statistical Nota Fiscal Tax Item | ||
41 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
42 | CFOP | ITL_CFOP | ITL_CFOP | CHAR | 10 | 0 | CFOP Code and Extension | * | |
43 | R_REFTYP | ITL_REFTYP | ITL_REFTYP | CHAR | 2 | 0 | Reference type | ||
44 | R_REFKEY | ITL_REFKEY | ITL_REFKEY | CHAR | 35 | 0 | Reference to source document | ||
45 | R_AWSYS | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
46 | DIRECT | ITL_NFDIRECT | ITL_NFDIRECT | CHAR | 1 | 0 | Direction of Movement | ||
47 | DSTCAT | ITL_NF_DSTCAT | ITL_NF_DSTCAT | CHAR | 1 | 0 | Destination category | ||
48 | INDUS2 | ITL_NF_INDUS2 | ITL_NF_INDUS2 | CHAR | 2 | 0 | Business Place CFOP Category | ||
49 | NFPRI | ITL_NET_PRICE | ITL_NET_PRICE | DEC | 16 | 6 | Net price | ||
50 | NFNET | ITL_NF_NET | ITL_AMOUNT | CURR | 15 | 2 | Net Value including taxes | ||
51 | NFDIS | ITL_NF_NETDIS | ITL_AMOUNT | CURR | 15 | 2 | Net discount value in document currency | ||
52 | NFFRE | ITL_NF_FRE | ITL_AMOUNT | CURR | 15 | 2 | Freight value including taxes | ||
53 | NFINS | ITL_NF_INS | ITL_AMOUNT | CURR | 15 | 2 | Insurance value including taxes | ||
54 | NFOTH | ITL_NF_NETOTH | ITL_AMOUNT | CURR | 15 | 2 | Net expenses in document currency | ||
55 | NETWRT | ITL_NF_NFNETT | ITL_AMOUNT | CURR | 15 | 2 | Net value/Freight/Insurance/Expenses/Discount | ||
56 | NFNETT | ITL_NF_NFNETT | ITL_AMOUNT | CURR | 15 | 2 | Net value/Freight/Insurance/Expenses/Discount | ||
57 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
58 | KALSM | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | * | |
59 | ICMSAVR | ITL_NF_ICMSAVR | ITL_AMOUNT | CURR | 15 | 2 | Average ICMS on Stock Transfers | ||
60 | SUBTAVR | ITL_NF_SUBTAVR | ITL_AMOUNT | CURR | 15 | 2 | Average Substituição Tributária on Stock Transfers | ||
61 | LPPNET | ITL_NF_LPPNET | ITL_AMOUNT | CURR | 15 | 2 | Last Purchase Price (Net) | ||
62 | LPPBRT | ITL_NF_LPPBRT | ITL_AMOUNT | CURR | 15 | 2 | Last Purchase Price (Gross) | ||
63 | ICMSVALP | ITL_NF_ICMSVALP | ITL_AMOUNT | CURR | 15 | 2 | ICMS on Last Purchase Price | ||
64 | SUBTVALP | ITL_NF_SUBTVALP | ITL_AMOUNT | CURR | 15 | 2 | Substituição Tributária on Last Purchase Price |
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in | 400 |