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

98 columns | Print definition?ERP 6.0  | AKTIV

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/FMITWRTYHHM Summenbeleg aktive Werttypen4AKTIVHHM Summenbeleg Werttyp aktivnvarchar10
2/XFT/EPA_CRMPARGeneral settings4AKTIVEntry active / inactivenvarchar10
3FILUD_AA_MASTERSAFT: FI Asset master data and values12AKTIVAsset capitalization datenvarchar80
4P2RA_SPPayroll Results: Special Payments35AKTIVActivity statusnvarchar10
5P2RB_SPPayroll Results: Special Payments35AKTIVActivity statusnvarchar10
6P2RD_SPPayroll Results: Special Payments35AKTIVActivity statusnvarchar10
7P2RE_SPPayroll Results: Special Payments35AKTIVActivity statusnvarchar10
8P2RI_SPPayroll Results: Special Payments35AKTIVActivity statusnvarchar10
9P2RM_MTAXPayroll Result: Tax (DK)12AKTIVActive key for tax Denmarknvarchar10
10P2RN_SPPayroll Results: Special Payments35AKTIVActivity statusnvarchar10
11P2RR_SPPayroll Results: Special Payments35AKTIVActivity statusnvarchar10
12T021DLine Layout Fast Entry: Administration4AKTIVFast Entry: Variant Active?nvarchar10
13T7PIQOPTCActivation of Database Optimizations3AKTIVActivate Optimizationnvarchar10
14TBPFCAvailability Control: Tolerance Limits9AKTIVTolerance limit activenvarchar10
15TFK000INActive Industry Instance3AKTIVIndustry Instance Activenvarchar10
16TFK021KAFI-CA: Add-On Developments3AKTIVAdd-On Development Is Activenvarchar10
17TFKOPTCActivation of Database Optimizations3AKTIVActivate Optimizationnvarchar10
18TFRMForm Routines for Requirements/Formulas/Data Transports3AKTIVRoutine has been activatednvarchar10
19TRK10Table for reorg structure4AKTIVArchiving checkboxnvarchar10
20ZEPX_FRG_ACTActivation for FinfraG Reporting Switzerland3AKTIVEinstelliges Kennzeichennvarchar10
TOPAddress ManagementBusiness Address
21TSAVAddress Versions (Business Address Services) (Obsolete)2AKTIVFlag: activenvarchar10
TOPAdvertising Management
22TJJPRDH_TVTBIS-M/AM Prdh (S&P): Assign Link Table to S&P Product Hier.5AKTIVIS-M/AM: Product Hierarchy: Active Indicatornvarchar10
TOPArchiveLink
23TOAATTCUSTCustomizing Table for Internal Attribute Administration2AKTIVSAP ArchiveLink: General Switchnvarchar10
TOPBasic Data
24QMATInspection type - material parameters27AKTIVInspection Type - Material Combination is Activenvarchar10
25TNOBJIS-H: Objects for Client Reset Program10AKTIVIS-H: Active Indicator of Assignmentnvarchar10
TOPBasic Functions
26ANLAAsset Master Record Segment21AKTIVAsset capitalization datenvarchar80
27T061ADevelopment Partner5AKTIVFI-ARI: Supplier active?nvarchar10
28T182EControl Table for Customer Statistics3AKTIVActive indicator for updating statisticsnvarchar10
TOPBasis Services Communication Interfaces
29NASTMessage Status23AKTIVActivenvarchar10
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
30TBE11BTE Application Indicator2AKTIVIndicator: Application Activenvarchar10
31TBE12Complementary Software Partner2AKTIVPartner active?nvarchar10
32TBE24Customer Products4AKTIVProduct active?nvarchar10
TOPBI Content Analyzer
33RSCONTACTStatus Overview of All BW TLOGO Content Objects3AKTIVControl Charactersnvarchar10
TOPBusiness Application Support
34CNVWDCNV watchdog: Customizing table12AKTIVGeneral Flagnvarchar10
TOPCapital Investments
35ANIADepr. simulation for invest. projects13AKTIVPlanned capitalization datenvarchar80
TOPClasses
36TCLTClassifiable Objects3AKTIVIndicator: SAP object classified as standardnvarchar10
TOPCoding Block
37TCOBACoding Block: Customer Subscreens (Header)4AKTIVSubscreen Active for Coding Blocknvarchar10
TOPCollectionsDisbursements
38TKKVAKTIVActivities and/or Notes for the Clerk2AKTIVActivity Codenvarchar40
TOPContract Accounts Receivable and Payable
39TFK000Application Area in Contract Accounts Receivable/Payable3AKTIVApplication Area Is Activenvarchar10
40TFK021DScreen variants: Administration4AKTIVScreen Variant Activenvarchar10
41TFK033VPosting Areas: Views5AKTIVView of Posting Area Is Activenvarchar10
42TFKDMCDispute Management: General Settings2AKTIVSAP Dispute Management Is Activenvarchar10
TOPContract Billing
43DBERCHZIndividual Line Items156AKTIVMeter reading activenvarchar10
44DBERCHZ1Individual line items89AKTIVMeter reading activenvarchar10
45DBERCHZ5Individual line items (unimportant rows)89AKTIVMeter reading activenvarchar10
TOPCross-Application Components
46CRMCONSUMPossible Users of R/3 Adapter Functionality3AKTIVIndicator: Application Activenvarchar10
47J_8A3SZENAscenarios - Old Version, don't use3AKTIVactive - Old Version, don't usenvarchar10
48J_8A3SZENTscenario texts - Old Version, don't use4AKTIVactive - Old Version, don't usenvarchar10
49J_8A3T0010scenarios3AKTIVActivenvarchar10
50J_8A3T0011scenario texts4AKTIVActivenvarchar10
TOPDenmark
51PA0072HR Master Record: Infotype 0072 (Fiscal Data - DK)38AKTIVActive key for tax Denmarknvarchar10
TOPDocuments
52TN1IM_IMSETTINGSCustomizing: Image System5AKTIVIndicator: Interface Is Activenvarchar10
TOPForms
53T514NAllowed Field Names for Forms7AKTIVUse in tables T512D, E, Q, and N allowednvarchar10
TOPGermany
54T5DP1PAISY Interface21AKTIVPAISY: Activation Indicatornvarchar20
TOPIncentive and Commission Management ICM
55CACSTBE11Application Indicator3AKTIVIndicator: Application Activenvarchar10
56CACS_TFK000Application Area in Contract Accounts Receivable/Payable3AKTIVApplication Area Is Activenvarchar10
TOPInventory Management
57WRMA_MANDTSingle Client Settings for RMA2AKTIVRMA Active in Clientnvarchar10
TOPInvoicing
58DBERDZDB Table: Individ. Lines - Print Document182AKTIVMeter reading activenvarchar10
59EABPJVL_CORRCorrespondence Print: Bud. Bill. Plan Header and YAP Info.24AKTIVYearly advance payment activenvarchar10
60EJVLYearly Advance Payment17AKTIVYearly advance payment activenvarchar10
TOPLoans Management
61VDDD_HEADER_VERLoans: Header Data - Version Layout3AKTIVLayout Activenvarchar10
TOPLogistics Execution LE Enhancements
62/SAPMP/LBA_CUSTIS-MP: Control Table DTUC Processing5AKTIVActivation Indicator for Shipping-Point-Dependent DTUC Checknvarchar10
TOPMaster Data
63TE061Installer Status3AKTIVInstaller in supply area is activenvarchar10
TOPMeter Reading
64EABLMR Document18AKTIVMeter reading activenvarchar10
65EABLDELDeleted Meter Reading Document18AKTIVMeter reading activenvarchar10
TOPNet Worth Tax
66IDFIAA_JP_RESULTResults of Property Tax Report (Japan)15AKTIVAsset capitalization datenvarchar80
TOPNon-Ferrous Metal enhancements
67/NFM/TNFMInclude Routines for Rate Determination Modules3AKTIVIndicator: Routine Activatednvarchar10
68/NFM/TNFRRate Determination FORM Routines3AKTIVIndicator: Routine Activatednvarchar10
TOPObject Selection
69GEN_TABLES_MAINGenerated Tables for Search in Classification System5AKTIVSingle-Character Indicatornvarchar10
70GEN_TABLES_SUBGenerated Tables for Multiple-Value Characteristics5AKTIVSingle-Character Indicatornvarchar10
TOPPatient Accounting
71TN32MHCO: Assign Classifying IS-H Characteristics to CO6AKTIVIS-H: Active Indicator of Assignmentnvarchar10
TOPPatient Management
72NPOBIS-H: Planning Objects for Outpatient Clinic Scheduling10AKTIVIS-H: Indicator whether Planning Object Is Activenvarchar10
TOPPOS Interface - Outbound
73TWPCOPYReference Ship-to Party for IDoc Copy Management6AKTIVGeneral Flagnvarchar10
TOPPrice Planning Workbench
74WRF_PPW_PPDCALCPPD Calculation Set25AKTIVProcessed by Activation Report and Budgets (if Used) Updatednvarchar10
TOPProduct Cost Planning
75TCKH4Cost Component Structure for Cost of Goods Manufactured6AKTIVCost Component Structure Activenvarchar10
TOPProfitability Analysis
76TKEI_COCMPActive Indicator for the Cost Component Split Transfer3AKTIVIndicator: Transfer Cost Component Splitnvarchar10
77TKEXYWFValue Field Name <-> Value Field Key4AKTIVnvarchar10
TOPProject System
78TCSCRSettings table for tabs in flexible detail display6AKTIVIndicator: Active tab pagenvarchar10
TOPPublic Sector
79T5D7OGrouping Company Code/Service Type Catalog4AKTIVIndicator: Service Types Are Usednvarchar10
80T5DPBS1DSelective Activation of Gross Overpayment5AKTIVActivation Indicator for Gross Overpaymentnvarchar10
TOPSales Plan
81LISAKTBackground Planning Activities6AKTIVPlanning activitynvarchar120
82LISPLFPlanning Entries Table for Background Planning in LIS6AKTIVKey for planning activitynvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
83/ISHFR/NTPKFR_AKIS-H FR: Asgt Serv. Master France => Activity + Phase5AKTIVIS-H FR: Activitynvarchar10
84/ISHFR/NTPKFR_ASIS-H FR: Asgt Serv. Master France => Ass. Serv. + Code5AKTIVIS-H FR: Activitynvarchar10
85/ISHFR/NTPKFR_MCIS-H FR: Asgt Service Master France => Modif. Codes5AKTIVIS-H FR: Activitynvarchar10
86NCH60IS-HCO CH: Kriterien fuer Sammelaufträge5AKTIVIS-H: codice 'attivo' di un'attribuzionenvarchar10
87TNWCHEXTNRIS-H CH: Übermittlung alternativer Leistungscode (ein/aus)6AKTIVIS-H: casella di spuntanvarchar10
TOPSAP Utilities
88EABLCTemporary Meter Reading Document in AMI Environment18AKTIVMeter reading activenvarchar10
TOPService Data Download
89TCUSFUBASummary table of FMs to determine system-specific data3AKTIVSingle-Character Indicatornvarchar10
TOPService Station Retailing
90OIREDTFCAPTSSR PC: Controls the tabstrips in the DTF transaction3AKTIVSSR PC: Active flagnvarchar10
91OIREDTFCAPTSSSR PC: Controls the tabstrips in the DTF transaction3AKTIVSSR PC: Active flagnvarchar10
TOPSocial Insurance
92T5D31Professionals Pension Organization (PPO)20AKTIVStatus of a Professionals Pension Organizationnvarchar10
TOPTime Sheet
93TAFLDAssignment of Application Fields to Components4AKTIVIndicator Showing the Field Is Active in this Contextnvarchar10
TOPTraining Management
94HRT5047Table Section Infotype 50477AKTIVProcess Step for Follow-Up On/Offnvarchar10
95LSOFUPROCESSFollow-Up Procedure6AKTIVProcess Step for Follow-Up On/Offnvarchar10
TOPValue Adjustment
96/IBS/CRB_RFCCALRBD: Obsolete4AKTIVRBD: Active Indicatornvarchar10
TOPWarranties
97BGMPMaster Warranty Item10AKTIVCheckboxnvarchar10
TOPWarranty Claim Processing
98PNWTYVWarranty Claim Version (PVS Node)12AKTIVActive Versionnvarchar10