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

72 columns | Print definition?ERP 6.0  | CYCLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKK_MA_AGIAgreement for Invoice Creation5CYCLEBilling Cyclenvarchar40
2DFKK_MA_AGLAgreement for Creation of Invoicing Lists5CYCLEBilling Cyclenvarchar40
3DFKK_VT_CYCManagement: Billing Cycle for Each Provider Contract5CYCLEBilling Cyclenvarchar40
4DFKK_VT_CYCREQPeriodic Rating Request16CYCLEBilling Cyclenvarchar40
5TFK8117Discounts/Charges on Billed Items: Basic Settings5CYCLECycle of Calculation of Discount/Chargenvarchar40
TOPASAP AcceleratedSAP
6SQACYCLECycles in Q&Adb1CYCLECycle in Q&Adbnvarchar200
TOPClinical System
7N1CORDUNITCORD: Units for Clinical Orders3CYCLECORD: Cycle Duration Unit Indicatornvarchar10
TOPContract Accounts Receivable and Payable
8DFKK_VT_ICT: Items of Provider Contract31CYCLEBilling Cyclenvarchar40
TOPCost Center Accounting
9T811CAllocations: Cycles3CYCLEAllocation/cyclenvarchar100
10T811DAllocations: Document Numbers3CYCLEAllocation/cyclenvarchar100
11T811DAAllocations: Dependent Document Numbers3CYCLEAllocation/cyclenvarchar100
12T811DHAllocations: Header Fields3CYCLEAllocation/cyclenvarchar100
13T811DSAllocations: Document Numbers for Segment Reverse/Rebook3CYCLEAllocation/cyclenvarchar100
14T811FAllocations: Element Table3CYCLEAllocation/cyclenvarchar100
15T811GField Groups for Allocation Cycle3CYCLEAllocation/cyclenvarchar100
16T811IAAllocations: Customizing3CYCLEAllocation/cyclenvarchar100
17T811KAllocations: Key Fields3CYCLEAllocation/cyclenvarchar100
18T811LAssessments/Distributions: Long Text4CYCLEAllocation/cyclenvarchar100
19T811RAllocation table for receiver assignments3CYCLEAllocation/cyclenvarchar100
20T811SAllocations: Segments3CYCLEAllocation/cyclenvarchar100
21T811VRSSpecification of Version Change for Cycles3CYCLEAllocation/cyclenvarchar100
22T811ZCCycles for Runtime Analysis4CYCLEAllocation/cyclenvarchar100
23T811ZTCycles for Runtime Analysis3CYCLEAllocation/cyclenvarchar100
TOPCross-Application Components
24AAUUFKOrder master data48CYCLECost center to which costs are actually postednvarchar100
TOPData Basis
25RSODSMPPVERIFYLog for Data Verification3CYCLENatural Numberint100
TOPFrance
26T5F1C4Contributions conditions6CYCLEPersonnel Calculation Rulenvarchar40
TOPGovernance, Risk and Compliance
27GRFNREPSTRATEGYReport: Walking Strategy9CYCLEPosition in cyclenvarchar30
TOPInvoicing in Contract Accounts Receivable and Payable
28DFKKINV_CYCManagement: Billing Cycle per Contract Account7CYCLEBilling Cyclenvarchar40
29DFKKINV_CYCREQDummy Document for Invoicing for Periodic Invoicing10CYCLEBilling Cyclenvarchar40
30TFK2607Billing Cycles2CYCLEBilling Cyclenvarchar40
31TFK2607TBilling Cycles (Texts)3CYCLEBilling Cyclenvarchar40
TOPJoint Venture und Production Sharing Accounting
32JVPO1JVA: Plan Line Items132CYCLEAllocation/cyclenvarchar100
33JVSO1JV LI Table with Objects for JVTO168CYCLEAllocation/cyclenvarchar100
TOPMedia Product Sales and Distribution
34JVSDDELIVCYCLEIS-M: Delivery Cycle per Plant3CYCLEDelivery Cyclenvarchar100
35JVSDDELIVCYCLESAIS-M: Assignment of Media Prods to Delivery Cycle/Sales Area3CYCLEDelivery Cyclenvarchar100
36JVSDDELIVCYCLGRPIS-M: Delivery Group per Cycle and Plant3CYCLEDelivery Cyclenvarchar100
37JVSDDELIVCYCPRODIS-M: Assign Media Products to Delivery Cycle3CYCLEDelivery Cyclenvarchar100
38JVSDDELIVCYCVIPLIS-M: Assign Visit Plans to Delivery Cycle4CYCLEDelivery Cyclenvarchar100
39JVSDSHPPLISSOPTShipping Dates for a Media Issue for Optimized Contracts3CYCLEDelivery Cyclenvarchar100
40JVSDTRSPPLANIS-M: Transportation Plan3CYCLEDelivery Cyclenvarchar100
41JVSDTRSPPLANCONTIS-M: Transportation Plan - Contracts in Truck Route3CYCLEDelivery Cyclenvarchar100
42JVSDTRSPPLANORDIS-M: Transportation Plan - Order Items (Pull) in Truck Rte3CYCLEDelivery Cyclenvarchar100
43JVSDTRSPPLCONTNAIS-M: Transportation Plan - Contracts Not Assigned9CYCLEDelivery Cyclenvarchar100
44JVSDTRSPPLISSUESIS-M: Transportation Plan - Assigned Media Issues3CYCLEDelivery Cyclenvarchar100
45JVSDTRSPPLORDNAIS-M: Transportation Plan - Order Items Not Assigned6CYCLEDelivery Cyclenvarchar100
46JVSDWLTRSPLCONTRAlternative Shipping Dates for Sales Orders from Qty Planng3CYCLEDelivery Cyclenvarchar100
47JVSDWLTRSPLISSUEShipping Dates for Media Issue3CYCLEDelivery Cyclenvarchar100
48JVSDWLTRSPLORDERIS-M: TP Worklist of Orders for Pull Process per Shippg Date3CYCLEDelivery Cyclenvarchar100
49JVSDWLTRSPPLANIS-M: TP Worklist Status3CYCLEDelivery Cyclenvarchar100
50TJVSDDELIVCYCLEDelivery Cycles2CYCLEDelivery Cyclenvarchar100
TOPOverhead Cost Orders
51AUFKOrder master data48CYCLECost center to which costs are actually postednvarchar100
TOPPatient Management
52NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)72CYCLEIS-H: Appointment Cyclenvarchar30
TOPPayroll General Parts
53HRPY_CYCLE_DOCUPersonnel Calculation Rules: User Comments3CYCLEPersonnel Calculation Rulenvarchar40
54HRPY_CYCLE_INDEXIndex Table for Table HRPY_CYCLE_DOC2CYCLEPersonnel Calculation Rulenvarchar40
TOPProduct Cost Controlling
55CATDHCATT Test Data Memory, History3CYCLECATT Test Data Memory, Cycle Numbernvarchar40
56CATDOCATT Test Data Memory, Test Objects9CYCLECATT Test Data Memory, Cycle Numbernvarchar40
TOPProduct Cost Planning
57TCWB_OBJECTSTestobjekte6CYCLEZyklusnvarchar40
58TCWB_OBJECTS_HISHistorie zum Testobjekt7CYCLEZyklusnvarchar40
TOPRussia
59T7RUT1Taxes and netto payments51CYCLERelevancy test for calculating averagesnvarchar40
60T7RUT1_CETaxes and netto payments - addition for CE8CYCLEPersonnel Calculation Rulenvarchar40
61T7RUT3Tax privileges14CYCLERelevancy test for calculating averagesnvarchar40
62T7RUT3_CETax privileges5CYCLEPersonnel Calculation Rulenvarchar40
TOPSimulation
63VSAUFK_CNVersion: Order master data49CYCLECost center to which costs are actually postednvarchar100
TOPTraders and Schedulers Workbench
64OIJBRDHRD header f.batch:Don't use(obsolete) & don't delete(XPRA)44CYCLEOIL-TSW: Planning cycle perioddecimal30
65OIJLOCMATOIL-TSW: Location Rundown/Planning material table33CYCLEOIL-TSW: Planning cycle perioddecimal30
66OIJNOMHNomination Header32CYCLENomination Pipeline cycle IDnvarchar100
67OIJNOMHVERSNomination Header Version Table34CYCLENomination Pipeline cycle IDnvarchar100
68OIJRDHRundown header: Don't use (obsolete) & don't delete (XPRA)43CYCLEOIL-TSW: Planning cycle perioddecimal30
69OIJTSMATOIL-TSW: TS Rundown/Planning material table32CYCLEOIL-TSW: Planning cycle perioddecimal30
70OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item44CYCLENomination Pipeline cycle IDnvarchar100
71OIJ_RDHEADStock Projection header46CYCLEOIL-TSW: Planning cycle perioddecimal30
72OIJ_SCHEDPlanned Schedule Lines40CYCLENomination Pipeline cycle IDnvarchar100