BILL_ACC_ITL_NFLIN SAP (Transfer Structure: Nota Fiscal Item) Structure details
Dictionary Type: Structure
Description: Transfer Structure: Nota Fiscal Item
Description: Transfer Structure: Nota Fiscal Item
ABAP Code to SELECT data from BILL_ACC_ITL_NFLIN
Related tables to BILL_ACC_ITL_NFLIN
Access table BILL_ACC_ITL_NFLIN
Related tables to BILL_ACC_ITL_NFLIN
Access table BILL_ACC_ITL_NFLIN
Structure field list including key, data, relationships and ABAP select examples
BILL_ACC_ITL_NFLIN is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Transfer Structure: Nota Fiscal Item" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_BILL_ACC_ITL_NFLIN TYPE BILL_ACC_ITL_NFLIN.
The BILL_ACC_ITL_NFLIN table consists of various fields, each holding specific information or linking keys about Transfer Structure: Nota Fiscal Item data available in SAP. These include BE_HEAD_NO (Header Number for BE Object (Transfer to Accounting)), CLIENT (Client), DOCNUM (Nota Fiscal Document Number), ITMNUM (Nota Fiscal Item Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BILL_ACC_ITL_NFLIN structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| BE_HEAD_NO | Header Number for BE Object (Transfer to Accounting) | ACC_BE_HEAD_NO | CHAR | 12 | ALPHA | ACC_BE_HEAD_NO | |||
| CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| DOCNUM | Nota Fiscal Document Number | ITL_NFDOCNUM | NUMC | 10 | NUMC10 | ||||
| ITMNUM | Nota Fiscal Item Number | ITL_NFITMNUM | NUMC | 6 | NUMC6 | ||||
| PRODUCT | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
| BWKEY | Valuation Area | BWKEY | CHAR | 4 | Assigned to domain | BWKEY | BWK | ||
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | BWTAR | BWT | |||
| CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
| MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
| MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
| DOCREF | Reference to NF | ITL_NF_DOCREF | NUMC | 10 | NUMC10 | ||||
| ITMREF | Reference to item number (Return) | ITL_NF_ITMREF | NUMC | 6 | NUMC6 | ||||
| CFOP_5 | CFOP Code and Extension (Length 5) | ITL_CFOP_5 | CHAR | 5 | ITL_CFOP_5 | ||||
| NCM | Tax Tariff Code | CRMT_TAX_TARIFF_CODE | CHAR | 16 | CHAR16 | ||||
| MATORG | Origin of the material | ITL_NF_MATORG | CHAR | 1 | ITL_NF_MATORG | ||||
| TAXSIT_ICMS | ICMS Taxability | ITL_TAXSIT1 | CHAR | 1 | TXSIT | ITL_TAXSIT1 | |||
| TAXSIT_IPI | IPI Tax situation | ITL_TAXSIT2 | NUMC | 5 | ITL_TAXSIT_IPI | ||||
| OWNPRO | Produced in-house | ITL_OWNPRO | CHAR | 1 | XFELD | ||||
| MATUSE | Material Usage | ITL_MAT_USAGE | CHAR | 1 | ITL_MAT_USAGE | ||||
| REFTYP | Reference type | ITL_REFTYP | CHAR | 2 | ITL_REFTYP | ||||
| REFKEY | Reference to source document | ITL_REFKEY | CHAR | 35 | ITL_REFKEY | ||||
| REFITM | Reference item to source document | ITL_REFITM | NUMC | 6 | ITL_REFITM | ||||
| MENGE | Quantity | ITL_NFNETQTY | QUAN | 13(3) | MENGE13 | ||||
| MEINS | Base Unit of Measure | ITL_BASE_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| NETPR | Net price | ITL_NET_PRICE | DEC | 16(6) | ITL_NET_PRICE | ||||
| NETWR | Net Value | ITL_NET_VALUE | CURR | 15(2) | ITL_AMOUNT | ||||
| TAXLAW_ICMS | ICMS Tax Law ID | ITL_TAXLAW1 | CHAR | 3 | Assigned to domain | ALPHA | ITL_TAXLAW1 | ||
| TAXLAW_IPI | IPI Tax Law ID | ITL_TAXLAW2 | CHAR | 3 | Assigned to domain | ALPHA | ITL_TAXLAW2 | ||
| TMISS | Service tax - no ICMS/IPI calculation | ITL_NF_TMISS | CHAR | 1 | XFELD | ||||
| NETFRE | Net freight value in document currency | ITL_NF_NETFRE | CURR | 15(2) | ITL_AMOUNT | ||||
| NETINS | Net insurance value in document currency | ITL_NF_NETINS | CURR | 15(2) | ITL_AMOUNT | ||||
| NETOTH | Net expenses in document currency | ITL_NF_NETOTH | CURR | 15(2) | ITL_AMOUNT | ||||
| INDUS3 | Material CFOP category | ITL_NF_INDUS3 | CHAR | 2 | ITL_NF_INDUS3 | ||||
| ITMTYP | Nota Fiscal Item Type | ITL_NFITMTYP | CHAR | 2 | Assigned to domain | ALPHA | ITL_NFITMTYP | ||
| NETDIS | Net discount value in document currency | ITL_NF_NETDIS | CURR | 15(2) | ITL_AMOUNT | ||||
| SPCSTO | Nota Fiscal Special Case for CFOP Determination | ITL_NF_SPCSTO | CHAR | 2 | ALPHA | ITL_NF_SPCSTO | |||
| INCLTX | Value and price including ICMS/ISS | ITL_NF_INCLTX | CHAR | 1 | XFELD | ||||
| STATIT | Indicator: Statistical Nota Fiscal Tax Item | ITL_STATTX | CHAR | 1 | XFELD | ||||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| CFOP | CFOP Code and Extension | ITL_CFOP | CHAR | 10 | Assigned to domain | CFOBR | ITL_CFOP | ||
| R_REFTYP | Reference type | ITL_REFTYP | CHAR | 2 | ITL_REFTYP | ||||
| R_REFKEY | Reference to source document | ITL_REFKEY | CHAR | 35 | ITL_REFKEY | ||||
| R_AWSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| DIRECT | Direction of Movement | ITL_NFDIRECT | CHAR | 1 | ITL_NFDIRECT | ||||
| DSTCAT | Destination category | ITL_NF_DSTCAT | CHAR | 1 | ITL_NF_DSTCAT | ||||
| INDUS2 | Business Place CFOP Category | ITL_NF_INDUS2 | CHAR | 2 | ALPHA | ITL_NF_INDUS2 | |||
| NFPRI | Net price | ITL_NET_PRICE | DEC | 16(6) | ITL_NET_PRICE | ||||
| NFNET | Net Value including taxes | ITL_NF_NET | CURR | 15(2) | ITL_AMOUNT | ||||
| NFDIS | Net discount value in document currency | ITL_NF_NETDIS | CURR | 15(2) | ITL_AMOUNT | ||||
| NFFRE | Freight value including taxes | ITL_NF_FRE | CURR | 15(2) | ITL_AMOUNT | ||||
| NFINS | Insurance value including taxes | ITL_NF_INS | CURR | 15(2) | ITL_AMOUNT | ||||
| NFOTH | Net expenses in document currency | ITL_NF_NETOTH | CURR | 15(2) | ITL_AMOUNT | ||||
| NETWRT | Net value/Freight/Insurance/Expenses/Discount | ITL_NF_NFNETT | CURR | 15(2) | ITL_AMOUNT | ||||
| NFNETT | Net value/Freight/Insurance/Expenses/Discount | ITL_NF_NFNETT | CURR | 15(2) | ITL_AMOUNT | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | Assigned to domain | KALSM | |||
| ICMSAVR | Average ICMS on Stock Transfers | ITL_NF_ICMSAVR | CURR | 15(2) | ITL_AMOUNT | ||||
| SUBTAVR | Average Substituição Tributária on Stock Transfers | ITL_NF_SUBTAVR | CURR | 15(2) | ITL_AMOUNT | ||||
| LPPNET | Last Purchase Price (Net) | ITL_NF_LPPNET | CURR | 15(2) | ITL_AMOUNT | ||||
| LPPBRT | Last Purchase Price (Gross) | ITL_NF_LPPBRT | CURR | 15(2) | ITL_AMOUNT | ||||
| ICMSVALP | ICMS on Last Purchase Price | ITL_NF_ICMSVALP | CURR | 15(2) | ITL_AMOUNT | ||||
| SUBTVALP | Substituição Tributária on Last Purchase Price | ITL_NF_SUBTVALP | CURR | 15(2) | ITL_AMOUNT |
| Key field | Non-key field |
How do I retrieve data from SAP structure BILL_ACC_ITL_NFLIN using ABAP code?
As BILL_ACC_ITL_NFLIN is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BILL_ACC_ITL_NFLIN as there is no data to select.How to access SAP table BILL_ACC_ITL_NFLIN
Within an ECC or HANA version of SAP you can also view further information about BILL_ACC_ITL_NFLIN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects