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

81 columns | Print definition?ERP 6.0  | VALID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_COA_T004New charts of accounts - Customizing8VALIDValiditynvarchar10
2FMVALIDValidation for Funds Management5VALIDValidationnvarchar70
3GB91TTexts for validations3VALIDValidationnvarchar70
4P2PL_SIBBASEPayroll Result PL: Allowance bases calculation8VALIDSingle-Character Indicatornvarchar10
5P2PL_ZLABASEResults of PLZLA operation19VALIDValid flagnvarchar10
6T045GBank charges table for bill of exchange presentation11VALIDCharge is valid as from this datenvarchar80
7T045LCharges table for bill/ex.presentation (country-specific)9VALIDCharge is valid as from this datenvarchar80
8T242ISender information18VALIDValidationnvarchar70
9T891BValidation for Special Purpose Ledger / Company Code5VALIDValidationnvarchar70
10T891CValidation for Special Purpose Ledger / Global Company5VALIDValidationnvarchar70
11TKAZEActivation of callup points for CO validation/substitution5VALIDValidationnvarchar70
12T7PIQSWITCHGeneral Setting Options for Customers2VALIDSetting Option Namenvarchar100
13T7PIQSWITCHTTexts for General Setting Options3VALIDSetting Option Namenvarchar100
14T7PIQSWITCHVALUESetting Option Values3VALIDSetting Option Namenvarchar100
15T7PIQ_GB_SWITCHUCAS : Switch table to activate ucaslink3VALIDSetting Option Namenvarchar100
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
16CRM_ECLOG_HEADTable for Replicated eCATT Log Header15VALIDLog SAPGUI Without Interruption TCD Backgroundnvarchar10
TOPAccrual Engine
17TACE_VSR_001Assignment of Validations7VALIDValidationnvarchar70
TOPActual CostingMaterial Ledger
18MLWIPHDWIP Document in Material Ledger - Header12VALIDValid WIP Document for Period/Fiscal Yearnvarchar10
TOPAustria
19T5A9DDefinition of Validity of Age Group Rules7VALIDValidity Period IDnvarchar40
20T5A9EDefinition of Event Intervals for Age Group Rules5VALIDValidity Period IDnvarchar40
TOPBasic Functions
21T093VValidation for Asset Management / Company Code6VALIDValidationnvarchar70
22T876VValidation of Consolidation document5VALIDValidationnvarchar70
23TABWGTransaction type groups17VALIDValidationnvarchar70
TOPBasis Services Communication Interfaces
24KCDSMData transfer: Sender structure8VALIDData transfer: Validation namenvarchar70
TOPBRFplus - ABAP-Based Business Rules
25FDT_EXPR_1400FDT: Expression - Formula4VALIDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
26FDT_EXPR_1400AFDT: Expression - Formula4VALIDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
27FDT_EXPR_1400SFDT: Expression - Formula3VALIDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
28FDT_EXPR_1400TFDT: Expression - Formula3VALIDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
29SFOBUEV000FoBuEv: Header Data of a Formula4VALIDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPBulk Distribution Requirements Planning
30OIISLVCHSilo calibration history index4VALIDSilo: valid calibration recordnvarchar10
TOPBusiness Package for Manager Self-Service FI
31FCOM_WHERE_USEDUsage of Master Data Objects13VALIDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPBusiness Rule Framework
32TBRF139BRF: SAP - Formula Interpreter9VALIDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPCalculation of Employment Period
33T525TTime Specification Type for Employment Period Calculation3VALIDValidity: Period / key datenvarchar10
TOPClinical System
34N2CLIM_VALVSVital Signs: Measured Values2VALIDInternal Key of Measured Value (GUID)nvarchar320
TOPConsolidation
35TF371Time Stamps for Parsing of Validations2VALIDValidation namenvarchar70
36TF375Validation Steps: Node Structure2VALIDValidation namenvarchar70
37TF510Validation of Consolidation Documents6VALIDValidationnvarchar70
TOPContract Accounts Receivable and Payable
38DFKKCMPManually Issued Checks Lot: Item Data17VALIDExpiry Date for a Payment Mediumnvarchar80
39DFKKCRRepository For Checks30VALIDExpiry Date for a Payment Mediumnvarchar80
40DFKKCRDELCR: Deleted Payment Medium / Basic Data33VALIDExpiry Date for a Payment Mediumnvarchar80
41TFK059BRFSFormulas for Withholding Tax Calculation6VALIDValid fromnvarchar80
42TFK059BRFSHFormulas for Withholding Tax: Header6VALIDValid fromnvarchar80
TOPCost Center Accounting
43KPP0VCO planning: Assignment layout <-> validation7VALIDValidationnvarchar70
TOPData Mining
44RSDMTPN_COL_VALModel Column Values5VALIDModel Field Value GUIDnvarchar300
45RSDMTP_COL_VALModel Column Values4VALIDModel Field Value GUIDnvarchar300
TOPData Staging
46RSFOBUEV000BW - FoBuEv: Header Data of a Formula4VALIDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPDocument Management Services
47SDOKCPAGEHDSDOK Code Pages12VALIDInput Selectionnvarchar10
48SDOKCPAGEHDCSDOK Code Pages: Customer Table12VALIDInput Selectionnvarchar10
TOPeCATT Extended Computer Aided Test Tool
49ECLOG_AIDXTable for Log Archive Index21VALIDLog SAPGUI Without Interruption TCD Backgroundnvarchar10
50ECLOG_HEADTable for Log Header14VALIDLog SAPGUI Without Interruption TCD Backgroundnvarchar10
51ECLOG_HYDRASeveral Header Entries for Log23VALIDLog SAPGUI Without Interruption TCD Backgroundnvarchar10
TOPFinancial Accounting
52T001DValidation of Accounting Documents4VALIDValidationnvarchar70
TOPFinancial Conditions
53FICO_FOBUEV000FoPostEv: Header data of Formula (Not Buffered)4VALIDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPGlobal Trade Services
54/SAPSLL/T606SVLegal Control: Status Management per License Type10VALIDField Control for Statuses in Legal Controlnvarchar10
TOPHR Administrative Services
55T5ASRPROCGRVALGroup-Dependent Process Selection for Start Application7VALIDValidity of Processnvarchar10
56T5ASRPROCVALIDValid Processes for Start Applications6VALIDValidity of Processnvarchar10
TOPInformation system
57FMFINBDEFFixed Values of Report2VALIDnvarchar100
58FMFINBDEFTTexte Berichtsfestwerte2VALIDSchlüssel eines Berichtsfestwertesnvarchar100
59FMFINBTRPflege von Formularfestwerten4VALIDSchlüssel eines Berichtsfestwertesnvarchar100
TOPIntegrated Product and Process Engineering
60CPPEDMU_VWR_FRMTViewer Implementations4VALIDCheckboxnvarchar10
TOPJoint Venture und Production Sharing Accounting
61T8JZVALValidation of JVA Documents4VALIDValidationnvarchar70
TOPLease Accounting
62FIEH_STATUSObject Status for Restart Exception Handling7VALIDAccrual Typenvarchar60
TOPMeasuring Points and Counters
63T370PMeasuring Point Category7VALIDCheckboxnvarchar10
TOPMonitoring
64CSMSCRMETHIntrinsic Methods of CCMS System Component Repository13VALIDIndicator for Meta Data in System Component Repositorynvarchar10
TOPNetwork and Activity
65TCN41Network Defaults70VALIDValidationnvarchar70
TOPOperative Structures
66TCJ41Default Values for Work Breakdown Structure71VALIDValidationnvarchar70
TOPPatient Management
67TN40CIS-H: Alternative Scheduling Types6VALIDIS-H: Start of validity x days before available time slotsnvarchar30
TOPPayroll General Parts
68T596AWage Type Application4VALIDValidity time for subapplicationnvarchar10
TOPPerformance Assessment Workbench
69SLS_ITEMPAW - Item Description18VALIDPAW - Validitydecimal32
TOPPersonnel Administration
70T7CO03Social Insurance entity type4VALIDValidation typenvarchar10
TOPReal Estate Management
71TIVVAValidation for Real Esate Management / Company code6VALIDValidationnvarchar70
TOPReuse Services for Country Development
72PA0865HR Master Record: Infotype 086533VALIDRecord Validity: Amountnvarchar60
TOPSingapore
73T5R2DNRS Reason (SGP)9VALIDValidnvarchar10
TOPValidation, Substitution and Rules
74GB908Rule: Usage of Rules in Validations3VALIDValidationnvarchar70
75GB93Validation2VALIDValidationnvarchar70
76GB931Validation Activities2VALIDValidationnvarchar70
77GB935Usage of Validations2VALIDValidationnvarchar70
78GB93TTexts for Validations3VALIDValidationnvarchar70
TOPVendor Evaluation
79EVAL_IV_PERS_ITMPersistent Key FIgures with Info About Indicator13VALIDValidationnvarchar10
TOPWarranty Claim Processing
80CWTYVSActivation Table for Validation/Substitution5VALIDValidationnvarchar70
TOPWeb Service and SOAP - ABAP
81SRT_TEST_SEQ_IDSSequence Key for Persistent Sequences7VALIDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217