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

111 columns | Print definition?ERP 6.0  | PROVIDER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/UI2/CHIP_CHDRCHIP Cache: Header Information6PROVIDERName of CHIP Providernvarchar300
2/UI2/CHIP_CHDRMCHIP Cache: Header Information7PROVIDERName of CHIP Providernvarchar300
3CNVMBTPROCTYPEMaster data for MBT / PCL procedure types8PROVIDERMBT PCL provider idnvarchar300
4T77PAOSSPROVSearch Category2PROVIDERSearch Providernvarchar320
TOPAuthoring Environment
5LSO_CPT_PROGRESSInformation on Running Publishing Activities7PROVIDERProvidernvarchar400
TOPBasic Functions
6UKM_PROV_RULESAP Credit Management: External Provider Assignment3PROVIDERExternal Providernvarchar100
TOPClinical System
7TN1CCPROVi.s.h.med: Medication, External Provider Medication Checks3PROVIDERMedication: External Provider of Medical Checksnvarchar400
TOPCorporate Performance Monitor
8UMK_BMK001Master Data Mapping Profile2PROVIDERMeasure & Benchmark Providernvarchar100
TOPEnd User Technology
9RSDAS_PROVData Access Service Provider by Object Type (Tlogo)2PROVIDERClass Name of a Data Access Service Providernvarchar300
10RSDAS_PROV_VARVariants for Data Access Service Provider1PROVIDERClass Name of a Data Access Service Providernvarchar300
11RSDAS_PROV_VARTTexts for Variants of the Data Access Service Provider1PROVIDERClass Name of a Data Access Service Providernvarchar300
TOPEnterprise Service Framework Layer
12SCOL_ND_ASSOCESF : Business Object - Association15PROVIDERESF: Association Implemented at Source or Targetnvarchar10
TOPGateway Business Workflow enablement
13/IWWRK/D_PFW_TMSODC Push Timestamp for last selection report run2PROVIDERWorkflow Task Provider IDnvarchar50
TOPGlobal Trade Services
14/SAPSLL/CORULOBJSLL: Overview of Upload Objects8PROVIDERBusiness Partner Numbernvarchar100
TOPJob Pricing
15T71JPR01Survey Provider2PROVIDERSurvey Provider Codenvarchar40
16T71JPR02Survey2PROVIDERSurvey Provider Codenvarchar40
17T71JPR02TSurvey Name3PROVIDERSurvey Provider Codenvarchar40
18T71JPR03Survey Job2PROVIDERSurvey Provider Codenvarchar40
19T71JPR03TSurvey Job Text3PROVIDERSurvey Provider Codenvarchar40
20T71JPR04Survey Job Family2PROVIDERSurvey Provider Codenvarchar40
21T71JPR04TSurvey Job Family Text3PROVIDERSurvey Provider Codenvarchar40
22T71JPR05Survey Job Catalog2PROVIDERSurvey Provider Codenvarchar40
23T71JPR06Survey Header Data2PROVIDERSurvey Provider Codenvarchar40
24T71JPR07Survey General Data2PROVIDERSurvey Provider Codenvarchar40
25T71JPR08Survey Statistical Data2PROVIDERSurvey Provider Codenvarchar40
26T71JPR09Survey Job / Internal Job Matching Data5PROVIDERSurvey Provider Codenvarchar40
27T71JPR10Survey Country2PROVIDERSurvey Provider Codenvarchar40
28T71JPR11Survey Industry2PROVIDERSurvey Provider Codenvarchar40
29T71JPR12Survey Industry Code2PROVIDERSurvey Provider Codenvarchar40
30T71JPR12TSurvey Industry Code Text3PROVIDERSurvey Provider Codenvarchar40
31T71JPR13Survey Region2PROVIDERSurvey Provider Codenvarchar40
32T71JPR14Survey Region Code2PROVIDERSurvey Provider Codenvarchar40
33T71JPR14TSurvey Region Code Text3PROVIDERSurvey Provider Codenvarchar40
34T71JPR15Survey Revenue Size2PROVIDERSurvey Provider Codenvarchar40
35T71JPR16Survey Revenue Size Code2PROVIDERSurvey Provider Codenvarchar40
36T71JPR16TSurvey Revenue Size Code Text3PROVIDERSurvey Provider Codenvarchar40
37T71JPR17Survey Company Size2PROVIDERSurvey Provider Codenvarchar40
38T71JPR18Survey Company Size Code2PROVIDERSurvey Provider Codenvarchar40
39T71JPR18TSurvey Company Size Code Text3PROVIDERSurvey Provider Codenvarchar40
40T71JPR19Survey Company Type2PROVIDERSurvey Provider Codenvarchar40
41T71JPR20Survey Company Type Code2PROVIDERSurvey Provider Codenvarchar40
42T71JPR20TSurvey Company Type Code Text3PROVIDERSurvey Provider Codenvarchar40
43T71JPR21Survey Length of Service2PROVIDERSurvey Provider Codenvarchar40
44T71JPR22Survey Length of Service Code2PROVIDERSurvey Provider Codenvarchar40
45T71JPR22TSurvey Length of Service Code Text3PROVIDERSurvey Provider Codenvarchar40
46T71JPR24Survey Data Fields Mapping2PROVIDERSurvey Provider Codenvarchar40
TOPMarket Risk Analyzer
47TCCT_CCURVE_MASTCommodity Curve Master Data20PROVIDERProvider of Commodity Market Datanvarchar100
TOPMonitoring
48CSMBKFact Table for CCMS System Repository11PROVIDERData supplier that creates a class token tuplenvarchar400
49CSMBK_ASCAssociations in CCMS System Repository23PROVIDERData supplier that creates a class token tuplenvarchar400
50CSMBK_OB2New Object Table for SCR from SAP Web AS 6.1016PROVIDERData supplier that creates a class token tuplenvarchar400
51CSMBK_OBJObject Repository in CCMS System Repository7PROVIDERData supplier that creates a class token tuplenvarchar400
52CSMBK_PROTTranslation Table for CCMS CSM Provider Names2PROVIDERCCMS Monitoring Architecture: Name of MTE classnvarchar400
53CSMBK_SEMCSM_BK: Semantic and Token Definitions2PROVIDERCCMS Monitoring Architecture: Name of MTE classnvarchar400
TOPNetWeaver Business Content
54BIZCROBJBusiness Content: Content Object4PROVIDERContent Providernvarchar200
55BIZCROBJTBusiness Content: Object Type3PROVIDERContent Providernvarchar200
56BIZCROBJT_TBusiness Content: Object Type3PROVIDERContent Providernvarchar200
57BIZC_CPROV_REGBusiness Content: Registered Content Provider1PROVIDERContent Providernvarchar200
58BIZC_CPROV_SOLMAConnection Table: l Content Provider - SolMan3PROVIDERContent Providernvarchar200
59BIZC_TEMPLATEBusiness Content: Template Management for Configuration4PROVIDERContent Providernvarchar200
60TBIZC_CPROV_REGText Table Business Content Provider2PROVIDERContent Providernvarchar200
TOPServices
61SDBINDING2Service Directory: Table of Service Bindings3PROVIDERName in Service Directorynvarchar800
TOPStakeholder Relationship Management
62USC_MAILPROVIDERContacts: Service Provider for Mass Mailing2PROVIDERStakeholdernvarchar100
TOPTransaction Manager
63RDPT_SCHEDULERedemption Schedules for Bonds34PROVIDERData Providernvarchar200
64TRCOT_CTY_FWDPERobsolete3PROVIDERProvider of Commodity Market Datanvarchar100
65TRCOT_CTY_PROVProvider dependent Forward Period Settings for a CO3PROVIDERProvider of Commodity Market Datanvarchar100
TOPTravel Expenses
66FTPT_REQ_CATType of Transport/Accomm. and Est.Cost of Travel Request10PROVIDERCustomer Program: Provider Codenvarchar30
TOPTravel Planning
67FTPT_CARTravel Request Item - Car Rental Service9PROVIDERCar Rental Providernvarchar30
68FTPT_TRAINTravel Request Item - Train Service9PROVIDERTrain providernvarchar30
69TA20BHDisplayable Hotel Rates of User Groups3PROVIDERProvider Codenvarchar30
70TA20BPRProvider-Specific Reservation Systems4PROVIDERProvider Codenvarchar30
71TA20NCNegotiated rental car rates (corporate nego rates)2PROVIDERProvider of negotiated ratenvarchar30
72TA20NC1Negotiated rental car rates (language-dependent)3PROVIDERProvider of negotiated ratenvarchar30
73TA20NCRNegotiated Car Rental Rates2PROVIDERProvider of negotiated ratenvarchar30
74TA20NCR1Negotiated Car Rental Rates (Language-Dependent)3PROVIDERProvider of negotiated ratenvarchar30
75TA20NEGOFNegotiated Flight Fares (Corporate Nego Fares)2PROVIDERProvider of negotiated ratenvarchar30
76TA20NEGOF1Negotiated Flight Fares (Language-Dependent)3PROVIDERProvider of negotiated ratenvarchar30
77TA20NFNegotiated Flight Fares (Corporate Nego Fares)2PROVIDERProvider of negotiated ratenvarchar30
78TA20NF1Negotiated flight fares (language-dependent)3PROVIDERProvider of negotiated ratenvarchar30
79TA20NHNegotiated hotel rates (corporate nego rates)2PROVIDERProvider of negotiated ratenvarchar30
80TA20NH1Negotiated hotel rates (language-dependent)3PROVIDERProvider of negotiated ratenvarchar30
81TA20NHCNegotiated Hotel Rates4PROVIDERProvider of negotiated ratenvarchar30
82TA20NHC1Negotiated Hotel Rates (Language-Dependent)5PROVIDERProvider of negotiated ratenvarchar30
83TA20NRCDiscount Agreement for Rental Car Usage2PROVIDERProvider Codenvarchar30
84TA20NRFDiscount Agreement for Flights2PROVIDERDiscount providernvarchar30
85TA20NRHDiscount Agreement for Hotel Accommodations2PROVIDERProvider Codenvarchar30
86TA20PFTravel Profiles - Methods of Payment4PROVIDERProvider Codenvarchar30
87TA20PICCar Rental Trip Rule3PROVIDERProvider Codenvarchar30
88TA20PIFFlight Trip Rule3PROVIDERProvider Codenvarchar30
89TA20PIHHotel Trip Rule3PROVIDERProvider Codenvarchar30
90TA20PVPSetting for Lowest Fare Availability Search3PROVIDERProvider Codenvarchar30
91TA20REBFDiscount Agreement for Flights2PROVIDERDiscount providernvarchar30
92TA20RTG_PRoute Segment Provider5PROVIDERProvider of a route segmentnvarchar30
93TA20WWWWWW Link Catalog for Information Sources6PROVIDERProvider Codenvarchar30
94TA21PTravel Service Providers3PROVIDERProvider Codenvarchar30
95TA21PFProvider-Specific Customer Programs3PROVIDERCustomer Program: Provider Codenvarchar30
96TA21PFAAssignment of Customer Programs to Additional Providers3PROVIDERCustomer Program: Provider Codenvarchar30
97TA21PHCustomer-Specific Hotel Catalog3PROVIDERProvider Codenvarchar30
98TA23BIBEParameters for Access to Deutsche Bahn Through BIBE Portal3PROVIDERProvider Codenvarchar30
99TA23GKTMCR (Major Customer Rate German Railway)3PROVIDERProvider Codenvarchar30
100TA23L_CAssign Locations to IATA Locations (Car Rental)4PROVIDERProvider Codenvarchar30
101TA23PFPayment Method4PROVIDERProvider Codenvarchar30
102TA23PICCar Rental Trip Rule (Filter before Availability Query)5PROVIDERProvider Codenvarchar30
103TA23PIFFlight Trip Rule (Filter before Availability Query)7PROVIDERProvider Codenvarchar30
104TA23PIHHotel Trip Rule (Filter before Availability Query)5PROVIDERProvider Codenvarchar30
105TA23PITFlight Trip Rule3PROVIDERProvider Codenvarchar30
106TA23P_FOIDTravel Service Providers3PROVIDERProvider Codenvarchar30
TOPTreasury
107TCRC_CTY_PROVIDRMarket Data Provider for Commodity Forward Rates2PROVIDERProvider of Commodity Market Datanvarchar100
108TCRT_CTY_FWDRATEMarket Data for Forward Rates3PROVIDERProvider of Commodity Market Datanvarchar100
109TCRT_CTY_PROVIDTMarket Data Provider for Commodity Forward Rates (Texts)2PROVIDERProvider of Commodity Market Datanvarchar100
TOPWD ABAP Page Builder
110CHIP_CACHE_HDRCHIP Cache: Header Information6PROVIDERName of CHIP Providernvarchar300
111CHIP_CACHE_HDRMCHIP Cache: Header Information7PROVIDERName of CHIP Providernvarchar300