SAP ABAP Table BAPI_J_1BNFLIN (Transfer Structure: Nota Fiscal Line Items)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOC-BR (Application Component) Brazil
⤷ J1BA (Package) Localization Brazil
⤷ CRM-LOC-BR (Application Component) Brazil
⤷ J1BA (Package) Localization Brazil
Basic Data
Table Category | INTTAB | Structure |
Structure | BAPI_J_1BNFLIN | Table Relationship Diagram |
Short Description | Transfer Structure: Nota Fiscal Line Items |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | DOCNUM | J_1BDOCNUM | J_1BDOCNUM | NUMC | 10 | 0 | Document Number | * | |
3 | ITMNUM | J_1BITMNUM | J_1BITMNUM | NUMC | 6 | 0 | Document Item Number | ||
4 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
5 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
6 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
7 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
8 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
9 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
10 | DOCREF | J_1BDOCREF | J_1BDOCNUM | NUMC | 10 | 0 | Reference to NF | * | |
11 | ITMREF | J_1BITMREF | J_1BITMNUM | NUMC | 6 | 0 | Reference to item number (Return) | ||
12 | CFOP | J_1BCFOP_OLD | J_1BCFOP_OLD | CHAR | 5 | 0 | CFOP code and extension (old 5 char version) | * | |
13 | NBM | STEUC | STEUC | CHAR | 16 | 0 | Control code for consumption taxes in foreign trade | * | |
14 | MATORG | J_1BMATORG | J_1BMATORG | CHAR | 1 | 0 | Origin of the material | ||
15 | TAXSIT | J_1BTAXSIT | J_1BTAXSIT | CHAR | 1 | 0 | Tax situation ICMS | ||
16 | TAXSI2 | J_1BTAXSI2 | J_1BTAXSI2 | NUMC | 5 | 0 | Tax situation IPI | * | |
17 | OWNPRO | J_1BOWNPRO | XFELD | CHAR | 1 | 0 | Produced in-house | ||
18 | MATUSE | J_1BMATUSE | J_1BMATUSE | CHAR | 1 | 0 | Usage of the material | ||
19 | REFTYP | J_1BREFTYP | J_1BREFTYP | CHAR | 2 | 0 | Reference type | * | |
20 | REFKEY | J_1BREFKEY | J_1BREFKEY | CHAR | 35 | 0 | Reference to source document | ||
21 | REFITM | J_1BREFITM | J_1BREFITM | NUMC | 6 | 0 | Reference item to source document | ||
22 | MENGE | J_1BNETQTY | MENG13 | QUAN | 13 | 3 | Quantity | ||
23 | MEINS | J_1BNETUNT | MEINS | UNIT | 3 | 0 | Base unit of measure | * | |
24 | NETPR | J_1BNETPRI | J_1BNFPRI | DEC | 16 | 6 | Net price | ||
25 | NETWR | J_1BNETVAL | WERTV8 | CURR | 15 | 2 | Net Value | ||
26 | TAXLW1 | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | * | |
27 | TAXLW2 | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | * | |
28 | TMISS | J_1BTMISS | XFELD | CHAR | 1 | 0 | Service tax - no ICMS/IPI calculation | ||
29 | NETFRE | J_1BNETFRE | WERTV8 | CURR | 15 | 2 | Net freight value in document currency | ||
30 | NETINS | J_1BNETINS | WERTV8 | CURR | 15 | 2 | Net insurance value in document currency | ||
31 | NETOTH | J_1BNETOTH | WERTV8 | CURR | 15 | 2 | Net expenses in document currency | ||
32 | INDUS3 | J_1BINDUS3 | J_1BINDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
33 | ITMTYP | J_1BITMTYP | J_1BITMTYP | CHAR | 2 | 0 | Nota Fiscal Item Type | * | |
34 | NETDIS | J_1BNETDIS | WERTV8 | CURR | 15 | 2 | Net discount value in document currency | ||
35 | SPCSTO | J_1BSPCSTO | J_1BSPCSTO | CHAR | 2 | 0 | Nota Fiscal Special Case for CFOP Determination | ||
36 | INCLTX | J_1BINCLTX | XFELD | CHAR | 1 | 0 | Value and price including ICMS/ISS | ||
37 | STATIT | J_1BSTATIT | XFELD | CHAR | 1 | 0 | Indicator: Statistical item | ||
38 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
39 | CFOP_10 | J_1BCFOP | J_1BCFOP | CHAR | 10 | 0 | CFOP code and extension | * | |
40 | R_REFTYP | J_1BR_REFTYP | J_1BREFTYP | CHAR | 2 | 0 | Reference type for original document reference type | * | |
41 | R_REFKEY | J_1BR_REFKEY | J_1BREFKEY | CHAR | 35 | 0 | Reference to Source Document | ||
42 | R_AWSYS | J_1BR_LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System of Reference Document | * | |
43 | TAXLW3 | J_1BTAXLW3 | J_1BTAXLW3 | CHAR | 3 | 0 | Tax law: ISS | * | |
44 | MATNR_EXTERNAL | MGV_MATNR_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Material Number | ||
45 | MATNR_GUID | MGV_MATNR_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for MATNR Field | ||
46 | MATNR_VERSION | MGV_MATNR_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for MATNR Field | ||
47 | SRVNR | ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | * | |
48 | .INCLUDE | 0 | 0 | Taxlaws and situation for Pis, Cofins & ISS | |||||
49 | TAXSI3 | J_1BTAXSI3 | J_1BTAXSI3 | CHAR | 2 | 0 | Tax Situation ISS | * | |
50 | TAXLW4 | J_1BTAXLW4 | J_1BTAXLW4 | CHAR | 3 | 0 | COFINS Tax Law | J_1BATL4A | |
51 | TAXSI4 | J_1BTAXSI4 | J_1BTAXSI4 | CHAR | 2 | 0 | Tax Situation COFINS | * | |
52 | TAXLW5 | J_1BTAXLW5 | J_1BTAXLW5 | CHAR | 3 | 0 | PIS Tax Law | J_1BATL5 | |
53 | TAXSI5 | J_1BTAXSI5 | J_1BTAXSI5 | CHAR | 2 | 0 | Tax Situation PIS | * | |
54 | NBS | J_1BNBS | J_1BNBS | CHAR | 20 | 0 | Brazilian Nomenclature Services code | * | |
55 | XPED | J_1B_PURCH_ORDER_EXT | CHAR15 | CHAR | 15 | 0 | Purchase Order Number | ||
56 | NITEMPED | J_1B_PURCH_ORD_ITEM_EXT | CHAR6 | CHAR | 6 | 0 | Purchase Order Item | ||
57 | CLENQ | J_1B_IPI_CLASS_TBC_BEV | CHAR5 | CHAR | 5 | 0 | IPI Classification for Tobacco Products and Beverages | ||
58 | CSELO | J_1B_IPI_CONTR_SEAL_CODE | CHAR10 | CHAR | 10 | 0 | IPI Control Seal Code | ||
59 | QSELO | J_1B_IPI_CONTR_SEAL_QUAN | DEC12 | DEC | 12 | 0 | IPI Quantity of Control Seal | ||
60 | NUM_ITEM | J_1B_EXT_ITEM_NUM | NUMC3 | NUMC | 3 | 0 | External Item Number | ||
61 | COD_CTA | J_1B_GL_ACCOUNT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Revenue/Expenses | * | |
62 | VTOTTRIB | J_1BNF_VTOTTRIB | WERTV8 | CURR | 15 | 2 | Approximate Total Tax Amount | ||
63 | NFCI | J_1BNFE_NFCI | CHAR | 36 | 0 | FCI Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BAPI_J_1BNFLIN | TAXLW4 | J_1BATL4A | TAXLAW | KEY | 1 | CN |
2 | BAPI_J_1BNFLIN | TAXLW5 | J_1BATL5 | TAXLAW | KEY | 1 | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 470 |