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

91 columns | Print definition?ERP 6.0  | GUELTIGBIS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdvertising Management
1JHTTBEDIS-M/AM: OPM - Rate Requirements7GUELTIGBISIS-M: "Valid To" Datenvarchar80
2JHTVGPZIS-M/AM: Business Partner Assignment to the Contract10GUELTIGBISValid-To Datenvarchar80
3JJTBEBVTPIS-M: Distribution BU Planned Quantities Assignment5GUELTIGBISValid-To Datenvarchar80
4JJTBEVARIIS-M/AM: Ad Insert BU Variants5GUELTIGBISValid-To Datenvarchar80
5JJTBEWSINIS-M/AM: Booking Unit Content for Commercial13GUELTIGBISValid-To Datenvarchar80
6JJTFPLZOLZUOIS-M/AM: Online Fixed Spaces Grouping5GUELTIGBISValid-To Datenvarchar80
7JJTFPLZONLIS-M/AM: Online Fixed Spaces8GUELTIGBISValid-To Datenvarchar80
8JJTKNTKTZHLIS-M: Online Planned Gross Impressions7GUELTIGBISValid-To Datenvarchar80
9JJTKSIS-M/AM: Business Partner Hierarchy6GUELTIGBISValid-To Datenvarchar80
10JJTOBJINIS-M/AM: Planned Production Unit - Content9GUELTIGBISValid-To Datenvarchar80
11JJTVAIncl/Exclusive Sales Agt Requirements for Entire Sales Area7GUELTIGBISIS-M: "Valid To" Datenvarchar80
12JJTVBIS-M/AM: Requirement in Media Sales Agent Contract5GUELTIGBISIS-M: "Valid To" Datenvarchar80
13JJTWSINIS-M/AM: Assignment of Content Components to a BU8GUELTIGBISValid-To Datenvarchar80
14JJTZKIIS-M/AM: Content of Date Combination BU6GUELTIGBISValid-To Datenvarchar80
15TJJKAMPIS-M/AM: Campaign (Customer)7GUELTIGBISValid-To Datenvarchar80
TOPMaster Data
16JSTAENDERIS-M/SD: Change Number for Structure Maintenance4GUELTIGBISIS-M: Date to Which Change Number is Validnvarchar80
17JSTALIASIS-M: Alias Table for Streets33GUELTIGBISValid-To Datenvarchar80
18JSTANDLOGIS-M/SD: Log for Changes to JSTAENDER10GUELTIGBISIS-M: Date to Which Change Number is Validnvarchar80
19JSTBEZBEZIS-M/SD: Assgmt Table for Carrier Route-Carrier Route Assgmt4GUELTIGBISValid-To Datenvarchar80
20JSTCOUNTYIS-M: Counties or Administrative Districts from USPS (USA)6GUELTIGBISValid-To Datenvarchar80
21JSTGEOBEZIS-M/SD: Assignment of Carrier Routes to Geographical Units4GUELTIGBISValid-To Datenvarchar80
22JSTGEOHIEIS-M/SD: Geographical Hierarchy5GUELTIGBISValid-To Datenvarchar80
23JSTGEOORGIS-M/SD: Assignment of Geographical to Organizational Units4GUELTIGBISValid-To Datenvarchar80
24JSTGEOPSTIS-M/SD: Assignments of Geographical to Postal Units6GUELTIGBISValid-To Datenvarchar80
25JSTKGSPROIS-M/SD: District Municipality File19GUELTIGBISValid-To Datenvarchar80
26JSTKGSUPDAIS-M/SD: Table for Upgrade of Table JSTKGSPRO23GUELTIGBISValid-To Datenvarchar80
27JSTLAUFIS-M/SD: Round Sequence9GUELTIGBISValid-To Datenvarchar80
28JSTORGHIEIS-M/SD: Organizational Plan Hierarchy4GUELTIGBISValid-To Datenvarchar80
29JSTORTPROIS-M/SD: City File (Post)25GUELTIGBISValid-To Datenvarchar80
30JSTORTUPDAIS-M/SD: Table for Upgrade of Table JSTORTPRO28GUELTIGBISValid-To Datenvarchar80
31JSTOTLPROIS-M: City District File20GUELTIGBISValid-To Datenvarchar80
32JSTOTLUPDAIS-M/SD: Table for Upgrade of Table JSTOTLPRO24GUELTIGBISValid-To Datenvarchar80
33JSTPLOUPDAIS-M/SD: Table for Upgrade of Table JSTPLZORT22GUELTIGBISValid-To Datenvarchar80
34JSTPLZORTIS-M/SD: Assignment of Postal Codes to Cities17GUELTIGBISValid-To Datenvarchar80
35JSTPLZPROIS-M: Postal Codes23GUELTIGBISValid-To Datenvarchar80
36JSTPLZUPDAIS-M/SD: Table for Upgrade of Table JSTPLZPRO27GUELTIGBISValid-To Datenvarchar80
37JSTPOFPROIS-M/SD: PO Box Rack File24GUELTIGBISValid-To Datenvarchar80
38JSTPOFUPDAIS-M/SD: Table for Upgrade of Table JSTPOFPRO30GUELTIGBISValid-To Datenvarchar80
39JSTROUPVAIS-M/SD: Truck Route-Publication/Edition Assignment7GUELTIGBISValid-To Datenvarchar80
40JSTSTRPROIS-M/SD: Street File (Post)34GUELTIGBISValid-To Datenvarchar80
41JSTSTRUPDAIS-M/SD: Table for Upgrading Table JSTSTRPRO36GUELTIGBISValid-To Datenvarchar80
42JST_KGS_CONSIS-M: Table for DMK Consolidation24GUELTIGBISValid-To Datenvarchar80
43JST_ORT_CONSIS-M: Table for City Consolidation30GUELTIGBISValid-To Datenvarchar80
44JST_OTL_CONSIS-M: Table for City District Consolidation28GUELTIGBISValid-To Datenvarchar80
45JST_PLZ_CONSIS-M: Table for Postal Code Consolidation28GUELTIGBISValid-To Datenvarchar80
46JST_POF_CONSIS-M: Table for PO Box Consolidation33GUELTIGBISValid-To Datenvarchar80
47JST_STR_CONSIS-M: Table for Street Consolidation38GUELTIGBISValid-To Datenvarchar80
TOPPeriodical Sales and Distribution
48JDTPVAWGRPIS-M/SD: Edition Plant Assignment to Bundle Group6GUELTIGBISValid-To Datenvarchar80
49JKAPSales Order - Item Data5GUELTIGBISDate to which Sales Order Item is Validnvarchar80
50JKAP_INACTIVEPublishing Sales Order: Inactive Item Data6GUELTIGBISDate to which Sales Order Item is Validnvarchar80
51JKEPSales Order: Schedule Line Data6GUELTIGBISDate to Which Schedule Line in Sales Order is Validnvarchar80
52JKPASales Order: Partner7GUELTIGBISDate to Which Partner Data in Sales Order is Validnvarchar80
53JKPAZSales Order Item: Additional Planning Data9GUELTIGBISValid To Date of Order-Deliv.Via.Assgmt for Sales Ord.Itemnvarchar80
54JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data6GUELTIGBISValid-To Datenvarchar80
55JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet65GUELTIGBISValid-To Datenvarchar80
56JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data6GUELTIGBISValid-To Datenvarchar80
57JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet49GUELTIGBISDate to which Sales Order Item is Validnvarchar80
58JKWWWTEMP_SUSPIS-M: Temporary Internet Table: Suspension Data6GUELTIGBISValid-To Datenvarchar80
59JKWWWTEMP_TRNSFIS-M: Internet Temporary Table: Transfer Data6GUELTIGBISValid-To Datenvarchar80
60JKWWW_PROTOCOLIS-M: Table for Logging Creation/Changes made with IACs13GUELTIGBISValid-To Datenvarchar80
61JRTABLDBARIS-M/SD: Unloading Viability Set5GUELTIGBISValid-To Datenvarchar80
62JRTABLRGLIS-M/SD: Unloading Rule (no longer used)14GUELTIGBISValid-To Datenvarchar80
63JRTABLRGLAIS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes)5GUELTIGBISValid-To Datenvarchar80
64JRTABLRGLBIS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts)5GUELTIGBISValid-To Datenvarchar80
65JRTBEABSTIS-M/SD: Unloading Point4GUELTIGBISValid-To Datenvarchar80
66JRTROUBEAIS-M/SD: Truck Route Unloading Point Sequence4GUELTIGBISValid-To Datenvarchar80
67JRTROUHIEIS-M/SD: Truck Route Hierarchy5GUELTIGBISValid-To Datenvarchar80
68JRTRVERTIS-M/SD: Truck Route Contract3GUELTIGBISValid-To Datenvarchar80
69JRTRVPOSIS-M/SD: Item in Truck Route Contract5GUELTIGBISValid-To Datenvarchar80
70JVTBEZGPIS-M/SD: Delivery Round - Business Partner9GUELTIGBISValid-To Datenvarchar80
71JVTLIEFBARIS-M/SD: Delivery/Home Delivery/Pickup Viability Sets4GUELTIGBISValid-To Datenvarchar80
72JVTMC_HH_SUSPENDIS-M: TMC - Explicit Exclusion of Households6GUELTIGBISValid-To Datenvarchar80
73JVTNCT4IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS9GUELTIGBISValid To Date of Order-Deliv.Via.Assgmt for Sales Ord.Itemnvarchar80
74JVTNCT5IS-M/SD: Tab.5 in Collective Netchange File (Sch.Line ChNo.)9GUELTIGBISDate to Which Schedule Line in Sales Order is Validnvarchar80
75JVTPSHFINDIS-M/SD: Production Procedure Determination4GUELTIGBISValid-To Datenvarchar80
76JVTPSTFEHLIS-M/SD: Postal Units not Delivered7GUELTIGBISValid-To Datenvarchar80
77JVTVARTIMEIS-M/SD: Time Slice Variant4GUELTIGBISValid-To Datenvarchar80
78JVTVERPLANIS-M/SD: Shipping Schedule14GUELTIGBISValid-To Datenvarchar80
79JVTZAEM1IS-M/SD: Carrier Change Notification - Order Change9GUELTIGBISValid-To Datenvarchar80
80JWBASIIS-M/SD: Campaign Framework8GUELTIGBISEnd of Validity of Campaign Frameworknvarchar80
81JYTREORGIS-M/SD: Reorganization Periods and Areas13GUELTIGBISValid-To Datenvarchar80
82JYTSTREORGIS-M/SD: Reorganization Status11GUELTIGBISValid-To Datenvarchar80
83TJIABCZONESDefinition of ABZ Zones per Edition8GUELTIGBISTonvarchar80
84TJL29IS-M/SD: Postal Settlement Types4GUELTIGBISValid-To Datenvarchar80
85TJLPBIS-M/SD: Assign Insert Data to Postal Settlement NUubers8GUELTIGBISValid-To Datenvarchar80
86TJLPTIS-M/SD: Assgt of Carrying Issue Data to Postal Settlemt Nos6GUELTIGBISValid-To Datenvarchar80
87TJWAKIS-M/SD: Sales Promotion4GUELTIGBISEnd of Validity of Sales Promotionnvarchar80
TOPSAP Media
88J_1SBOTPROIS-M/SD CH/S: CH Carrier Data9GUELTIGBISIS-M: CH/S: Validity Datenvarchar80
89J_1SSTRKUNIS-M/SD CH/S: Assign Street Data for Individual Customers41GUELTIGBISValid-To Datenvarchar80
90J_1SSUPBESTANDIS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet46GUELTIGBISValid-To Datenvarchar80
91J_1S_AENDIS-M/SD CH/S: Orders Affected by Change Number14GUELTIGBISValid-To Datenvarchar80