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

83 columns | Print definition?ERP 6.0  | RLTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BUT_UNBLK_REQSTUblocking Request Data4RLTYPBP Rolenvarchar60
TOPBank Customer Accounts
2BKK45_CORRCorrespondence Receiver Administration8RLTYPBP Rolenvarchar60
3RTP_US_BP_PLANBusiness partners associated with a retirement plan5RLTYPBP Rolenvarchar60
4TRTP_US_BP_EDSpecial business partner roles for an ESA2RLTYPBP Rolenvarchar60
TOPBusiness Partner
5BPFRGOBSOLETE TABLE: Business Partner: Roles for Release5RLTYPBDT: Object partnvarchar60
6BPOBTABPartner-Object Relationship5RLTYPBP Rolenvarchar60
7BPTC03Contract - Role Category Link in Total Commitment5RLTYPBusiness Partner Role for Applicationnvarchar60
8TIVBPGRPCCBusiness Partner Grouping per Company Code5RLTYPBusiness Partner: Rolenvarchar60
9TP23SControl Table for Differentiation Type Criterion3RLTYPBP Role Categorynvarchar60
10TP46Roles Permitted in Application3RLTYPBusiness Partner Role for Applicationnvarchar60
11TP46TName of Permissible BP Role in Application4RLTYPBusiness Partner Role for Applicationnvarchar60
12TP47Assignment of Role in Application to Role Set4RLTYPBusiness Partner Role for Applicationnvarchar60
13TPR5Partner Object Relationship: Application Cat. - Role Cat. I4RLTYPBP Role Categorynvarchar60
14TPR6Partner Object Relationship: Application Cat. - Role Cat. II4RLTYPBP Role Categorynvarchar60
15TPR9Partner Object Relation.: Application Category-Role-Grouping4RLTYPBP Rolenvarchar60
TOPBusiness Partner Enhancements for Financial Services
16BPUM_CTLBusiness partner: Conversion control5RLTYPBP Rolenvarchar60
17TBC002Business Partner Role: Additional Role Definition2RLTYPBP Role Categorynvarchar60
18TBD002Business Partner: Additional Role Definition2RLTYPBP Role Categorynvarchar60
19TP103BP: Field Modification via BP Role Category2RLTYPBusiness Partner Role Categorynvarchar40
20TPZ3BP: Business Partner - Role Category4RLTYPBDT: Object partnvarchar60
21TPZ6BP: Business Partner - Role Type4RLTYPBDT: Object partnvarchar60
TOPClaims Management
22TICL306Participant Role (Display Information)8RLTYPBusiness Partner Rolenvarchar60
TOPContract Accounts Receivable and Payable
23TFK045AReturns table4RLTYPType of returnsnvarchar20
TOPCustomer Contact
24BCONTBusiness Partner Contact6RLTYPBDT: Object partnvarchar60
TOPFunctional Locations
25IRLOTReference Functional Location (Table)5RLTYPReference functional location categorynvarchar10
26T370RReference Functional Location Category2RLTYPReference functional location categorynvarchar10
27T370R_TLanguage-Dependent Texts for T370R3RLTYPReference functional location categorynvarchar10
TOPGlobal Trade Services
28/SAPSLL/BOPHDORGGTS: General Bill of Product - Org. Object Assignment5RLTYPBDT: Object partnvarchar60
29/SAPSLL/PREVDPreference: Long-Term Vendor Declaration - Header4RLTYPPartner Rolenvarchar60
30/SAPSLL/PREVDHPreference: Long-Term Vendor Declaration Header4RLTYPPartner Rolenvarchar60
31/SAPSLL/PRPARLegal and Logistics Services: Product Master - Partner5RLTYPPartner Rolenvarchar60
32/SAPSLL/TORGDAGTS: Organizational Units: Control Data2RLTYPBDT: Object Part (Partner Role)nvarchar60
33/SAPSLL/TPABPLegal & Logistics Services: Business Partner - Control3RLTYPBusiness Partner Rolenvarchar60
34/SAPSLL/USRORGAssignment of Organizational Unit to User3RLTYPBDT: Object partnvarchar60
TOPIncentive and Commission Management ICM
35TCACS_ASSGN1Assignment Table - Commission Application <-> BDT Subobjects4RLTYPBDT: Object partnvarchar60
TOPLoans Management
36TDSUBROLEBP: Business Partner - Role Type3RLTYPBDT: Object partnvarchar60
TOPMaster Data
37BKK45Relationship: Current Account - Business Partner5RLTYPBP Rolenvarchar60
38BKK45_HISTORYHistory Table for Table BKK455RLTYPBP Rolenvarchar60
39BKKOVR_ACCNTItem Table: Accounts with Tolerated Overdraft8RLTYPBP Rolenvarchar60
40GMRMBUPABusiness Partner - Records Management Interface2RLTYPBDT: Object partnvarchar60
41GMRMBUPA_ACTBusiness Partner - Records Management Interface2RLTYPBDT: Object partnvarchar60
42TJG39IS-M/SD: Business Partner Roles10RLTYPBP Role Categorynvarchar60
TOPMedia Product
43JPTBUPAASSIGNIS-M: Assignment of Business Partners to Material4RLTYPBP Rolenvarchar60
44TJPBPVALIDRLTYPIS-M: Valid Role Types for Hierarchy Level4RLTYPBP Rolenvarchar60
TOPOther Functions
45T331CControl of storage type for putaway strategy K5RLTYPReference storage type (fixed bin storage) for reserve stor.nvarchar30
TOPPosition Budgeting and Control
46HRP1512DB Table for Infotype 151218RLTYPRelevance Type of Personnel Budget Plannvarchar50
47T77HRFPM_RELTYPRelevance Types for Personnel Budget Plan2RLTYPRelevance Type of Personnel Budget Plannvarchar50
48T77HRFPM_RELTYPTRelevance Type Text for Personnel Budget Plan3RLTYPRelevance Type of Personnel Budget Plannvarchar50
TOPReal Estate Management
49BPOBIMMOBusiness Partner - Object Relationship: Real Estate5RLTYPBP Rolenvarchar60
TOPSAP Business Partner
50TB044(Obsolete!) Business Partner Roles: Properties3RLTYPSAP BP: Business Partner Rolenvarchar60
51TB044T(Obsolete!) Business Partner Roles: Properties, Texts4RLTYPSAP BP: Business Partner Rolenvarchar60
52TB050Screen Config. (Obsolete from Second Edition VCT)3RLTYPBDT: Object partnvarchar60
53TB060RBDT: Transaction Entry Via Search Screen for Object Parts3RLTYPBDT: Object partnvarchar60
54TB103BDT: Field Grouping for each Object Part3RLTYPBDT: Object partnvarchar60
55TB103_2BDT: Field Grouping per Object Part Part23RLTYPBDT: Object partnvarchar60
56TB103_3BDT: Field Grouping per Object Part Part33RLTYPBDT: Object partnvarchar60
57TB103_4BDT: Field Grouping per Object Part Part43RLTYPBDT: Object partnvarchar60
58TB201BP: Scheduled Changes for each Role (Time-Dependency)3RLTYPBDT: Object partnvarchar60
59TBZ0BDT Object Parts3RLTYPBDT: Object partnvarchar60
60TBZ0CAssign BDT Object Part -> BDT Applications3RLTYPBDT: Object partnvarchar60
61TBZ0FAssign BDT Object Part -> BDT Views3RLTYPBDT: Object partnvarchar60
62TBZ0IAssign BDT Object Part Grouping-> BDT Object Parts4RLTYPBDT: Object partnvarchar60
63TBZ0SBDT Object Part -> BDT Data Sets Assignment3RLTYPBDT: Object partnvarchar60
64TBZ0TBDT Object Parts: Texts4RLTYPBDT: Object partnvarchar60
65TBZ0UAssign BDT Object Part -> BDT Screen Sequences3RLTYPBDT: Object partnvarchar60
66TBZ1EBDT Application Transactions3RLTYPBDT: Object partnvarchar60
TOPTransaction Management
67VTBPAFin. Transaction: Assignment of Further Business Partners5RLTYPBP Rolenvarchar60
TOPTreasury
68TZV07Alloc.of application/role category/dunning parameters12RLTYPBP Rolenvarchar60
TOPUse AP-MD-BP Components
69BUT050BP relationships/role definitions: General data10RLTYPBusiness partner role (change doc.-relevant)nvarchar60
70BUT050SBP Relationships/Role Definitions: General Data11RLTYPBusiness partner role (change doc.-relevant)nvarchar60
71BUT050_CDBP Rel./Role Determination:Index Table for Change Doc.Access9RLTYPBusiness partner role (change doc.-relevant)nvarchar60
72BUT100BP: Roles3RLTYPBP Rolenvarchar60
73TB008Assignment: BP Role -> BP Address Type - OBSOLETE2RLTYPBP Rolenvarchar60
TOPValue Adjustment
74/IBS/CRB_ZGPAPRBD Permitted SAP BP Roles for Aggregation Level Partners3RLTYPRBD: SAP BP Partner Rolenvarchar60
75/IBS/CRB_ZGPDAVSRBD Assignment BP Role to Product Type Source System4RLTYPRBD: SAP BP Partner Rolenvarchar60
TOPWarehouse Management
76LTAPTransfer order item71RLTYPReturn storage typenvarchar30
77T331Storage Type Control14RLTYPReturn storage typenvarchar30
78T333WM Movement Types9RLTYPReturn storage typenvarchar30
TOPWaste Management
79EHSWAC_ROLECheck Table for Disposal Document Roles2RLTYPRole of Waste Management Business Partner for Check Tablenvarchar60
80EHSWAC_ROLETBP Roles: Texts2RLTYPRole of Waste Management Business Partner for Check Tablenvarchar60
81EHSWAC_ROLE_HELPCD: Role-Dependent Elementary Search Helps3RLTYPBusiness Partner Role in Waste Managementnvarchar60
82EHSWAT100MD (BDT): Business Partner Roles16RLTYPBusiness Partner Role in Waste Managementnvarchar60
83EWA_EHSWAV_100EHSWAV_100 Local Table16RLTYPBusiness Partner Role in Waste Managementnvarchar60