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
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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

150 columns | Print definition?ERP 6.0  | PSTYV

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data104PSTYVSales document item categorynvarchar40
2/1RA/0SD012MIItems for Class SD01 - Processable57PSTYVSales document item categorynvarchar40
3/1RA/0SD014MIItems for Class SD01 - Processed57PSTYVSales document item categorynvarchar40
4/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item84PSTYVnvarchar40
5/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule78PSTYVnvarchar40
6/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.52PSTYVnvarchar40
7/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item74PSTYVnvarchar40
8/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item78PSTYVnvarchar40
9/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.59PSTYVnvarchar40
10/CEECV/BVLO_SPLISettings for Document Splitting (Latvia)3PSTYVSales document item categorynvarchar40
11EWATORDERDMRPOSAdditional Items for Follow-On Document7PSTYVSales document item categorynvarchar40
12FARRIC_IT_REVTYPItem Settings for Revenue Accounting4PSTYVSales document item categorynvarchar40
13HUPHPF_SIGNPHPF Sign Determination table3PSTYVSales document item categorynvarchar40
14J_1A_WS_DATA_MAPAR WS RG2904: Array Item Data mapping4PSTYVSales document item categorynvarchar40
15T184Sales Documents: Item Category Determination6PSTYVDefault item category for the documentnvarchar40
16T184LSales Documents: Item Category Determination6PSTYVDefault item category for deliverynvarchar40
17T605ZForeign Trade: Proposal for Bus. Transaction Type in Export5PSTYVSales document item categorynvarchar40
18T616ZForeign Trade: Proposal for Procedure in Export7PSTYVSales document item categorynvarchar40
19TPTDASD: Exclusion of Item Categories for Printing SD Documents4PSTYVSales document item categorynvarchar40
20TVCPLDeliveries: Copying Control4PSTYVReference item categorynvarchar40
21TVEPZSales Document: Schedule Line Category Determination2PSTYVSales document item categorynvarchar40
22ZEIM_LIPSSD document: Delivery: Item data4PSTYVDelivery item categorynvarchar40
23ZEIM_VBAPSales Document: Item Data10PSTYVSales document item categorynvarchar40
TOPAdvertising Management
24/NAM/TJHCCBUNDLECredit Card Bundling - Access Sequence6PSTYVIS-M: Item Category for Sales Documentnvarchar40
25JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset13PSTYVIS-M: Item Category for Sales Documentnvarchar40
26JHAPIS-M/AM: Order-Publishing-Media Item5PSTYVIS-M: Item Category for Sales Documentnvarchar40
27JHAREV1IS-M/AM: Order Revenue Recognition Key Date Values63PSTYVIS-M: Item Category for Sales Documentnvarchar40
28JHAREV3IS-M/AM: Order Revenue Recognition Key Date Quantities60PSTYVIS-M: Item Category for Sales Documentnvarchar40
29JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition60PSTYVIS-M: Item Category for Sales Documentnvarchar40
30JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties57PSTYVIS-M: Item Category for Sales Documentnvarchar40
31JHTFPIS-M/AM: Billing/Settlement Documents - Item69PSTYVIS-M: Item Category for Sales Documentnvarchar40
32JHTVABRUFIS-M/AM: Contract Access38PSTYVIS-M: Item Category for Sales Documentnvarchar40
33JHTVBPOIS-M/AM: Contract Requirement Element10PSTYVIS-M: Item Category for Sales Documentnvarchar40
34JJTPCAUPackage: Ad - Upselling Values5PSTYVIS-M: Item Category for Sales Documentnvarchar40
35JJTPCDUPackage: Service - Upselling Values5PSTYVIS-M: Item Category for Sales Documentnvarchar40
36JJTPCEAPackage Elements: Ad4PSTYVIS-M: Item Category for Sales Documentnvarchar40
37JJTPCEAAPackage Elements: Ad - Admissible Values6PSTYVIS-M: Item Category for Sales Documentnvarchar40
38JJTPCEDPackage Elements: Service4PSTYVIS-M: Item Category for Sales Documentnvarchar40
39JJTPCEDAPackage Elements: Service - Admissible Values6PSTYVIS-M: Item Category for Sales Documentnvarchar40
40JJTPCEOPackage Elements: Online4PSTYVIS-M: Item Category for Sales Documentnvarchar40
41JJTPCEOAPackage Elements: Online - Admissible Values6PSTYVIS-M: Item Category for Sales Documentnvarchar40
42JJTPCESPackage Elements: Ad Insert4PSTYVIS-M: Item Category for Sales Documentnvarchar40
43JJTPCESAPackage Elements: Ad Insert - Admissible Values6PSTYVIS-M: Item Category for Sales Documentnvarchar40
44JJTPCEVPackage Elements: Distribution4PSTYVIS-M: Item Category for Sales Documentnvarchar40
45JJTPCEVAPackage Elements: Distribution - Admissible Values6PSTYVIS-M: Item Category for Sales Documentnvarchar40
46JJTPCEWPackage Elements: Commercial4PSTYVIS-M: Item Category for Sales Documentnvarchar40
47JJTPCEWAPackage Elements: Commercial - Admissible Values6PSTYVIS-M: Item Category for Sales Documentnvarchar40
48JJTPCOUPackage: Online - Upselling Values5PSTYVIS-M: Item Category for Sales Documentnvarchar40
49JJTPCSUPackage: Ad Insert - Upselling Values5PSTYVIS-M: Item Category for Sales Documentnvarchar40
50JJTPCVUPackage: Distribution - Upselling Values5PSTYVIS-M: Item Category for Sales Documentnvarchar40
51JJTPCWUPackage: Commercial - Upselling Values5PSTYVIS-M: Item Category for Sales Documentnvarchar40
52TJH09IS-M/AM: Order-Related Billing Type Determination5PSTYVIS-M: Item Category for Sales Documentnvarchar40
53TJHADIS-M/AM: Control Document Flow in the Order3PSTYVIS-M: Item Category for Sales Documentnvarchar40
54TJHAPIS-M/AM: Order-Publishing-Media: Item Categories2PSTYVIS-M: Item Category for Sales Documentnvarchar40
55TJHAPKCOPYPackage: Item Category and Target Item Category Assignment4PSTYVIS-M: Item Category for Sales Documentnvarchar40
56TJHAPKITMCATASSPackage and Package Element Item Category Assignment5PSTYVIS-M: Item Category for Sales Documentnvarchar40
57TJHAPTIS-M/AM: Item Category Texts3PSTYVIS-M: Item Category for Sales Documentnvarchar40
58TJHCC_1IS-M/AM: Payment cards: Assign checking group to SArea/ItCat5PSTYVIS-M: Item Category for Sales Documentnvarchar40
59TJHPSFIS-M/AM: Order Item Procedure Determination3PSTYVIS-M: Item Category for Sales Documentnvarchar40
60TJHRRAssign Revenue Recognition Category to Each Item Type/Categ.3PSTYVIS-M: Item Category for Sales Documentnvarchar40
61TJHWWW_JHAWIS-M/AM: Enter Classified Ad IAC: General Settings9PSTYVIS-M: Item Category for Sales Documentnvarchar40
62TJJV17IS-M: Control Contract Determination for Order Billing5PSTYVIS-M: Item Category for Sales Documentnvarchar40
TOPBasic Functions
63EIPOForeign Trade: Export/Import: Item Data93PSTYVSales document item categorynvarchar40
64TVAPSales Document: Item Categories2PSTYVSales document item categorynvarchar40
65TVAPTSales document item categories: Texts3PSTYVSales document item categorynvarchar40
66TVCPASales Documents: Copying Control6PSTYVReference item categorynvarchar40
67TVLPDeliveries: Item Categories2PSTYVDelivery item categorynvarchar40
68TVLPAIPDetermine Item Category for Delivery Creation Using BAPI6PSTYVSales document item categorynvarchar40
69TVLRCheck Table - Sequence of Activities in the Delivery3PSTYVDelivery item categorynvarchar40
70TVPTSales documents: Item categories2PSTYVSales document item categorynvarchar40
TOPBasic functions
71VEKPHandling Unit - Header Table50PSTYVSales document item categorynvarchar40
72VEPOPacking: Handling Unit Item (Contents)26PSTYVSales document item categorynvarchar40
TOPBasis Components
73ZDS400_VBAPTabelle für Beispielprogramm des ZDS40010PSTYVPositionstyp Vertriebsbelegnvarchar40
74ZSALES_ORD_ITEMSales Order Item(IDES Demo)6PSTYVSales document item categorynvarchar40
TOPBilling
75TVCPFBilling: Copying Control6PSTYVReference item categorynvarchar40
76VBRPBilling Document: Item Data36PSTYVSales document item categorynvarchar40
TOPBulk Distribution Requirements Planning
77OIISOCVB2SOC: Enable tank ID entry by sales doc item category2PSTYVSales document item categorynvarchar40
TOPComplaints and Returns
78/SPE/RET_DLV_BWADelivery movement type determination for SPE returns2PSTYVDelivery item categorynvarchar40
TOPComplaints Processing
79CMP_POSTYPItem Category Customizing Complaints Proc. Credit Memo Item3PSTYVSales document item categorynvarchar40
TOPContract Handling
80C402Item cat.5PSTYVSales document item categorynvarchar40
TOPCross-Application Components
81VVBAPSales Document: Item Data10PSTYVSales document item categorynvarchar40
TOPData Collection
82S260SD - Sales order34PSTYVSales document item categorynvarchar40
83S260BIW1SD - Sales order34PSTYVSales document item categorynvarchar40
84S260BIW2SD - Sales order34PSTYVSales document item categorynvarchar40
85S261SD - Delivery note46PSTYVSales document item categorynvarchar40
86S261BIW1SD - Delivery note46PSTYVSales document item categorynvarchar40
87S261BIW2SD - Delivery note46PSTYVSales document item categorynvarchar40
88S262SD - Billing document39PSTYVSales document item categorynvarchar40
89S262BIW1SD - Billing document39PSTYVSales document item categorynvarchar40
90S262BIW2SD - Billing document39PSTYVSales document item categorynvarchar40
91S264SD- Offer36PSTYVSales document item categorynvarchar40
92S264BIW1S264BIW1 * SD - Quotation36PSTYVSales document item categorynvarchar40
93S264BIW2S264BIW2 * SD - Quotation36PSTYVSales document item categorynvarchar40
TOPData Retention Tool
94TXW_S_LIPSRetrieve LIPS from archive7PSTYVDelivery item categorynvarchar40
95TXW_S_VBRPRetrieve VBRP from archive11PSTYVSales document item categorynvarchar40
TOPDown Payment Chains
96/SAPPCE/TDPCSOCustomization table for assigning SO Position to DPC2PSTYVSales document item categorynvarchar40
TOPDSD Connector
97/DSD/ME_DEL_ITMDSD CN: Delivery Items5PSTYVDSD Connector: Item Categorynvarchar40
TOPEmpties Management
98/BEV1/EMDRKKZItem Categories That Are Not Printed2PSTYVSales document item categorynvarchar40
99/BEV1/EMPTYPEmpties: Item Categories3PSTYVSales document item categorynvarchar40
TOPExchanges
100OIA11Exchange assignment for deliveries18PSTYVDelivery item categorynvarchar40
TOPExcise Duty
101/BEV2/ED920Item Categories Relevant for Excise Duty - Returns2PSTYVSales document item categorynvarchar40
102/BEV2/EDMSEExcise Duty Document Table48PSTYVSales document item categorynvarchar40
TOPIntegration
103FKK_VBRP_SHORTItem Data for SD Billing Document - Extracts7PSTYVSales document item categorynvarchar40
TOPInterface to Terminal Automation System
104TOIKTPIRTAS - TPI Relevance Definition3PSTYVSales document item categorynvarchar40
TOPLocalization
105J_1BNFE_PROCSettings for NF-e Business Processes5PSTYVDefault item category for deliverynvarchar40
106J_1BSDICNF relevant Item Categories3PSTYVSales document item categorynvarchar40
107J_1BSDICASales Document Item Category table3PSTYVSales document item categorynvarchar40
108J_1BSDTL1Tax Law ICMS3PSTYVSales document item categorynvarchar40
109J_1BSDTL2Tax Law IPI3PSTYVSales document item categorynvarchar40
110J_1BSDTXCSD Tax code determination3PSTYVSales document item categorynvarchar40
TOPLogistics - General
111TB2BJTrading Contract: Item Categories3PSTYVSales document item categorynvarchar40
TOPMedia Product Sales and Distribution
112JKSDORDERINDEXIndex Table for IS-M Orders27PSTYVSales document item categorynvarchar40
113JKSDT_SD_CON_GENIS-M: Table for Generating Contracts11PSTYVSales document item categorynvarchar40
114JKSECONTRINDEXIndex Table for IS-M Contracts5PSTYVSales document item categorynvarchar40
115JKSESUBPRICESETOIS-M: Dynamic Price Group - Allowed Order Types4PSTYVSales document item categorynvarchar40
116S485IS-M: Sales Figures9PSTYVSales document item categorynvarchar40
117S485ES485 - Structure Information4PSTYVSales document item categorynvarchar40
118S488Return Quantity Check16PSTYVSales document item categorynvarchar40
119S488ES488 - Structure Information11PSTYVSales document item categorynvarchar40
120TJKSD01IS-M/SD: Allowed Item Categories3PSTYVSales document item categorynvarchar40
121TJKSDCICORDPSTYVDetermine Allowed Item Categories in CIC7PSTYVSales document item categorynvarchar40
122TJKSDQCHIDDETAILProcedure Details for Quantity Check4PSTYVItem Category for Return Quantity Check Procedurenvarchar40
123TJKSDSFQUANIDefinition of Calculation Rule - Item Data6PSTYVItem Category of Calculation Rules for Sales Key Figuresnvarchar40
124TJKSESUBIS-M: Subscription Item3PSTYVSales document item categorynvarchar40
125TJVSDTPAUARTAllowed Order Types for Transportation Planning3PSTYVSales document item categorynvarchar40
126TJVSDWLAUARTAllowed Order Types for Shipping Planning3PSTYVSales document item categorynvarchar40
TOPPeriodical Sales and Distribution
127TJI06IS-M/SD: Basic Audit Report Category Default - Media Product3PSTYVSales document item categorynvarchar40
128TJKSD03IS-M: Control Parameters for Purchase Quantity Planning3PSTYVSales document item categorynvarchar40
129TJMSD2SDIS-M/SD: Customizing Settings for LES Interface5PSTYVSales document item categorynvarchar40
TOPPOS Interface
130TWPIBTransaction-type-based control of sales as per receipts POS12PSTYVItem categorynvarchar40
131TWPIRGeneral control of upload of sales as per receipts POS12PSTYVItem categorynvarchar40
132TWPISPOS interface: profile for internal interfaces12PSTYVItem categorynvarchar40
133TWPIVGeneral control of aggregated sales upload POS12PSTYVItem categorynvarchar40
TOPRecycling Administration Core Functions
134J_7LC28REA Data Filter: Sales Document Item Category3PSTYVSales document item categorynvarchar40
135J_7LVBRPOSNON-SD Interface: Billing: Item Data11PSTYVSales document item categorynvarchar40
TOPRemaining Beverage - Obsolete Objects
136/BEV1/RBVBAPSales Document: Item Data10PSTYVSales document item categorynvarchar40
137/BEV1/REPOSTYPItem Categories for Rental Items2PSTYVSales document item categorynvarchar40
138/BEV1/RSPTYItem Categories for Route Settlement2PSTYVSales document item categorynvarchar40
139/BEV3/CHCIVRG01CI: Customizing Business Process Detail 00016PSTYVSales document item categorynvarchar40
140/BEV3/CH_DRPOSGRPrint Groups Item Categories2PSTYVSales document item categorynvarchar40
TOPSales
141VBAPSales Document: Item Data10PSTYVSales document item categorynvarchar40
TOPSales Returns
142/BEV1/SRBSTYAssignment of BVS to Item Categories5PSTYVSales document item categorynvarchar40
TOPSelf-Billing Proced.
143VSBPLGProcessing Log: Self-Billing Procedure w. Autom. Postings13PSTYVSales document item categorynvarchar40
TOPShipping
144LIPSSD document: Delivery: Item data4PSTYVDelivery item categorynvarchar40
TOPSimulation
145VSVBAP_CNVersion: Sales document: Item data11PSTYVSales document item categorynvarchar40
TOPSpare Part Sharing and Stock Providede by Customer
146DIPCS_POOL1Administration of Serial Numbers in Sales Documents3PSTYVSales document item categorynvarchar40
TOPSupply Chain Management
147TCM_C_SLS_MAPMapping TM Organizational Unit to Sales Organisation16PSTYVSales document item categorynvarchar40
148TCM_ORG_SLS_MAPMapping TCM Organizational unit to sales organisation15PSTYVSales document item categorynvarchar40
TOPTraders and Schedulers Workbench
149TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents27PSTYVSales document item categorynvarchar40
TOPVehicle Space Optimization
150/VSO/R_RELRelevance of the Delivery Item Categories for VSO2PSTYVDelivery item categorynvarchar40