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

71 columns | Print definition?ERP 6.0  | KBLPOS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals89KBLPOSEarmarked Funds: Document Itemnvarchar30
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals90KBLPOSEarmarked Funds: Document Itemnvarchar30
3/OPT/VIM_1ITEM_SDocument Item95KBLPOSEarmarked Funds: Document Itemnvarchar30
4/OPT/VIM_TITEMDocument Item95KBLPOSEarmarked Funds: Document Itemnvarchar30
5BSAD_BAKAccounting: Secondary index for customers (cleared items)158KBLPOSEarmarked Funds: Document Itemnvarchar30
6BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)162KBLPOSEarmarked Funds: Document Itemnvarchar30
7BSEGAccounting Document Segment266KBLPOSEarmarked Funds: Document Itemnvarchar30
8BSID_BAKAccounting: Secondary Index for Customers158KBLPOSEarmarked Funds: Document Itemnvarchar30
9BSIK_BAKAccounting: Secondary index for vendors162KBLPOSEarmarked Funds: Document Itemnvarchar30
10BSSEGAccounting Document Segment255KBLPOSEarmarked Funds: Document Itemnvarchar30
11FIAPSAD_ADP_LTAdvance Payment Request Line Items Details11KBLPOSEarmarked Funds: Document Itemnvarchar30
12FIAPSAD_ORDR_LTLine Item for Order Number KSA24KBLPOSEarmarked Funds: Document Itemnvarchar30
13FUDT_VDOCBSEGVerification Document Item with Additional Info255KBLPOSEarmarked Funds: Document Itemnvarchar30
14FUDT_VDOCBSEGEVVerification Document Item in the Entry View255KBLPOSEarmarked Funds: Document Itemnvarchar30
15FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)255KBLPOSEarmarked Funds: Document Itemnvarchar30
16GLPOS_C_CTFI Document: Entry View142KBLPOSEarmarked Funds: Document Itemnvarchar30
17GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items142KBLPOSEarmarked Funds: Document Itemnvarchar30
18GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items142KBLPOSEarmarked Funds: Document Itemnvarchar30
19GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items142KBLPOSEarmarked Funds: Document Itemnvarchar30
20GLPOS_N_CTNew General Ledger: Line Item with Currency Type144KBLPOSEarmarked Funds: Document Itemnvarchar30
21GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type144KBLPOSEarmarked Funds: Document Itemnvarchar30
22REGUPProcessed items from payment program165KBLPOSEarmarked Funds: Document Itemnvarchar30
23YVIM_1ITEMDocument Item95KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPAccounting Interface
24GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)185KBLPOSEarmarked Funds: Document Itemnvarchar30
25GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)185KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPActual Payments and Forecast
26COFPDocument Lines (project cash management)48KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPElectronic Bank Statement
27FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)61KBLPOSEarmarked Funds: Document Itemnvarchar30
28FEB_ACTAcct Assignment Templates61KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPExternal Services
29ESKNAccount Assignment in Service Package54KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPFinancial Accounting
30/OPT/VIM_1ITEMDocument Item95KBLPOSEarmarked Funds: Document Itemnvarchar30
31ACCTITCompressed Data from FI/CO Document106KBLPOSEarmarked Funds: Document Itemnvarchar30
32BSADAccounting: Secondary Index for Customers (Cleared Items)158KBLPOSEarmarked Funds: Document Itemnvarchar30
33BSAKAccounting: Secondary Index for Vendors (Cleared Items)162KBLPOSEarmarked Funds: Document Itemnvarchar30
34BSIDAccounting: Secondary Index for Customers158KBLPOSEarmarked Funds: Document Itemnvarchar30
35BSIKAccounting: Secondary Index for Vendors162KBLPOSEarmarked Funds: Document Itemnvarchar30
36KMZEIFI: Account Assignment Model Item Information65KBLPOSEarmarked Funds: Document Itemnvarchar30
37KOMUAccount Assignment Templates for G/L Account Items65KBLPOSEarmarked Funds: Document Itemnvarchar30
38VBSEGADocument Segment for Document Parking - Asset Database37KBLPOSEarmarked Funds: Document Itemnvarchar30
39VBSEGDDocument Segment for Customer Document Parking122KBLPOSEarmarked Funds: Document Itemnvarchar30
40VBSEGKDocument Segment for Vendor Document Parking134KBLPOSEarmarked Funds: Document Itemnvarchar30
41VBSEGSDocument Segment for Document Parking - G/L Account Database98KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPFunds Management
42FCABPFI-CA: Document Item43KBLPOSEarmarked Funds: Document Itemnvarchar30
43FMEPFI-FM Line Items55KBLPOSEarmarked Funds: Document Itemnvarchar30
44FMLGD_H_VG_01_01Budget Type 01: Customer Down Payment8KBLPOSEarmarked Funds: Document Itemnvarchar30
45FMLGD_H_VG_02_01Posting Type 02: Vendor Down Payment8KBLPOSEarmarked Funds: Document Itemnvarchar30
46FMLGD_H_VG_05_01Posting Type 05: Down Payment with General Request (01)6KBLPOSEarmarked Funds: Document Itemnvarchar30
47FMLGD_H_VG_05_02Posting Type 05:Vendor Down Payment with General Request(02)8KBLPOSEarmarked Funds: Document Itemnvarchar30
48FMLGD_H_VG_06_01Posting Type 06:Customer Down Payment with General Request6KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPFunds Management-Specific Postings
49FMCJIS-PS: Documents in Cash Desk Subsidiary Ledger24KBLPOSEarmarked Funds: Document Itemnvarchar30
50FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years97KBLPOSEarmarked Funds: Document Itemnvarchar30
51PSOSEGADocument Segment for Assets Document Parking38KBLPOSEarmarked Funds: Document Itemnvarchar30
52PSOSEGSRecurring Request Document Segment, G/L Accounts96KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPGeneral Ledger Accounting
53BSEG_ADDEntry View of Accounting Document for Additional Ledgers60KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPGL Account Posting
54TCJ_POSITIONSCash Journal Document Items68KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPInventory Management
55MSEGDocument Segment: Material188KBLPOSEarmarked Funds: Document Itemnvarchar30
56RESBReservation/dependent requirements187KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPInvoice Verification
57RBCODocument Item, Incoming Invoice, Account Assignment60KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPMaterials Management
58/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions138KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPPayment Transactions
59CRACCPayment Cards: Account Assignments in Card Master Record18KBLPOSEarmarked Funds: Document Itemnvarchar30
60CRNUMPayment cards: Card master record39KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPPurchasing
61EBANPurchase Requisition130KBLPOSEarmarked Funds: Document Itemnvarchar30
62EBKNPurchase Requisition Account Assignment57KBLPOSEarmarked Funds: Document Itemnvarchar30
63EKCPAPurchasing Contract Commitment Plan Account Assignment Data7KBLPOSEarmarked Funds: Document Itemnvarchar30
64EKKNAccount Assignment in Purchasing Document62KBLPOSEarmarked Funds: Document Itemnvarchar30
65EKPOPurchasing Document Item208KBLPOSEarmarked Funds: Document Itemnvarchar30
66MEREQXPurchase Requisition Change Parameter130KBLPOSUpdated information in related user data fieldnvarchar10
TOPRemaining Beverage - Obsolete Objects
67/BEV3/CH1030BSG2Document Segment CH Event Ledger Part222KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPRepetitive Manufacturing
68COMPMOVEGoods Movement of Components151KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPSelf-Service Procurement
69/SRMERP/D_ACC_ITAccount assignment item50KBLPOSEarmarked Funds: Document Itemnvarchar30
TOPSimulation
70VSEBKN_CNVersion: Purchase requisition account assignment58KBLPOSEarmarked Funds: Document Itemnvarchar30
71VSRESB_CNVersion: Reservation/Dependent requirements195KBLPOSEarmarked Funds: Document Itemnvarchar30