SAP ABAP View V_NFLIN (Nota Fiscal Line Item)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ FI (Application Component) Financial Accounting
⤷ ID-BR-NF (Package) Brazilian Legal Reporting: Nota Fiscal
⤷ FI (Application Component) Financial Accounting
⤷ ID-BR-NF (Package) Brazilian Legal Reporting: Nota Fiscal
Basic Data
View Type | D | Database View |
Database View | V_NFLIN | |
Short Description | Nota Fiscal Line Item | |
Root table | J_1BNFDOC | Nota Fiscal Header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | J_1BNFDOC | J_1BNFDOC | ||
2 | J_1BNFLIN |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | J_1BNFDOC | MANDT | JL | EQ | 0 | 0 | ||||
2 | J_1BNFLIN | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | J_1BNFDOC | DOCNUM | JL | EQ | 0 | 0 | ||||
4 | J_1BNFLIN | DOCNUM | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | J_1BNFDOC | MANDT | MANDT | Client | |||
2 | PSTDAT | J_1BNFDOC | PSTDAT | J_1BPSTDAT | Posting date | |||
3 | BUKRS | J_1BNFDOC | BUKRS | BUKRS | Company Code | |||
4 | BRANCH | J_1BNFDOC | BRANCH | J_1BBRANC_ | Business Place | |||
5 | DOCNUM | J_1BNFLIN | DOCNUM | J_1BDOCNUM | Document Number | |||
6 | ITMNUM | J_1BNFLIN | ITMNUM | J_1BITMNUM | Document Item Number | |||
7 | MATNR | J_1BNFLIN | MATNR | MATNR | Material Number | |||
8 | BWKEY | J_1BNFLIN | BWKEY | BWKEY | Valuation area | |||
9 | BWTAR | J_1BNFLIN | BWTAR | BWTAR_D | Valuation type | |||
10 | CHARG | J_1BNFLIN | CHARG | CHARG_D | Batch Number | |||
11 | MATKL | J_1BNFLIN | MATKL | MATKL | Material Group | |||
12 | MAKTX | J_1BNFLIN | MAKTX | MAKTX | Material description | |||
13 | DOCREF | J_1BNFLIN | DOCREF | J_1BDOCREF | Reference to NF | |||
14 | ITMREF | J_1BNFLIN | ITMREF | J_1BITMREF | Reference to item number (Return) | |||
15 | CFOP | J_1BNFLIN | CFOP | J_1BCFOP | CFOP code and extension | |||
16 | NBM | J_1BNFLIN | NBM | STEUC | Control code for consumption taxes in foreign trade | |||
17 | MATORG | J_1BNFLIN | MATORG | J_1BMATORG | Origin of the material | |||
18 | TAXSIT | J_1BNFLIN | TAXSIT | J_1BTAXSIT | Tax situation ICMS | |||
19 | TAXSI2 | J_1BNFLIN | TAXSI2 | J_1BTAXSI2 | Tax situation IPI | |||
20 | OWNPRO | J_1BNFLIN | OWNPRO | J_1BOWNPRO | Produced in-house | |||
21 | MATUSE | J_1BNFLIN | MATUSE | J_1BMATUSE | Usage of the material | |||
22 | REFTYP | J_1BNFLIN | REFTYP | J_1BREFTYP | Reference type | |||
23 | REFKEY | J_1BNFLIN | REFKEY | J_1BREFKEY | Reference to source document | |||
24 | REFITM | J_1BNFLIN | REFITM | J_1BREFITM | Reference item to source document | |||
25 | MENGE | J_1BNFLIN | MENGE | J_1BNETQTY | Quantity | |||
26 | MEINS | J_1BNFLIN | MEINS | J_1BNETUNT | Base unit of measure | |||
27 | NETPR | J_1BNFLIN | NETPR | J_1BNETPRI | Net price | |||
28 | NETWR | J_1BNFLIN | NETWR | J_1BNETVAL | Net Value | |||
29 | TAXLW1 | J_1BNFLIN | TAXLW1 | J_1BTAXLW1 | Tax law: ICMS | |||
30 | TAXLW2 | J_1BNFLIN | TAXLW2 | J_1BTAXLW2 | Tax law: IPI | |||
31 | TMISS | J_1BNFLIN | TMISS | J_1BTMISS | Service tax - no ICMS/IPI calculation | |||
32 | NETFRE | J_1BNFLIN | NETFRE | J_1BNETFRE | Net freight value in document currency | |||
33 | NETINS | J_1BNFLIN | NETINS | J_1BNETINS | Net insurance value in document currency | |||
34 | NETOTH | J_1BNFLIN | NETOTH | J_1BNETOTH | Net expenses in document currency | |||
35 | INDUS3 | J_1BNFLIN | INDUS3 | J_1BINDUS3 | Material CFOP category | |||
36 | ITMTYP | J_1BNFLIN | ITMTYP | J_1BITMTYP | Nota Fiscal Item Type | |||
37 | NETDIS | J_1BNFLIN | NETDIS | J_1BNETDIS | Net discount value in document currency | |||
38 | SPCSTO | J_1BNFLIN | SPCSTO | J_1BSPCSTO | Nota Fiscal Special Case for CFOP Determination | |||
39 | INCLTX | J_1BNFLIN | INCLTX | J_1BINCLTX | Value and price including ICMS/ISS | |||
40 | STATIT | J_1BNFLIN | STATIT | J_1BSTATIT | Indicator: Statistical item | |||
41 | WERKS | J_1BNFLIN | WERKS | WERKS_D | Plant | |||
42 | WAERK | J_1BNFDOC | WAERK | WAERK | SD document currency | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |