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

85 columns | Print definition?ERP 6.0  | ANRED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSECOne-Time Account Data Document Segment40ANREDTitlenvarchar150
2CNV_20305_CEPCSAP LT: Backup table of CEPC15ANREDTitlenvarchar150
3CNV_20800_KNVKCNV backup copy: Customer master contact person14ANREDForm of address for contact person (Mr, Mrs...etc)nvarchar300
4FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document40ANREDTitlenvarchar150
5FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)40ANREDTitlenvarchar150
6P2RB_NAMEPayroll Results: Name of Employee10ANREDTitlenvarchar150
7P2RD_NAMEPayroll Results: Name of Employee10ANREDTitlenvarchar150
8P2RK_NAMEName of Employee6ANREDForm-of-Address Keynvarchar10
9P2RN_NNAMPersonal Data14ANREDForm-of-Address Keynvarchar10
10P2RU_NAMEName of Employee7ANREDForm-of-Address Keynvarchar10
11TXV01Forms of address key translations3ANREDForm-of-Address Keynvarchar20
12TZV01Form-of-Address Key2ANREDForm-of-Address Keynvarchar20
13HRP1702DB Table for Infotype 170236ANREDForm-of-Address Keynvarchar10
14T7PIQ_GB_TITLEUCAS: Mapping table UCAS Titles -> SAP Title/Form of Addre3ANREDForm-of-Address Keynvarchar10
TOPAddress ManagementBusiness Address
15SADRAddress Management: Company Data4ANREDTitlenvarchar150
16SADRPAddress Management: Personal Data4ANREDTitlenvarchar150
TOPAdvertising Management
17JJTAMIS-M/AM: Media Contact Person13ANREDForm of Address Keynvarchar20
18TJHAFIS-M/AM: Assign Address to Name Fields in Address Creation3ANREDForm of Address Keynvarchar20
19TJHWWW_JHAWIS-M/AM: Enter Classified Ad IAC: General Settings13ANREDForm of Address Keynvarchar20
TOPAustria
20PA0632HR Master Record: Infotype 0632 (Semiretirement A)39ANREDForm-of-Address Keynvarchar10
TOPAutomatic Payments
21PAYRQPayment Requests30ANREDTitlenvarchar150
TOPBank Customer Accounts
22BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA129ANREDForm of Addressnvarchar150
TOPBasic Data
23NGPAIS-H: Business Partners12ANREDIS-H: Form-of-Address Keynvarchar20
TOPBusiness Partner
24TIVBPVENDORGENVendor Preassignment (General Data)3ANREDTitlenvarchar150
TOPChina
25PA0528HR Master Record: Infotype 0528 (Family information)41ANREDForm-of-Address Keynvarchar10
TOPClinical System
26N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle26ANREDIS-H: Hitap biçimi anahtarinvarchar20
27N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle27ANREDIS-H: Hitap biçimi anahtarinvarchar20
28N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal27ANREDIS-H: Hitap biçimi anahtarinvarchar20
TOPControlling
29CSKSCost Center Master Data34ANREDTitlenvarchar150
TOPCross-Application Components
30BC490KKNA1General data in customer master18ANREDTitlenvarchar150
31KKNA1General Data in Customer Master18ANREDTitlenvarchar150
32SKNA1Customer Master table for BC417 Course18ANREDTitlenvarchar150
33SKNVKCustomer Master Contact table for BC417 Course13ANREDForm of address for contact person (Mr, Mrs...etc)nvarchar300
TOPCross-Application Objects in HR
34BBP_TSAD3HRSRM Decoupling: Copy of Table TSAD3HR2ANREDForm-of-Address Keynvarchar10
35HRP5582DB Table for Infotype 558220ANREDForm-of-Address Keynvarchar10
36TCACS_ANREDConversion of Form of Address: HR -> Business Partner2ANREDForm-of-Address Keynvarchar10
TOPCustomer Master
37KNA1General Data in Customer Master18ANREDTitlenvarchar150
38KNVKCustomer Master Contact Partner13ANREDForm of address for contact person (Mr, Mrs...etc)nvarchar300
TOPFinancial Accounting
39LFA1Vendor Master (General Section)20ANREDTitlenvarchar150
40VBSECDocument Parking One-Time Data Document Segment40ANREDTitlenvarchar150
TOPFSCM In-House Cash
41IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order7ANREDTitlenvarchar150
TOPFunds Management-Specific Postings
42PAYRCAdditional Header Data for Recovery Order13ANREDTitlenvarchar150
43PSOSECRecurring Request Document Segment, One-Time Data38ANREDTitlenvarchar150
TOPGL Account Posting
44TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items41ANREDTitlenvarchar150
TOPHong Kong
45PA0344HR Master Record: Infotype 0344 (Familiy members HK)45ANREDForm-of-Address Keynvarchar10
TOPInformation System
46DKKOSBalance Audit Trail8ANREDTitlenvarchar150
47DKOKSOpen Item Account Balance Audit Trail Master Record9ANREDTitlenvarchar150
TOPInvoice Verification
48RBKPDocument Header: Invoice Receipt115ANREDTitlenvarchar150
TOPLoans Management
49VDAUSZDrawings on Disbursement52ANREDTitlenvarchar150
50VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity66ANREDTitlenvarchar150
51VZFZE_VDAUSZCentral Entry Table for Release Procedure54ANREDTitlenvarchar150
TOPLocalization
52J_1BNFDOCNota Fiscal Header67ANREDTitlenvarchar150
53J_1BNFNADNota Fiscal partners7ANREDTitlenvarchar150
TOPMaster Data
54JGTSADRIS-M: Extended Address Management14ANREDForm of Address Keynvarchar20
TOPOverhead Cost Controlling
55CMDT_ADRGeneric Master Record: Address7ANREDTitlenvarchar150
TOPPatient Management
56NPAPIS-H: Provisional Patient Master Data14ANREDIS-H: Form-of-Address Keynvarchar20
57NPATIS-H: Patient Master Data (General)23ANREDIS-H: Form-of-Address Keynvarchar20
TOPPayment Transactions
58REGUHSettlement data from payment program13ANREDTitlenvarchar150
TOPPendulum List Indirect Sales
59/BEV4/PLDUMKDNConversion Table Customer/Object Numbers9ANREDTitlenvarchar150
TOPPeriodical Sales and Distribution
60JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet5ANREDForm of Address Keynvarchar20
61JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data23ANREDForm of Address Keynvarchar20
62JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data23ANREDForm of Address Keynvarchar20
63JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet4ANREDForm of Address Keynvarchar20
TOPPersonnel Administration
64PA0002HR Master Record: Infotype 0002 (Personal Data)38ANREDForm-of-Address Keynvarchar10
65T522Title Keys3ANREDForm-of-Address Keynvarchar10
66T522GTitle Keys2ANREDForm-of-Address Keynvarchar10
67T522TForms of Address3ANREDForm-of-Address Keynvarchar10
TOPProduct Cost Planning
68CKBSBase Planning Object - Unit Costing24ANREDTitlenvarchar150
TOPProfit Center Accounting
69CEPCProfit Center Master Data Table15ANREDTitlenvarchar150
TOPPurchasing
70EKANVendor Address: Purchasing Document13ANREDTitlenvarchar150
TOPRecruitment
71PB0002HR Master Record: Infotype 0002 (Personal Data)38ANREDForm-of-Address Keynvarchar10
TOPRecycling Administration Core Functions
72J_7LSADRAddress Management: Company Data4ANREDTitlenvarchar150
TOPRemaining Beverage - Obsolete Objects
73/BEV1/CLDEBCustomer Information3ANREDTitlenvarchar150
TOPReuse Services for Country Development
74T5F99FOADMForm of Address status key recodification for DAQ reports4ANREDForm-of-Address Keynvarchar40
75T5F99FOAMForm of Address status key recodification for DAQ reports4ANREDForm-of-Address Keynvarchar10
TOPSales Promotions
76SADLSTRECBDynamic Part of Address List (Record Body)16ANREDTitlenvarchar150
TOPSAP Healthcare - Industry-Specific Components for Hospitals
77NPSPATIS-H: Pseudonymized Patient Master Data (General)8ANREDPseudonymized Form of Address Keynvarchar40
TOPSAP Media
78J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping10ANREDForm of Address Keynvarchar20
TOPShipping
79DVK01R/2-R/3 Link: Delivery Header Data R2 -> R36ANREDForm of addressnvarchar150
TOPStrategic Enterprise Management
80TSAD3HRForm of Address Conversion: HR Format - SAP Business Partner2ANREDForm-of-Address Keynvarchar10
TOPThailand
81PA0187Additional family data24ANREDForm-of-Address Keynvarchar10
82T7THSPName Prefix/ Form of Address Codes2ANREDForm-of-Address Keynvarchar10
TOPTraining and Event Management
83HRP1034Infotype 1034 DB table18ANREDForm-of-Address Keynvarchar10
TOPTransfer Postings
84J_1AAWAYBLWay Bills for asset movements26ANREDTitlenvarchar150
TOPTreasury
85VZKNA1Collector for batch input KNA1 from RF-VV3ANREDTitlenvarchar150