SAP ABAP Table IDNFBRJ_1BNFLIN (Change Document Structure; Generated by RSSCD000)
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 | IDNFBRJ_1BNFLIN | Table Relationship Diagram |
Short Description | Change Document Structure; Generated by RSSCD000 |
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 | Nota Fiscal line items | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | DOCNUM | J_1BDOCNUM | J_1BDOCNUM | NUMC | 10 | 0 | Document Number | J_1BNFDOC | |
4 | ITMNUM | J_1BITMNUM | J_1BITMNUM | NUMC | 6 | 0 | Document Item Number | ||
5 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
6 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | T001K | |
7 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | MBEW | |
8 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
9 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
10 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
11 | DOCREF | J_1BDOCREF | J_1BDOCNUM | NUMC | 10 | 0 | Reference to NF | J_1BNFDOC | |
12 | ITMREF | J_1BITMREF | J_1BITMNUM | NUMC | 6 | 0 | Reference to item number (Return) | ||
13 | CFOP | J_1BCFOP | J_1BCFOP | CHAR | 10 | 0 | CFOP code and extension | J_1BAG | |
14 | NBM | STEUC | STEUC | CHAR | 16 | 0 | Control code for consumption taxes in foreign trade | T604F | |
15 | MATORG | J_1BMATORG | J_1BMATORG | CHAR | 1 | 0 | Origin of the material | ||
16 | TAXSIT | J_1BTAXSIT | J_1BTAXSIT | CHAR | 1 | 0 | Tax situation ICMS | ||
17 | TAXSI2 | J_1BTAXSI2 | J_1BTAXSI2 | NUMC | 5 | 0 | Tax situation IPI | J_1BAS | |
18 | OWNPRO | J_1BOWNPRO | XFELD | CHAR | 1 | 0 | Produced in-house | ||
19 | MATUSE | J_1BMATUSE | J_1BMATUSE | CHAR | 1 | 0 | Usage of the material | ||
20 | REFTYP | J_1BREFTYP | J_1BREFTYP | CHAR | 2 | 0 | Reference type | J_1BAB | |
21 | REFKEY | J_1BREFKEY | J_1BREFKEY | CHAR | 35 | 0 | Reference to source document | ||
22 | REFITM | J_1BREFITM | J_1BREFITM | NUMC | 6 | 0 | Reference item to source document | ||
23 | MENGE | J_1BNETQTY | MENG13 | QUAN | 13 | 3 | Quantity | ||
24 | MEINS | J_1BNETUNT | MEINS | UNIT | 3 | 0 | Base unit of measure | T006 | |
25 | NETPR | J_1BNETPRI | J_1BNFPRI | DEC | 16 | 6 | Net price | ||
26 | NETWR | J_1BNETVAL | WERTV8 | CURR | 15 | 2 | Net Value | ||
27 | TAXLW1 | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | J_1BATL1 | |
28 | TAXLW2 | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | J_1BATL2 | |
29 | TMISS | J_1BTMISS | XFELD | CHAR | 1 | 0 | Service tax - no ICMS/IPI calculation | ||
30 | NETFRE | J_1BNETFRE | WERTV8 | CURR | 15 | 2 | Net freight value in document currency | ||
31 | NETINS | J_1BNETINS | WERTV8 | CURR | 15 | 2 | Net insurance value in document currency | ||
32 | NETOTH | J_1BNETOTH | WERTV8 | CURR | 15 | 2 | Net expenses in document currency | ||
33 | INDUS3 | J_1BINDUS3 | J_1BINDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
34 | ITMTYP | J_1BITMTYP | J_1BITMTYP | CHAR | 2 | 0 | Nota Fiscal Item Type | J_1BITEMTYPES | |
35 | NETDIS | J_1BNETDIS | WERTV8 | CURR | 15 | 2 | Net discount value in document currency | ||
36 | SPCSTO | J_1BSPCSTO | J_1BSPCSTO | CHAR | 2 | 0 | Nota Fiscal Special Case for CFOP Determination | ||
37 | INCLTX | J_1BINCLTX | XFELD | CHAR | 1 | 0 | Value and price including ICMS/ISS | ||
38 | STATIT | J_1BSTATIT | XFELD | CHAR | 1 | 0 | Indicator: Statistical item | ||
39 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
40 | DIRECT | J_1BDIRECT | J_1BDIRECT | CHAR | 1 | 0 | Direction of the movement | ||
41 | DSTCAT | J_1BDSTCAT | J_1BDSTCAT | CHAR | 1 | 0 | Destination category | ||
42 | INDUS2 | J_1BINDUS2 | J_1BINDUS2 | CHAR | 2 | 0 | Business Place CFOP Category | ||
43 | NFPRI | J_1BNFPRI | J_1BNFPRI | DEC | 16 | 6 | Net Price Including Tax | ||
44 | NFNET | J_1BNFNET | WERTV8 | CURR | 15 | 2 | Net Value including taxes | ||
45 | NFDIS | J_1BNFDIS | WERTV8 | CURR | 15 | 2 | Discount value including taxes | ||
46 | NFFRE | J_1BNFFRE | WERTV8 | CURR | 15 | 2 | Freight value including taxes | ||
47 | NFINS | J_1BNFINS | WERTV8 | CURR | 15 | 2 | Insurance value including taxes | ||
48 | NFOTH | J_1BNFOTH | WERTV8 | CURR | 15 | 2 | Expenses including taxes | ||
49 | NETWRT | J_1BNFNETT | WERTV8 | CURR | 15 | 2 | Net value/Freight/Insurance/Expenses/Discount | ||
50 | NFNETT | J_1BNFNETT | WERTV8 | CURR | 15 | 2 | Net value/Freight/Insurance/Expenses/Discount | ||
51 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
52 | KALSM | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | * | |
53 | ICMSAVR | J_1BICMSAVR | J_1BTAXVAL | CURR | 15 | 2 | Average ICMS on Stock Transfers | ||
54 | SUBTAVR | J_1BSUBTAVR | J_1BTAXVAL | CURR | 15 | 2 | Average Substituição Tributária on Stock Transfers | ||
55 | LPPNET | J_1BLPPNET | WERTV8 | CURR | 15 | 2 | Last Purchase Price (Net) | ||
56 | LPPBRT | J_1BLPPBRT | WERTV8 | CURR | 15 | 2 | Last Purchase Price (Gross) | ||
57 | ICMSVALP | J_1BICMSVAL | J_1BTAXVAL | CURR | 15 | 2 | ICMS on Last Purchase Price | ||
58 | SUBTVALP | J_1BSUBTVAL | J_1BTAXVAL | CURR | 15 | 2 | Substituição Tributária on Last Purchase Price | ||
59 | TAXLW3 | J_1BTAXLW3 | J_1BTAXLW3 | CHAR | 3 | 0 | Tax law: ISS | J_1BATL3 | |
60 | SRVNR | ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | ASMD | |
61 | .INCLUDE | 0 | 0 | Taxlaws and situation for Pis, Cofins & ISS | |||||
62 | TAXSI3 | J_1BTAXSI3 | J_1BTAXSI3 | CHAR | 2 | 0 | Tax Situation ISS | * | |
63 | TAXLW4 | J_1BTAXLW4 | J_1BTAXLW4 | CHAR | 3 | 0 | COFINS Tax Law | J_1BATL4A | |
64 | TAXSI4 | J_1BTAXSI4 | J_1BTAXSI4 | CHAR | 2 | 0 | Tax Situation COFINS | * | |
65 | TAXLW5 | J_1BTAXLW5 | J_1BTAXLW5 | CHAR | 3 | 0 | PIS Tax Law | J_1BATL5 | |
66 | TAXSI5 | J_1BTAXSI5 | J_1BTAXSI5 | CHAR | 2 | 0 | Tax Situation PIS | * | |
67 | REFTYP_PREV | J_1BREFTYP_PREV | J_1BREFTYP | CHAR | 2 | 0 | Previously linked NF-e - type of source document | * | |
68 | REFKEY_PREV | J_1BREFKEY_PREV | J_1BREFKEY | CHAR | 35 | 0 | Previously linked NF-e - key of source document | ||
69 | REFITM_PREV | J_1BREFITM_PREV | J_1BREFITM | NUMC | 6 | 0 | Previously linked NF-e - item of source document | ||
70 | NBS | J_1BNBS | J_1BNBS | CHAR | 20 | 0 | Brazilian Nomenclature Services code | * | |
71 | .INCLUDE | 0 | 0 | Nota Fiscal Item Additional Fields | |||||
72 | CEAN | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
73 | XPED | J_1B_PURCH_ORDER_EXT | CHAR15 | CHAR | 15 | 0 | Purchase Order Number | ||
74 | NITEMPED | J_1B_PURCH_ORD_ITEM_EXT | CHAR6 | CHAR | 6 | 0 | Purchase Order Item | ||
75 | MODBC | J_1B_ICMS_BASE_DET | J_1B_ICMS_BASE_DET | CHAR | 1 | 0 | ICMS Tax Base Determination Modality | ||
76 | MODBCST | J_1B_ICST_BASE_DET | J_1B_ICST_BASE_DET | CHAR | 1 | 0 | ICMS Sub Trib Tax Base Determination Modality | ||
77 | MOTDESICMS | J_1B_ICMS_EXEM_REASON | J_1B_ICMS_EXEM_REASON | CHAR | 1 | 0 | ICMS Exemption Reason | ||
78 | CLENQ | J_1B_IPI_CLASS_TBC_BEV | CHAR5 | CHAR | 5 | 0 | IPI Classification for Tobacco Products and Beverages | ||
79 | CSELO | J_1B_IPI_CONTR_SEAL_CODE | CHAR10 | CHAR | 10 | 0 | IPI Control Seal Code | ||
80 | QSELO | J_1B_IPI_CONTR_SEAL_QUAN | DEC12 | DEC | 12 | 0 | IPI Quantity of Control Seal | ||
81 | CENQ | J_1B_IPI_LEGAL_CLASS_CODE | CHAR3 | CHAR | 3 | 0 | IPI Legal Classification Code | ||
82 | NUM_ITEM | J_1B_EXT_ITEM_NUM | NUMC3 | NUMC | 3 | 0 | External Item Number | ||
83 | IND_MOV | J_1B_PHYS_MOVE_MAT | J_1B_PHYS_MOVE_MAT | CHAR | 1 | 0 | Physical Movement of Materials | ||
84 | COD_CTA | J_1B_GL_ACCOUNT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Revenue/Expenses | * | |
85 | VTOTTRIB | J_1BNF_VTOTTRIB | WERTV8 | CURR | 15 | 2 | Approximate Total Tax Amount | ||
86 | NFCI | J_1BNFE_NFCI | CHAR | 36 | 0 | FCI Number | |||
87 | .INCLUDE | 0 | 0 | Nota fiscal writer cost information of posting | |||||
88 | KOSTL | J_1BKOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
89 | AUFNR | J_1BAUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
90 | PRCTR | J_1BPRCTR | PRCTR | CHAR | 10 | 0 | Profit Centers | * | |
91 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
92 | KSTRG | J_1BKSTRG | KSTRG | CHAR | 12 | 0 | Cost Objects | * | |
93 | NPLNR | J_1BNPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
94 | SEGMENT | FB_SEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | * | |
95 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
96 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |