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

62 columns | Print definition?ERP 6.0  | PCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1PB0290HR Master Record: Infotype 0290 - Identity card CIS30PCODESubunit Codenvarchar100
2T063OOK Codes in Inventory Management4PCODEFunction Codenvarchar200
3T5BPCPostal Codes2PCODEPostal Codenvarchar40
4T5BPCTPostal Code Name3PCODEPostal Codenvarchar40
5T5QPCETP Payment Codes for evaluation class 115PCODEETP Payment Codenvarchar10
6T7GR2PRMGlobal Payroll Parameters2PCODEParameter code (future use)nvarchar120
7TCICCAD Process and Sub-process Codes2PCODEProcess codenvarchar50
8TCIMSet Parameters for CAD Transfer Strings3PCODEProcess codenvarchar50
9TCIQCAD Control Table for Screens and Field Sets and Tables1PCODEProcess codenvarchar50
10TCIRDefinition of User-defined Functions4PCODEProcess code for user-defined functionsnvarchar50
TOPAustralia
11PA0850Infotype for Eligible Termination Payment66PCODEETP Payment Codenvarchar10
TOPBenefits
12PA0270HR Master Data Record: Infotype 0270 (COBRA Payments)27PCODEPayment Methodnvarchar10
TOPCAD Integration
13TCIQTCAD Interface Function Texts2PCODEProcess codenvarchar50
TOPChina
14PA0529HR Master Record: Infotype 0529 (Add. Personal Data CN)28PCODEPolitical statusnvarchar20
15PA0534HR Master Record: Infotype 0534 (Party Infomation)24PCODEPolitical statusnvarchar20
16T7CN59Political status2PCODEPolitical statusnvarchar20
17T7CN5RPolitical status text3PCODEPolitical statusnvarchar20
TOPClinical System
18N1PRDOCIS-H*MED: PATREG: Dokumente35PCODEÖzel gösterge (sunum kodu)nvarchar40
19NDOCAIS-H*MED: Document Management Data for Archived Documents30PCODESpecial Indicator (Presentation Code)nvarchar40
20NDOCSTORNOIS-H*MED: Canceled Documents31PCODESpecial Indicator (Presentation Code)nvarchar40
TOPContract Accounts Receivable and Payable
21DFKKOPUSTAXOUT00Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
22DFKKOPUSTAXOUT01Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
23DFKKOPUSTAXOUT02Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
24DFKKOPUSTAXOUT03Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
25DFKKOPUSTAXOUT04Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
26DFKKOPUSTAXOUT05Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
27DFKKOPUSTAXOUT06Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
28DFKKOPUSTAXOUT07Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
29DFKKOPUSTAXOUT08Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
30DFKKOPUSTAXOUT09Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
31DFKKOPUSTAXOUT10Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
32DFKKOPUSTAXOUT11Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
33DFKKOPUSTAXOUT12Tax Details - Telecommunications Tax (U.S.A.)6PCODEPostal Codenvarchar100
TOPDSD Connector
34/DSD/ME_CUST_CPDDSD CN: One-time Customer12PCODEDSD Connector: Post Codenvarchar100
35/DSD/ME_CUST_HDDSD CN: Customer Details12PCODEDSD Connector: Post Codenvarchar100
TOPGlobal Trade Services
36/SAPSLL/CORACTLegal & Logistics Services: Activities10PCODEPostal Code of Activity Locationnvarchar100
TOPLocalization
37J_1BPRODCODProduct Code2PCODEBrazilian Product Codenvarchar30
38J_1BPRODCODTProduct Code Text3PCODEBrazilian Product Codenvarchar30
TOPMexico
39T77PAYMX65Districts for IT00067PCODEPostal codenvarchar100
TOPMonitoring
40SAPBWPRFLSBW Workload: Relation of Workload Profile and Class Names1PCODESAP Workload: Analysis View IDnvarchar40
41SGLWLPRFLSSAP Workload: Profile Codes and Class Names3PCODESAP Workload: Analysis View IDnvarchar40
TOPNorway
42T5V13SSB Positions code assignment6PCODESSB Position Codenvarchar40
43T5V6CSSB Positional Codes3PCODESSB Position Codenvarchar40
44T5V6DSSB Position Code Description4PCODESSB Position Codenvarchar40
TOPPatient Management
45NDOCIS-H: Assignment of IS-H Objects to Documents in DMS30PCODESpecial Indicator (Presentation Code)nvarchar40
TOPPayroll
46T7SIA6Bank transfer - interface table15PCODECode for APPnvarchar40
47T7SIAPTranfer code for APP6PCODECode for APPnvarchar40
48T7SIBTVirman configuration (WT->Accounts)8PCODECode for APPnvarchar40
TOPPOS Interface
49TWPUBPOS interface: conversion of transaction types sales rcpts3PCODEPOS system codenvarchar40
50TWPUCPOS interface: currency code conversion3PCODECurrency codenvarchar50
51TWPUEPOS interface: conversion of subsystem units of measure3PCODEUnit of measurenvarchar40
52TWPUFPOS interface: conversion of store numbers3PCODEPlantnvarchar100
53TWPUKPOS interface: conversion of POS condition types3PCODEPOS system codenvarchar40
54TWPULPOS interface: conversion of POS language codes3PCODELanguage codenvarchar40
55TWPUMPOS interface: conversion of POS movements types3PCODEMovement Typenvarchar40
56TWPUSPOS interface: conversion of POS tax codes3PCODETax Codenvarchar100
57TWPUVPOS interface: conversion of POS transaction types FI3PCODETransaction Type in POS Systemnvarchar40
58TWPUWPOS interface: conversion of POS material groups3PCODENumbernvarchar150
59TWPUXPOS interface: reassignment of mat. tax classification key3PCODETax classification of materialnvarchar40
60TWPUZPOS interface: conversion of POS payment methods3PCODEPayment method at POS systemnvarchar40
TOPPublic sector Sweden
61T5SK0_CEKPA events13PCODEPension codenvarchar20
TOPRussia
62PA0290HR Master Record: Infotype 0290 - Identity card CIS30PCODESubunit Codenvarchar100