SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

194 columns | Print definition?ERP 6.0  | FKART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000512TVFKT6FKARTnvarchar40
2/1RA/0SD010MIItems for Class SD01 - Raw Data63FKARTBilling Typenvarchar40
3/ATL/SD_DOCUMENTSD Document Classifications4FKARTBilling Typenvarchar40
4/ATL/UILBILNRLocalization SD - Billing documents NR intervals3FKARTBilling Typenvarchar40
5/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data13FKARTnvarchar40
6/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item11FKARTnvarchar40
7/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.11FKARTnvarchar40
8/CCEE/FISC_B_TYPFiscalization Croatia: Billing Types2FKARTBilling Typenvarchar40
9/CEECV/BVLO_DNGBDelivery Note Invoice Group Assignment (SD and MM)3FKARTBilling Typenvarchar40
10/CEECV/BVLO_SPLISettings for Document Splitting (Latvia)2FKARTBilling Typenvarchar40
11CE1PR22Périm. résultat IDES22FKARTType de facturenvarchar40
12CE2PR22Périm. résultat IDES16FKARTType de facturenvarchar40
13CE4PR22Périm. résultat IDES10FKARTType de facturenvarchar40
14CE4PR22_ACCTPérim. résultat IDES8FKARTType de facturenvarchar40
15CE4PR22_FLAGPérim. résultat IDES7FKARTFlag : caract. imputée manuellement ou via TKEZUnvarchar10
16CE4PR22_KENCPérim. résultat IDES9FKARTType de facturenvarchar40
17GLPCA_CTProfit Center Documents72FKARTBilling Typenvarchar40
18GLPCA_T_CTProfit Center Documents88FKARTBilling Typenvarchar40
19HUPHPF_SIGNPHPF Sign Determination table2FKARTBilling Typenvarchar40
20J_1A_WS_DATA_MAPAR WS RG2904: Array Item Data mapping3FKARTBilling Typenvarchar40
21MSPT_OIGSTD Shipment Header to store deleted records43FKARTShipment cost typenvarchar40
22TVARRArchiving Control for Billing3FKARTBilling Typenvarchar40
23TVFKEDOCeDocument Billing Type3FKARTBilling Typenvarchar40
24TVFSPBilling: Blocking Reasons3FKARTBilling Typenvarchar40
TOPAccounting Interface
25GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)243FKARTBilling Typenvarchar40
26GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)243FKARTBilling Typenvarchar40
TOPAdd-Ons for Billing
27AD04RELCONRelation between conditions4FKARTBilling Typenvarchar40
TOPAdvertising Management
28JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset185FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
29JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition27FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
30JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties24FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
31JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header16FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
32TJH01IS-M: Determine Bill.Type for Rev.Distribution Billing Docs3FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
33TJH05IS-M/AM: Billing: Document Types2FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
34TJH06IS-M/AM: Billing: Document Types: Texts3FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
35TJH09IS-M/AM: Order-Related Billing Type Determination7FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
36TJH27Document Type Determination for Transfer to FI/RF Billing3FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
37TJH99IS-M/AM: Commission Related Billing Type Determination5FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
38TJHA1IS-M/AM: Contract-Related Billing Type Determination5FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
39TJHTKEVA10Control Transfer from IS-M/AM to CO-PA (TKEVA10)3FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
40TJHVAIS-M/AM: General Contract Attributes for Sales Area71FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
41TJJAJIS-M/AM: Standard Settings, Media Sales Agent Settlement3FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
42TJJV18IS-M: Sales Partner Schemas Copying Control -> Billing Doc.3FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40
TOPAgency Business Global Trade
43TMRRL_SDAB-RRLE: Assgnmt of Remuneratn List Grps to SD Billing Type2FKARTBilling Typenvarchar40
TOPBasic Functions
44TVFKBilling: Document Types2FKARTBilling Typenvarchar40
45TVFKTBilling: Document Types: Texts3FKARTBilling Typenvarchar40
TOPBilling
46VBRKBilling Document: Header Data3FKARTBilling Typenvarchar40
47VRKPASales Index: Bills by Partner Functions7FKARTBilling Typenvarchar40
48VRPMASD Index: Billing Items per Material6FKARTBilling Typenvarchar40
TOPConditions
49B008Billing Type4FKARTBilling Typenvarchar40
50B011Sales Organization/Billing Type5FKARTBilling Typenvarchar40
TOPContract Accounts Receivable and Payable
51FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts8FKARTBilling Typenvarchar40
TOPCosting
52COERSales Order Value Revenue23FKARTBilling Typenvarchar40
TOPData Collection
53S008Communications Table SD -> CO/Projects17FKARTBilling Typenvarchar40
54S262SD - Billing document16FKARTBilling Typenvarchar40
55S262BIW1SD - Billing document16FKARTBilling Typenvarchar40
56S262BIW2SD - Billing document16FKARTBilling Typenvarchar40
TOPData Retention Tool
57TXW_S_VBRKRetrieve VBRK from archive13FKARTBilling Typenvarchar40
TOPDistribution
58WCAT_C_PAYTYPEPlanned Reb. Var.: Payment Types for Customer Billing Types3FKARTBilling Typenvarchar40
TOPDistributor-Reseller-Management
59/SAPHT/DRMCTVFKDRM relevant setting for Billing document types2FKARTBilling Typenvarchar40
TOPDown Payment Chains
60/SAPPCE/TDPCINVCustomization table for assigning Billing Type to DPC2FKARTBilling Typenvarchar40
TOPEmpties Management
61/BEV1/EMFAKTABilling Types Without Empties Update2FKARTBilling Typenvarchar40
62/BEV1/EMLGOFSEmpties - Billing Document Without Update11FKARTBilling Typenvarchar40
TOPFinancial Accounting
63J_1AOFNR4SD Billing Type Parameters per country3FKARTBilling Typenvarchar40
TOPFreight Processing
64TIARSArchiving Control Shipment Costs3FKARTShipment cost typenvarchar40
65TVFPAssignment of Purchasing Data for Shipment Costs3FKARTShipment cost typenvarchar40
66TVFTKDetermination: Shipment Cost Item Categories2FKARTShipment cost typenvarchar40
67TVTFShipment Cost Types2FKARTShipment cost typenvarchar40
68TVTFTShipment Cost Types: Descriptions3FKARTShipment cost typenvarchar40
69VFKKShipment Costs: Header Data4FKARTShipment cost typenvarchar40
TOPGoods Issue Process
70/SPE/GI_RVRS_INVConfigure Goods Issue Cancellation Behavior2FKARTBilling Typenvarchar40
TOPIntegration
71FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts10FKARTBilling Typenvarchar40
TOPInvoice Forecasting
72IFW_C_BILL_TYPEBilling document type for provisional invoice2FKARTBilling Typenvarchar40
TOPLocalization
73IDPL_DP_NUM_RANGPoland: Number range for the clearing documents4FKARTBilling Typenvarchar40
74J_1BSDICNF relevant Item Categories2FKARTBilling Typenvarchar40
75J_1IBOSDEFAULTDefault Blling Type for Export3FKARTBilling Typenvarchar40
76J_1ICUS_BILL_TYPAssign Customer Category to Bill Type6FKARTBilling Typenvarchar40
77J_1IVATINVOICEBilling type determination for VAT4FKARTBilling Typenvarchar40
78J_3RFGTDINVTDefine Billing Types for Customs Declaration Tracking3FKARTBilling Typenvarchar40
79J_3RFSD_RATE_CLCEnable Down Payments in FC Function for SD Billing Documents3FKARTBilling Typenvarchar40
80J_3RF_CORR_INVDefine Correction Invoices (Russia)4FKARTBilling Typenvarchar40
TOPLogistics - General
81OIG_TVFTKTD-F Determination: Valuation Class of Shipment Cost Items2FKARTShipment cost typenvarchar40
TOPPatient Accounting
82NVBRKIS-H: Billing document header data3FKARTBilling Typenvarchar40
TOPPeriodical Sales and Distribution
83JFDFSIS-M/SD: Billing/Settlement Index10FKARTIS-M: Billing/Settlement Typenvarchar40
84JFRKIS-M/SD: Billing - Header Data3FKARTIS-M: Billing/Settlement Typenvarchar40
85TJAKIS-M/SD: Sales Document Type5FKARTIS-M: Billing/Settlement Typenvarchar40
86TJF05IS-M/SD: Doc.Type Det.for Billing Transfer to FI/RI5FKARTIS-M: Billing/Settlement Typenvarchar40
87TJFKIS-M/SD: Billing Document Types2FKARTIS-M: Billing/Settlement Typenvarchar40
88TJFKTIS-M/SD: Texts for Billing Document Types2FKARTIS-M: Billing/Settlement Typenvarchar40
89TJFTKEVA10Controls for Transfer from IS-M/SD to CO-PA (TKEVA10)3FKARTIS-M: Billing/Settlement Typenvarchar40
TOPProfit Center Accounting
90GLPCAEC-PCA: Actual Line Items74FKARTBilling Typenvarchar40
TOPProfitability Analysis
91CE1850022FKARTBilling Typenvarchar40
92CE1BGISErgebnisbereich für22FKARTFakturaartnvarchar40
93CE1E_B1Model Bank22FKARTBilling Typenvarchar40
94CE1IDEAOp. Concern BR World22FKARTBilling Typenvarchar40
95CE1IDEBErgebnisbereich IDES22FKARTFakturaartnvarchar40
96CE1IDESErgebnisbereich IDES22FKARTFakturaartnvarchar40
97CE1INT1Ergebnisbereich IDES22FKARTFakturaartnvarchar40
98CE1OC01Bike International22FKARTBilling Typenvarchar40
99CE1R300Operating Concern IDES22FKARTBilling Typenvarchar40
100CE1S001Sample operating concern22FKARTBilling Typenvarchar40
101CE1S300Operating Concern IDES22FKARTBilling Typenvarchar40
102CE1S_ALAirline Route Profit22FKARTBilling Typenvarchar40
103CE1S_CPTemplate for Consumer Goods Industry22FKARTBilling Typenvarchar40
104CE1S_GOQuickstart Template22FKARTBilling Typenvarchar40
105CE2850016FKARTBilling Typenvarchar40
106CE2BGISErgebnisbereich für16FKARTFakturaartnvarchar40
107CE2E_B1Model Bank16FKARTBilling Typenvarchar40
108CE2IDEAOp. Concern BR World16FKARTBilling Typenvarchar40
109CE2IDEBErgebnisbereich IDES16FKARTFakturaartnvarchar40
110CE2IDESErgebnisbereich IDES16FKARTFakturaartnvarchar40
111CE2INT1Ergebnisbereich IDES16FKARTFakturaartnvarchar40
112CE2OC01Bike International16FKARTBilling Typenvarchar40
113CE2R300Operating Concern IDES16FKARTBilling Typenvarchar40
114CE2S001Sample operating concern16FKARTBilling Typenvarchar40
115CE2S300Operating Concern IDES16FKARTBilling Typenvarchar40
116CE2S_ALAirline Route Profit16FKARTBilling Typenvarchar40
117CE2S_CPTemplate for Consumer Goods Industry16FKARTBilling Typenvarchar40
118CE2S_GOQuickstart Template16FKARTBilling Typenvarchar40
119CE4850010FKARTBilling Typenvarchar40
120CE48500_ACCT8FKARTBilling Typenvarchar40
121CE48500_FLAG7FKARTFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
122CE48500_KENC9FKARTBilling Typenvarchar40
123CE4BGISErgebnisbereich für10FKARTFakturaartnvarchar40
124CE4BGIS_ACCTErgebnisbereich für8FKARTFakturaartnvarchar40
125CE4BGIS_FLAGErgebnisbereich für7FKARTFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
126CE4BGIS_KENCErgebnisbereich für9FKARTFakturaartnvarchar40
127CE4E_B1Model Bank10FKARTBilling Typenvarchar40
128CE4E_B1_ACCTModel Bank8FKARTBilling Typenvarchar40
129CE4E_B1_FLAGModel Bank7FKARTFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
130CE4E_B1_KENCModel Bank9FKARTBilling Typenvarchar40
131CE4IDEAOp. Concern BR World10FKARTBilling Typenvarchar40
132CE4IDEA_ACCTOp. Concern BR World8FKARTBilling Typenvarchar40
133CE4IDEA_FLAGOp. Concern BR World7FKARTFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
134CE4IDEA_KENCOp. Concern BR World9FKARTBilling Typenvarchar40
135CE4IDEBErgebnisbereich IDES10FKARTFakturaartnvarchar40
136CE4IDEB_ACCTErgebnisbereich IDES8FKARTFakturaartnvarchar40
137CE4IDEB_FLAGErgebnisbereich IDES Banking7FKARTFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
138CE4IDEB_KENCErgebnisbereich IDES9FKARTFakturaartnvarchar40
139CE4IDESErgebnisbereich IDES10FKARTFakturaartnvarchar40
140CE4IDES_ACCTErgebnisbereich IDES8FKARTFakturaartnvarchar40
141CE4IDES_FLAGErgebnisbereich IDES7FKARTFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
142CE4IDES_KENCErgebnisbereich IDES9FKARTFakturaartnvarchar40
143CE4INT1Ergebnisbereich IDES10FKARTFakturaartnvarchar40
144CE4INT1_ACCTErgebnisbereich IDES8FKARTFakturaartnvarchar40
145CE4INT1_FLAGErgebnisbereich IDES7FKARTFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
146CE4INT1_KENCErgebnisbereich IDES9FKARTFakturaartnvarchar40
147CE4OC01Bike International10FKARTBilling Typenvarchar40
148CE4OC01_ACCTBike International8FKARTBilling Typenvarchar40
149CE4OC01_KENCBike International9FKARTBilling Typenvarchar40
150CE4R300Operating Concern IDES10FKARTBilling Typenvarchar40
151CE4R300_ACCTErgebnisbereich IDES8FKARTFakturaartnvarchar40
152CE4R300_FLAGErgebnisbereich IDES7FKARTFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
153CE4R300_KENCOperating Concern IDES9FKARTBilling Typenvarchar40
154CE4S001Sample operating concern8FKARTBilling Typenvarchar40
155CE4S001_ACCTSample operating con8FKARTBilling Typenvarchar40
156CE4S001_FLAGSample Operating Concern 17FKARTFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
157CE4S001_KENCSample operating con9FKARTBilling Typenvarchar40
158CE4S300Operating Concern IDES10FKARTBilling Typenvarchar40
159CE4S300_ACCTOperating Concern IDES8FKARTBilling Typenvarchar40
160CE4S300_FLAGErgebnisbereich IDES Serv.Prov7FKARTFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
161CE4S300_KENCOperating Concern IDES9FKARTBilling Typenvarchar40
162CE4S_ALAirline Route Profit10FKARTBilling Typenvarchar40
163CE4S_AL_ACCTAirline Route Profit8FKARTBilling Typenvarchar40
164CE4S_AL_FLAGAirline Route Profit7FKARTFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
165CE4S_AL_KENCAirline Route Profit9FKARTBilling Typenvarchar40
166CE4S_CPTemplate for Consumer Goods Industry10FKARTBilling Typenvarchar40
167CE4S_CP_ACCTTemplate for Consumer Goods Industry8FKARTBilling Typenvarchar40
168CE4S_CP_FLAGTemplate for Consumer Goods Industry7FKARTFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
169CE4S_CP_KENCTemplate for Consumer Goods Industry9FKARTBilling Typenvarchar40
170CE4S_GOQuickstart Template10FKARTBilling Typenvarchar40
171CE4S_GO_ACCTQuickstart Template8FKARTBilling Typenvarchar40
172CE4S_GO_FLAGQuickstart Template7FKARTFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
173CE4S_GO_KENCQuickstart Template9FKARTBilling Typenvarchar40
174CEERRORCO-PA: Incorrect records from SD51FKARTBilling Typenvarchar40
175CEST4Segment table (CO-PA)10FKARTBilling Typenvarchar40
176TKEVA10Control for Transfer from SD to CO-PA3FKARTBilling Typenvarchar40
TOPRecycling Administration Core Functions
177J_7LC03REA Data Filter: Billing Types3FKARTBilling Typenvarchar40
178J_7LC62REA Data Filters: Doc. Flow Evaluation-to-Billing Type Asgmt5FKARTBilling Typenvarchar40
179J_7LC672REA Data Filters: Document Flow Evaluation Billing Type4FKARTBilling Typenvarchar40
180J_7LS990Pseudo Info Structure Similar to S990 for Extern.Data w/o SD14FKARTBilling Typenvarchar40
181J_7LVBRKNON-SD Interface: Billing: Header Data3FKARTBilling Typenvarchar40
TOPRemaining Beverage - Obsolete Objects
182/BEV1/RBBOCustomer Master Data Rebate Processing18FKARTBilling Typenvarchar40
183/BEV1/RBCUSTRebate Customizing History7FKARTBilling Typenvarchar40
184/BEV1/RBWEItemized Proof Rebate Settlement52FKARTBilling Typenvarchar40
185/BEV1/TSSSPBFEIndiv.Doc.- Permiss.Doc.Types - Column Dtld Defntn TS Stats9FKARTBilling Typenvarchar40
TOPSales
186VKDFSSD Index: Billing Initiator6FKARTBilling Typenvarchar40
TOPService Station Retailing
187OIRIDCPARSSR Invoicing - Document parameters3FKARTBilling Typenvarchar40
188OIRIPGRPSSR SD/FI Invoice posting group3FKARTBilling Typenvarchar40
TOPSupply Chain Management
189TCM_C_SLS_MAPMapping TM Organizational Unit to Sales Organisation14FKARTBilling Typenvarchar40
190TCM_ORG_SLS_MAPMapping TCM Organizational unit to sales organisation13FKARTBilling Typenvarchar40
TOPTransportation
191TVTKShipment Types27FKARTShipment cost typenvarchar40
TOPTransportation and Distribution
192OIGSTD Shipment Header43FKARTShipment cost typenvarchar40
193TOIGSTD Shipment Types43FKARTShipment cost typenvarchar40
TOPValuated Delivery Note
194/BEV1/VDT685Permissible Terms of Delivery: Types for R/3 Beverage5FKARTBilling Type for Valuated Delivery Notesnvarchar40