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
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | BAPI_J_1BNFLIN |
|
| 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 | CLNT | 3 | 0 | Client | * | |
| 2 | |
J_1BDOCNUM | J_1BDOCNUM | NUMC | 10 | 0 | Document Number | * | |
| 3 | |
J_1BITMNUM | J_1BITMNUM | NUMC | 6 | 0 | Document Item Number | ||
| 4 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
| 5 | |
BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
| 6 | |
BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
| 7 | |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
| 8 | |
MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
| 9 | |
MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
| 10 | |
J_1BDOCREF | J_1BDOCNUM | NUMC | 10 | 0 | Reference to NF | * | |
| 11 | |
J_1BITMREF | J_1BITMNUM | NUMC | 6 | 0 | Reference to item number (Return) | ||
| 12 | |
J_1BCFOP_OLD | J_1BCFOP_OLD | CHAR | 5 | 0 | CFOP code and extension (old 5 char version) | * | |
| 13 | |
STEUC | STEUC | CHAR | 16 | 0 | Control code for consumption taxes in foreign trade | * | |
| 14 | |
J_1BMATORG | J_1BMATORG | CHAR | 1 | 0 | Origin of the material | ||
| 15 | |
J_1BTAXSIT | J_1BTAXSIT | CHAR | 1 | 0 | Tax situation ICMS | ||
| 16 | |
J_1BTAXSI2 | J_1BTAXSI2 | NUMC | 5 | 0 | Tax situation IPI | * | |
| 17 | |
J_1BOWNPRO | XFELD | CHAR | 1 | 0 | Produced in-house | ||
| 18 | |
J_1BMATUSE | J_1BMATUSE | CHAR | 1 | 0 | Usage of the material | ||
| 19 | |
J_1BREFTYP | J_1BREFTYP | CHAR | 2 | 0 | Reference type | * | |
| 20 | |
J_1BREFKEY | J_1BREFKEY | CHAR | 35 | 0 | Reference to source document | ||
| 21 | |
J_1BREFITM | J_1BREFITM | NUMC | 6 | 0 | Reference item to source document | ||
| 22 | |
J_1BNETQTY | MENG13 | QUAN | 13 | 3 | Quantity | ||
| 23 | |
J_1BNETUNT | MEINS | UNIT | 3 | 0 | Base unit of measure | * | |
| 24 | |
J_1BNETPRI | J_1BNFPRI | DEC | 16 | 6 | Net price | ||
| 25 | |
J_1BNETVAL | WERTV8 | CURR | 15 | 2 | Net Value | ||
| 26 | |
J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | * | |
| 27 | |
J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | * | |
| 28 | |
J_1BTMISS | XFELD | CHAR | 1 | 0 | Service tax - no ICMS/IPI calculation | ||
| 29 | |
J_1BNETFRE | WERTV8 | CURR | 15 | 2 | Net freight value in document currency | ||
| 30 | |
J_1BNETINS | WERTV8 | CURR | 15 | 2 | Net insurance value in document currency | ||
| 31 | |
J_1BNETOTH | WERTV8 | CURR | 15 | 2 | Net expenses in document currency | ||
| 32 | |
J_1BINDUS3 | J_1BINDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
| 33 | |
J_1BITMTYP | J_1BITMTYP | CHAR | 2 | 0 | Nota Fiscal Item Type | * | |
| 34 | |
J_1BNETDIS | WERTV8 | CURR | 15 | 2 | Net discount value in document currency | ||
| 35 | |
J_1BSPCSTO | J_1BSPCSTO | CHAR | 2 | 0 | Nota Fiscal Special Case for CFOP Determination | ||
| 36 | |
J_1BINCLTX | XFELD | CHAR | 1 | 0 | Value and price including ICMS/ISS | ||
| 37 | |
J_1BSTATIT | XFELD | CHAR | 1 | 0 | Indicator: Statistical item | ||
| 38 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
| 39 | |
J_1BCFOP | J_1BCFOP | CHAR | 10 | 0 | CFOP code and extension | * | |
| 40 | |
J_1BR_REFTYP | J_1BREFTYP | CHAR | 2 | 0 | Reference type for original document reference type | * | |
| 41 | |
J_1BR_REFKEY | J_1BREFKEY | CHAR | 35 | 0 | Reference to Source Document | ||
| 42 | |
J_1BR_LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System of Reference Document | * | |
| 43 | |
J_1BTAXLW3 | J_1BTAXLW3 | CHAR | 3 | 0 | Tax law: ISS | * | |
| 44 | |
MGV_MATNR_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Material Number | ||
| 45 | |
MGV_MATNR_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for MATNR Field | ||
| 46 | |
MGV_MATNR_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for MATNR Field | ||
| 47 | |
ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | * | |
| 48 | |
0 | 0 | Taxlaws and situation for Pis, Cofins & ISS | |||||
| 49 | |
J_1BTAXSI3 | J_1BTAXSI3 | CHAR | 2 | 0 | Tax Situation ISS | * | |
| 50 | |
J_1BTAXLW4 | J_1BTAXLW4 | CHAR | 3 | 0 | COFINS Tax Law | J_1BATL4A | |
| 51 | |
J_1BTAXSI4 | J_1BTAXSI4 | CHAR | 2 | 0 | Tax Situation COFINS | * | |
| 52 | |
J_1BTAXLW5 | J_1BTAXLW5 | CHAR | 3 | 0 | PIS Tax Law | J_1BATL5 | |
| 53 | |
J_1BTAXSI5 | J_1BTAXSI5 | CHAR | 2 | 0 | Tax Situation PIS | * | |
| 54 | |
J_1BNBS | J_1BNBS | CHAR | 20 | 0 | Brazilian Nomenclature Services code | * | |
| 55 | |
J_1B_PURCH_ORDER_EXT | CHAR15 | CHAR | 15 | 0 | Purchase Order Number | ||
| 56 | |
J_1B_PURCH_ORD_ITEM_EXT | CHAR6 | CHAR | 6 | 0 | Purchase Order Item | ||
| 57 | |
J_1B_IPI_CLASS_TBC_BEV | CHAR5 | CHAR | 5 | 0 | IPI Classification for Tobacco Products and Beverages | ||
| 58 | |
J_1B_IPI_CONTR_SEAL_CODE | CHAR10 | CHAR | 10 | 0 | IPI Control Seal Code | ||
| 59 | |
J_1B_IPI_CONTR_SEAL_QUAN | DEC12 | DEC | 12 | 0 | IPI Quantity of Control Seal | ||
| 60 | |
J_1B_EXT_ITEM_NUM | NUMC3 | NUMC | 3 | 0 | External Item Number | ||
| 61 | |
J_1B_GL_ACCOUNT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Revenue/Expenses | * | |
| 62 | |
J_1BNF_VTOTTRIB | WERTV8 | CURR | 15 | 2 | Approximate Total Tax Amount | ||
| 63 | |
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 | |
|
KEY | 1 | CN |
| 2 | BAPI_J_1BNFLIN | TAXLW5 | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 470 |