SAP ABAP Table ROIILFA1 (Transfer structure for Vendor Data for BDRP object maint.)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-BDR (Application Component) Bulk Distribution Requirements Planning
     ⤷ OII (Package) BDRP Bulk Distribution Requirement Planning
Basic Data
Table Category INTTAB    Structure 
Structure ROIILFA1   Table Relationship Diagram
Short Description Transfer structure for Vendor Data for BDRP object maint.    
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   Vendor Master (General Section)  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
4 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key T005
5 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
6 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
7 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
8 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
9 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
10 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
11 PFACH PFACH PFACH CHAR 10   0   PO Box  
12 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
13 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
14 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
15 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
16 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
17 ADRNR ADRNR ADRNR CHAR 10   0   Address *
18 MCOD1 MCDK1 CHAR25 CHAR 25   0   Search term for matchcode search  
19 MCOD2 MCDK2 CHAR25 CHAR 25   0   Search term for matchcode search  
20 MCOD3 MCDK3 CHAR25 CHAR 25   0   Search term for matchcode search  
21 .INCLUDE       0   0   Vendor Master (General Section)  
22 ANRED ANRED TEXT15 CHAR 15   0   Title  
23 BAHNS BAHNS BAHNH CHAR 25   0   Train station  
24 BBBNR BBBNR NUM07 NUMC 7   0   International location number (part 1)  
25 BBSNR BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
26 BEGRU BRGRU BRGRU CHAR 4   0   Authorization Group *
27 BRSCH BRSCH BRSCH CHAR 4   0   Industry key T016
28 BUBKZ BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
29 DATLT DATLT TEXT14 CHAR 14   0   Data communication line no.  
30 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
31 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
32 ERDAT ERDAT_RF DATUM DATS 8   0   Date on which the Record Was Created  
33 ERNAM ERNAM_RF USNAM CHAR 12   0   Name of Person who Created the Object  
34 ESRNR ESRNR ESRNR CHAR 11   0   POR subscriber number  
35 KONZS KONZS KONZS CHAR 10   0   Group key  
36 KTOKK KTOKK KTOKK CHAR 4   0   Vendor account group T077K
37 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
38 LNRZA LNRZA LIFNR CHAR 10   0   Account Number of the Alternative Payee LFA1
39 LOEVM LOEVM_X XFELD CHAR 1   0   Central Deletion Flag for Master Record  
40 SPERR SPERB_X XFELD CHAR 1   0   Central posting block  
41 SPERM SPERM_X XFELD CHAR 1   0   Centrally imposed purchasing block  
42 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
43 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
44 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
45 STKZA STKZA STKZA CHAR 1   0   Indicator: Business Partner Subject to Equalization Tax?  
46 STKZU STKZU XFELD CHAR 1   0   Liable for VAT  
47 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
48 TELF1 TELF1 TEXT16 CHAR 16   0   First telephone number  
49 TELF2 TELF2 TEXT16 CHAR 16   0   Second telephone number  
50 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
51 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
52 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
53 XCPDK XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
54 XZEMP XZEMP XFELD CHAR 1   0   Indicator: Alternative payee in document allowed ?  
55 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
56 FISKN FISKN_K LIFNR CHAR 10   0   Account number of the master record with fiscal address LFA1
57 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
58 STKZN STKZN STKZN CHAR 1   0   Natural Person  
59 SPERQ QSPERRFKT QSPERRFKT CHAR 2   0   Function That Will Be Blocked TQ04A
60 GBORT GBORT_Q TEXT25 CHAR 25   0   Place of birth of the person subject to withholding tax  
61 GBDAT GBDAT_Q DATUM DATS 8   0   Date of birth of the person subject to withholding tax  
62 SEXKZ SEXKZ SEXKZ CHAR 1   0   Key for the Sex of the Person Subject to Withholding Tax  
63 KRAUS KRAUS_CM CHAR11 CHAR 11   0   Credit information number  
64 REVDB REVDB_CM DATUM DATS 8   0   Last review (external)  
65 QSSYS QSSYS_IST QSSYSFAM CHAR 4   0   Vendor's QM system TQ02B
66 KTOCK KTOCK KTOKK CHAR 4   0   Reference Account Group for One-Time Account (Vendor) T077K
67 PFORT PFORT_GP TEXT35 CHAR 35   0   PO Box city  
68 WERKS WERKS_EXT WERKS CHAR 4   0   Plant (Own or External) *
69 LTSNA LTSNA XFELD CHAR 1   0   Indicator: vendor sub-range relevant  
70 WERKR WERKR XFELD CHAR 1   0   Indicator: plant level relevant  
71 PLKAL FABKL WFCID CHAR 2   0   Factory calendar key TFACD
72 DUEFL DUEFL_BKPF DUEFL_BKPF CHAR 1   0   Status of Data Transfer into Subsequent Release  
73 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
74 SPERZ SPERZ XFELD CHAR 1   0   Payment Block  
75 SCACD SCACD SCACD CHAR 4   0   Standard carrier access code  
76 SFRGR SFRGR SFRGR CHAR 4   0   Forwarding Agent Freight Group TSFG
77 LZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
78 XLFZA XLFZA XFELD CHAR 1   0   Indicator: Alternative payee using account number  
79 DLGRP DLGRP DLGRP CHAR 4   0   Service agent procedure group TVFCD
80 FITYP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type J_1AFITP
81 STCDT J_1ATOID J_1ATOID CHAR 2   0   Tax Number Type J_1ATODC
82 REGSS J_1AREGSS XFELD CHAR 1   0   Registered for Social Insurance  
83 ACTSS J_1AACTSS J_1AACTSS CHAR 3   0   Activity Code for Social Insurance J_1AACT
84 STCD3 STCD3 CHAR18 CHAR 18   0   Tax Number 3  
85 STCD4 STCD4 CHAR18 CHAR 18   0   Tax Number 4  
86 STCD5 STCD5 CHAR60 CHAR 60   0   Tax Number 5  
87 IPISP J_1BINDEQU XFELD CHAR 1   0   Tax Split  
88 TAXBS TAXBS TAXBS NUMC 1   0   Tax Base in Percentage  
89 PROFS PROFS TEXT30 CHAR 30   0   Profession  
90 STGDL STGDL STGDL CHAR 2   0   Shipment: statistics group, transportation service agent VTSGD
91 EMNFR EMNFR CHAR10 CHAR 10   0   External manufacturer code name or number  
92 LFURL URL TEXT132 CHAR 132   0   Uniform resource locator  
93 J_1KFREPRE REPRES REPRES CHAR 10   0   Name of Representative  
94 J_1KFTBUS GESTYP GESTYP CHAR 30   0   Type of Business BUSTYPE
95 J_1KFTIND INDTYP INDTYP CHAR 30   0   Type of Industry INDUSTYPE
96 CONFS CONFS_X CHAR1 CHAR 1   0   Status of Change Authorization (Central)  
97 UPDAT UPDAT_RF DATUM DATS 8   0   Date on Which the Changes Were Confirmed  
98 UPTIM UPTIM_RF AS4TIME TIMS 6   0   Time of Last Change Confirmation  
99 NODEL NODEL_X XFELD CHAR 1   0   Central deletion block for master record  
100 QSSYSDAT QQSSYSDAT QQSSYSDAT DATS 8   0   Validity date of certification  
101 PODKZB PODKZB PODKZB CHAR 1   0   Vendor indicator relevant for proof of delivery  
102 FISKU FISKU LIFNR CHAR 10   0   Account Number of Master Record of Tax Office Responsible LFA1
103 STENR STENR CHAR18 CHAR 18   0   Tax Number at Responsible Tax Authority  
104 CARRIER_CONF /SPE/CARRIER_CNF /SPE/CARRIER_CONF CHAR 1   0   Carrier confirmation is expected  
105 MIN_COMP J_1BMICRO_COMP XFELD CHAR 1   0   Micro company indicator  
106 TERM_LI J_1BTERMS_LIAB XFELD CHAR 1   0   Terms of Liability  
107 CRC_NUM J_1BCRC_NUM CHAR25 CHAR 25   0   CRC number  
108 .INCLUDE       0   0   Vendor Master Data - Brazil  
109 RG J_1BRG J_1BRG CHAR 11   0   RG Number  
110 EXP J_1BEXP J_1BEXP CHAR 3   0   Issued by  
111 UF J_1BUF J_1BUF CHAR 2   0   State  
112 RGDATE J_1BRGDATE DATUM DATS 8   0   RG Issue Date  
113 RIC J_1BRIC J_1BRIC NUMC 11   0   RIC Number  
114 RNE J_1BRNE J_1BRNE CHAR 10   0   Foreign National Registration  
115 RNEDATE J_1BRNEDATE DATUM DATS 8   0   RNE Issue Date  
116 CNAE J_1BCNAE J_1BCNAE CHAR 7   0   CNAE J_1BTCNAE
117 LEGALNAT J_1BLEGALNAT J_1BLEGALNAT NUMC 4   0   Legal Nature J_1BTLEGALNAT
118 CRTN J_1BCRTN J_1BCRTN CHAR 1   0   CRT Number  
119 ICMSTAXPAY J_1BICMSTAXPAY J_1BICMSTAXPAY CHAR 2   0   ICMS Taxpayer J_1BTICMSTAXPAY
120 INDTYP J_1BINDTYP J_1BINDTYP CHAR 2   0   Industry Main Type J_1BTINDTYP
121 TDT J_1BTDT J_1BTDT CHAR 2   0   Tax Declaration Type J_1BTTDT
122 COMSIZE J_1BCOMSIZE J_1BCOMSIZE CHAR 2   0   Company Size J_1BTCOMSIZE
123 DECREGPC J_1BDECREGPC J_1BDECREGPC CHAR 2   0   Declaration Regimen for PIS/COFINS J_1BTDECREGPC
124 .INCLU--AP       0   0   Subcontractor Information  
125 J_SC_CAPITAL /SAPNEA/J_SC_CAPITAL /SAPNEA/J_SC_CAPITAL CURR 15   2   Capital Amount  
126 J_SC_CURRENCY /SAPNEA/J_SC_CURRENCY WAERS CUKY 5   0   Currency TCURC
127 .INCLU--AP       0   0   US Federal Government Vendor Master Data Additional Fields  
128 ALC FMFG_ALC FMFG_ALC CHAR 8   0   Agency Location Code FMFGT_ALC
129 PMT_OFFICE FMFG_PMT_OFF FMFG_PMT_OFF CHAR 5   0   Payment Office FMFGT_PO
130 .INCLU--AP       0   0   Local Authority Additional Fields (Address)  
131 PSOFG PSOFG PSOFG CHAR 10   0   Processor group PSO19
132 PSOIS PSOIS CHAR20 CHAR 20   0   Subledger acct preprocessing procedure  
133 .INCLUDE       0   0   Local Authority Additional Fields (Address)  
134 PSON1 NAME1_GP NAME CHAR 35   0   Name 1  
135 PSON2 NAME2_GP NAME CHAR 35   0   Name 2  
136 PSON3 NAME3_GP NAME CHAR 35   0   Name 3  
137 PSOVN PSOVN NAME CHAR 35   0   First Name  
138 PSOTL PSOTL FMPSOTL CHAR 20   0   Title  
139 PSOHS PSOHS CHAR06 CHAR 6   0   House number: is no longer used from Release 4.6B  
140 PSOST PSOST PSOST CHAR 28   0   Street: No longer used from Release 4.6B  
141 .INCLU--AP       0   0   LFA1 Extension with New Fields - Seasonal Procurement  
142 .INCLUDE       0   0   LFA1 Extension with New Fields - Seasonal Procurement  
143 TRANSPORT_CHAIN WRF_PSCD_TC_ID WRF_PSCD_TC_ID CHAR 10   0   Transportation Chain WRF_PSCD_TCHAINH
144 STAGING_TIME WRF_PSCD_MST WRF_PSCD_MST DEC 3   0   Staging Time in Days  
145 SCHEDULING_TYPE WRF_PSCD_SCHED_TYPE WRF_PSCD_SCHED_TYPE CHAR 1   0   Scheduling Procedure  
146 SUBMI_RELEVANT WRF_SUBMI_RELEVANT XFELD CHAR 1   0   Cross Docking: Relevant for Collective Numbering  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIILFA1 ACTSS J_1AACT J_1AACT 1 CN
2 ROIILFA1 ALC FMFGT_ALC ALC    
3 ROIILFA1 BRSCH T016 BRSCH REF C CN
4 ROIILFA1 CNAE J_1BTCNAE J_1BCNAE KEY    
5 ROIILFA1 COMSIZE J_1BTCOMSIZE J_1BCOMSIZE KEY    
6 ROIILFA1 DECREGPC J_1BTDECREGPC J_1BDECREGPC KEY    
7 ROIILFA1 DLGRP TVFCD DLGRP    
8 ROIILFA1 FISKN LFA1 LIFNR REF C CN
9 ROIILFA1 FISKU LFA1 LIFNR KEY C CN
10 ROIILFA1 FITYP J_1AFITP J_1AFITP 1 CN
11 ROIILFA1 ICMSTAXPAY J_1BTICMSTAXPAY J_1BICMSTAXPAY KEY    
12 ROIILFA1 INDTYP J_1BTINDTYP J_1BINDTYP KEY    
13 ROIILFA1 J_1KFTBUS BUSTYPE GESTYP REF C CN
14 ROIILFA1 J_1KFTIND INDUSTYPE INDTYPE REF C CN
15 ROIILFA1 J_SC_CURRENCY TCURC WAERS    
16 ROIILFA1 KTOCK T077K KTOKK REF C CN
17 ROIILFA1 KTOKK T077K KTOKK REF 1 CN
18 ROIILFA1 KUNNR KNA1 KUNNR REF C CN
19 ROIILFA1 LAND1 T005 LAND1 REF C CN
20 ROIILFA1 LEGALNAT J_1BTLEGALNAT J_1BLEGALNAT KEY    
21 ROIILFA1 LNRZA LFA1 LIFNR REF C CN
22 ROIILFA1 LZONE TZONE ZONE1 REF C CN
23 ROIILFA1 MANDT T000 MANDT KEY 1 CN
24 ROIILFA1 PLKAL TFACD IDENT REF C CN
25 ROIILFA1 PMT_OFFICE FMFGT_PO PMT_OFFICE    
26 ROIILFA1 PSOFG PSO19 PSOFG 1 CN
27 ROIILFA1 QSSYS TQ02B QSSYSFAM REF C CN
28 ROIILFA1 REGIO T005S BLAND REF C CN
29 ROIILFA1 SFRGR TSFG SFRGR REF C CN
30 ROIILFA1 SPERQ TQ04A SPERRFKT REF 1 CN
31 ROIILFA1 SPRAS T002 SPRAS REF 1 CN
32 ROIILFA1 STCDT J_1ATODC J_1ATODC 1 CN
33 ROIILFA1 STGDL VTSGD STGDL    
34 ROIILFA1 TDT J_1BTTDT J_1BTDT KEY    
35 ROIILFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH TC_ID    
36 ROIILFA1 TXJCD TTXJ TXJCD REF C CN
37 ROIILFA1 VBUND T880 RCOMP REF C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in