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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

138 columns | Print definition?ERP 6.0  | PARVW

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000437KNVP9PARVWnvarchar20
2/CPD/PWSC_WSPROLMaster Project Partner Role3PARVWPartner Functionnvarchar20
3/SMD/MD_____00ZASID-Tabelle fuer Partner Function3PARVWPartner Functionnvarchar20
4/XLSO/ROLE_ASSGNFor assigning partner function after effective date9PARVWUser Rolenvarchar20
5ARBERP_C_PARFUNCDefault Partner Function3PARVWPartner Functionnvarchar20
6EHPRCC_ADRPVWCP: Adress partner function priority4PARVWPartner Functionnvarchar20
7JSDTPAERBusiness Partner: Functions in Partner Determination Proced.3PARVWPartner Functionnvarchar20
8J_1BCTE_PAR_MAPCT-e: Mapping to NF-e Partner Function4PARVWNota Fiscal Partner Functionnvarchar20
9J_3RF_PARTN_ROLEPartner Types for Partner Functions3PARVWPartner Functionnvarchar20
10J_3RF_RGTORG_OUTOutgoing Journal of Acceptance Documents30PARVWPartner function (for example SH for ship-to party)nvarchar20
11TINPASales Documents: Index Updating for Business Partner3PARVWPartner Functionnvarchar20
12TNAPNOutput Control: Output By Partner Function5PARVWPartner Functionnvarchar20
13TPAERBusiness Partner: Functions in Partner Determination Proced.3PARVWPartner Functionnvarchar20
14TPAKDBusiness Partner: Valid Acct Groups per Partner Function2PARVWPartner Functionnvarchar20
15TPAUMBusiness partner: Language conversion for partner functions3PARVWPartner function (not converted)nvarchar20
16TVKBSales Activities : Authorization for Partner Functions3PARVWPartner Functionnvarchar20
TOPAccount Determination
17TPARTBusiness Partner Functions: Texts3PARVWPartner Functionnvarchar20
TOPAdvertising Management
18JHTFPAIS-M/AM: Settlement/Billing Document Item: Partner4PARVWIS-M: Partner Role (Such As BU for Voucher Copy Recipient)nvarchar20
19TJJ89IS-M: Business Partner: Part.Roles in Partner Det.Proc. TPAE3PARVWIS-M: Partner Role (Such As BU for Voucher Copy Recipient)nvarchar20
TOPAgency Business Global Trade
20WBPAAgency Business: Business Partner Assignment4PARVWPartner Functionnvarchar20
TOPBank Customer Accounts
21BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA14PARVWPartner function (e.g. sold-to party, ship-to party, ...)nvarchar30
TOPBasic Functions
22FSLSIForeign Trade: Legal Control - Sanct. Party List - Indices6PARVWPartner Functionnvarchar20
23FSLSTForeign Trade: Legal Control - SLS - Audit Trail8PARVWPartner Functionnvarchar20
24FSLSTAForeign Trade: Legal Control - SLS - Audit Trail8PARVWPartner Functionnvarchar20
25FTCOMTForeign Trade: Communication: Audit table for FT documents10PARVWPartner function (for example SH for ship-to party)nvarchar20
26KNVPCustomer Master Partner Functions6PARVWPartner Functionnvarchar20
27T606PGLegal Control: Partner Functions for Grouping Partners4PARVWPartner Functionnvarchar20
28T610ZForeign Trade: Customs Identification Nos - Vendor/Customer5PARVWPartner Functionnvarchar20
29THITCustomer Hierarchy Types3PARVWInitial partner function in customer hierarchynvarchar20
30TPACHECKASSIGNChecking Module Assignments in SD Partner Processing3PARVWPartner functionnvarchar40
31TVGRPFGroup Referencing Requirement: Fields5PARVWPartner Functionnvarchar20
32VBKOFSD index: Open sales activities by partner function3PARVWPartner Functionnvarchar20
33VBKPASD index: Sales activities by partner function3PARVWPartner Functionnvarchar20
34VBPASales Document: Partner4PARVWPartner Functionnvarchar20
35VBPA2Sales document: Partner (used several times)4PARVWPartner functionnvarchar40
36VBPA3Tax Numbers for One-Time Customers4PARVWPartner Functionnvarchar20
TOPBasis Services Communication Interfaces
37NASTMessage Status7PARVWPartner function (for example SH for ship-to party)nvarchar20
TOPBilling
38VRKPASales Index: Bills by Partner Functions3PARVWPartner Functionnvarchar20
TOPChargeback
39WCOCOPCondition Contract: Partner Assignment4PARVWPartner Functionnvarchar20
TOPConstruction Equipment Management
40/SAPCEM/BD01Planning: Default Values for Requisition Note9PARVWPartner Functionnvarchar20
41/SAPCEM/ZULPARTAllowed Partner Functions per Document Type/Equipment Cat.4PARVWPartner Functionnvarchar20
TOPCredit Management
42T024PCredit Management: Credit Representatives4PARVWPartner Functionnvarchar20
TOPCross-Application Components
43VBBPASales Document: Partner4PARVWPartner Functionnvarchar20
44VVBBPASales Document: Partner4PARVWPartner Functionnvarchar20
45VVBUVSales Document: Incompletion Log5PARVWPartner Functionnvarchar20
46VVVBPASales Document: Partner4PARVWPartner Functionnvarchar20
TOPData Retention Tool
47TXW_S_VBPARetrieve VBPA from archive8PARVWPartner Functionnvarchar20
TOPDealer Portal
48/SAPDII/SPPSHIPAMaintaining Alternate shipping locations5PARVWnvarchar20
TOPDistributor-Reseller-Management
49/SAPHT/DRMCECTYPDRM end customer type2PARVWPartner Functionnvarchar20
50/SAPHT/DRMCPACNVDRM Partner Conversion6PARVWPartner Functionnvarchar20
TOPDownloadUpload
51/DSD/HH_DL_RECOVDSD: Download Recovery6PARVWPartner function (for example SH for ship-to party)nvarchar20
TOPDSD Connector
52/DSD/ME_CONTACTDSD Connector: Contact Person3PARVWDSD Connector: Partner Functionnvarchar20
53/DSD/ME_VIST_HDDSD CN: Customer Visit Header19PARVWContact person functionnvarchar20
TOPElectronic Data Interchange
54EDPARConvert External < > Internal Partner Number3PARVWPartner Functionnvarchar20
55EDPVWPartner Functions Allowed for EDI2PARVWPartner Functionnvarchar20
TOPEmpties Management
56/BEV1/EMLGBWDPEmpties Movement Account Customer14PARVWPartner Functionnvarchar20
TOPEnvironment, Health and Safety
57/TDAG/CPC_ADRPVWCP: Adress partner function priority4PARVWPartner Functionnvarchar20
TOPFinancial Accounting
58J_1AOFNR4SD Billing Type Parameters per country4PARVWPartner Functionnvarchar20
TOPFreight Processing
59TVFTShipment Cost Item Categories4PARVWPartner function for the transportation service agentnvarchar20
60VFKPShipment Costs: Item Data24PARVWPartner Functionnvarchar20
61VFPAPartner for Shipment Costs4PARVWPartner Functionnvarchar20
TOPFunctional Locations
62EAM_D_IHPA_TIMEValidity for Partner Assignment in Plant Maintenance3PARVWPartner Functionnvarchar20
63IHPAPlant Maintenance: Partners3PARVWPartner Functionnvarchar20
TOPIDoc Interfaces for EDI
64PUMAConversion to External Partner Number (outb.)4PARVWPartner function to be convertednvarchar20
TOPIntegration
65FKK_VBPA_SHORTPartner Data for SD Billing Document - Extracts7PARVWPartner Functionnvarchar20
TOPInvoice Verification
66T169BPPartner Allowed as Payment Recipient2PARVWPartner Functionnvarchar20
TOPLine Maintenance
67/ISDFPS/LMSPRELDatabase Table for Sites and Person Relation4PARVWPartner Functionnvarchar20
68/ISDFPS/LM_SPRELDatabase Table for Sites and Person Relation3PARVWPartner Functionnvarchar20
TOPLocalization
69J_1BAANota Fiscal type9PARVWNota Fiscal Partner Functionnvarchar20
70J_1BADPartner function ID2PARVWNota Fiscal Partner Functionnvarchar20
71J_1BADTPartner function description3PARVWNota Fiscal Partner Functionnvarchar20
72J_1BIV02Nota Fiscal type determination6PARVWNota Fiscal Partner Functionnvarchar20
73J_1BNFCPDNota Fiscal one-time accounts3PARVWNota Fiscal Partner Functionnvarchar20
74J_1BNFDOCNota Fiscal Header30PARVWNota Fiscal Partner Functionnvarchar20
75J_1BNFNADNota Fiscal partners3PARVWNota Fiscal Partner Functionnvarchar20
76J_1BSDICASales Document Item Category table6PARVWMain partner function ID (e.g. SH for ship-to party)nvarchar20
TOPLogistics - General
77WBHPTrading Contract: Partner Assignment5PARVWPartner Functionnvarchar20
TOPMaintenance History
78TPAER_PMPartner Functions in Partner Schema (PM) with Copy Flag3PARVWPartner Functionnvarchar20
TOPMaintenance Notifications
79QMSMQuality notification - tasks30PARVWFunction of Person Responsible for Tasknvarchar20
80QMURQuality notification - causes21PARVWFunction for Party Responsiblenvarchar20
81T355E_WResponse times9PARVWFunction of Person Responsible for Tasknvarchar20
82TIH02Field Selection for Partner Addresses2PARVWPartner Functionnvarchar20
TOPMaintenance Orders
83T350Maintenance Control Parameters: Client/Order Type10PARVWPartner Function for Customernvarchar20
TOPMarketing Retail Network
84OIFBRT1Business partner roles - technical category (IS-Oil MRN)7PARVWPartner Functionnvarchar20
85OIFPBLIndex to point at Business Location4PARVWPartner Functionnvarchar20
TOPMaterial Maintenance
86TPARBusiness Partner: Functions2PARVWPartner Functionnvarchar20
TOPMaterials Management
87/SAPNEA/JSC01Subcontracting Global Maintenance5PARVWPartner function ID (e.g. SH for ship-to party)nvarchar20
88OPS_SE_SOC_LOGLog for Service Output Control8PARVWPartner Functionnvarchar20
TOPMedia Product Sales and Distribution
89JKSD_KNVP_PARVWIS-M: Time-Dependent Partner Roles in MPS - Partners8PARVWPartner Functionnvarchar20
90S488Return Quantity Check14PARVWPartner Functionnvarchar20
91S488ES488 - Structure Information9PARVWPartner Functionnvarchar20
TOPOrganizational Flexibility
92/ISDFPS/PM_TPCMPPartner Roles for Weapon System ID3PARVWPartner Functionnvarchar20
93/ISDFPS/PM_TPCROAssignment of Training Program Function to Partner Role4PARVWPartner Functionnvarchar20
94/ISDFPS/PM_TP_OFlight Programs for Order3PARVWPartner Functionnvarchar20
TOPOutput Determination
95NACHDetailed output data13PARVWPartner Functionnvarchar20
96T685BCondition Types: Additional Data for Sending Output14PARVWPartner Functionnvarchar20
TOPPendulum List Indirect Sales
97/BEV4/PLDROLZURole Assignment for Pendulum List3PARVWPartner Functionnvarchar20
TOPPeriodical Sales and Distribution
98JFPAIS-M/SD: Sales Document - Partner4PARVWPartner Functionnvarchar20
99JLPASales Document: Partner4PARVWPartner Functionnvarchar20
TOPPlant Maintenance
100EAMS_CVBPARVWPRIPartner Function priority for searching address3PARVWPartner Functionnvarchar20
TOPProcessing
101EWATSUBCNTCNFWDIConfiguration Subcontractor Handling Waste Disp. Order Item9PARVWPartner Functionnvarchar20
102EWATSUBCNTCNFWDOConfiguration Subcontract. Handling for Waste Disposal Order9PARVWPartner Functionnvarchar20
103TEOBJRESPDef. Partner Roles and Note for Persons Responsible for Obj.3PARVWPartner Functionnvarchar20
TOPProduct Safety
104CCRCC_CDEHS: Rules for Country Determination6PARVWPartner Functionnvarchar20
TOPPurchasing
105EKPAPartner Roles in Purchasing7PARVWPartner Functionnvarchar20
TOPRecycling Administration Core Functions
106J_7LC02REA Company Codes: Common Company Codes41PARVWPartner Functionnvarchar20
107J_7LC09REA Customizing: General Controls32PARVWPartner Functionnvarchar20
108J_7LC50REA Data Filters: Definition Access Sequences for Hierarchy4PARVWPartner Functionnvarchar20
109J_7LC51REA Data Filters: Access Sequences - Accesses7PARVWPartner Functionnvarchar20
TOPRemaining Beverage - Obsolete Objects
110/BEV1/CAZAPDialog Box w. Address Data Partner Function in Order Entry6PARVWPartner Functionnvarchar20
111/BEV1/RBVBPASales Document: Partner, Copy VBPA for Indirect Orders4PARVWPartner Functionnvarchar20
112/BEV1/RBZBEATZMaintain Doc. Type for Doc. Type Change for Virtual Docs7PARVWPartner Functionnvarchar20
113/BEV1/TSSDBTPRCategory Reference for Main Table Statistics Telephone Sales13PARVWPartner Function for Cat. Assignmnt Material Telephone Salesnvarchar20
114/BEV1/TSSSPBGStatistics: Column Definition16PARVWPartner Function for Statistics Column Data Telephone Salesnvarchar20
115/BEV1/TSZTYMAVTTypes/Material Allocation Sales Area8PARVWPartner Function for Cat. Assignmnt Material Telephone Salesnvarchar20
TOPSales
116VAKPASales Index: Orders by Partner Function3PARVWPartner Functionnvarchar20
117VBUVSales Document: Incompletion Log5PARVWPartner Functionnvarchar20
TOPSales Activities
118VBKASales Activities50PARVWPartner Functionnvarchar20
TOPSerial Numbers
119T377Criteria for Material Serial Number Management6PARVWPartner Functionnvarchar20
TOPService Station Retailing
120OIRBBP1PFLocation partner role SD partner functions (IS-Oil SSR)6PARVWPartner Functionnvarchar20
121OIRECHBPAClearing house bus. partner role assignments (IS-Oil MRN)3PARVWPartner Functionnvarchar20
TOPShipping
122VLKPASD Index: Deliveries by Partner Functions3PARVWPartner Functionnvarchar20
TOPSubsequent Settlement
123KOPARebate Arrangement/Partner Assignment3PARVWPartner Functionnvarchar20
TOPTraders and Schedulers Workbench
124TOIJ_BPD_PMAPNomination Partner Communication Partner Mapping6PARVWPartner Functionnvarchar20
TOPTransportation
125VTCFPPFreight Planning Transfer Profile5PARVWPartner Functionnvarchar20
126VTPAShipping Partner4PARVWPartner Functionnvarchar20
TOPTransportation and Distribution
127OIGSPAPartner in TD-shipment4PARVWPartner Functionnvarchar20
TOPVehicle Management System
128VLCDEAENDVELO : Relationship Between Dealer and End Customer3PARVWPartner Functionnvarchar20
TOPVendor Master
129TLHITVendor Hierarchy Category3PARVWInitial partner function, vendor hierarchynvarchar20
130TPAKLAssignment of Partner Function to Account Group Vendor2PARVWPartner Functionnvarchar20
131WYT3Partner Functions6PARVWPartner Functionnvarchar20
TOPWarranty Claim Processing
132B360Rolle4PARVWPartnerrolnvarchar20
133B361Rel.Vers./Partner Type4PARVWPartner Rolenvarchar20
134CWTY001Claim Types Warranty Claim8PARVWDefault Value Partner Function Reimbursernvarchar20
135PNWTYHWarranty Claim Header (PVS Node)19PARVWPartner Rolenvarchar20
136WTY_PARTNER_TABPartner for Warranty Claim3PARVWPartner Rolenvarchar20
TOPWaste Management
137TEWASLOCPARTNERPartner Function for Contact Partner for Container Location2PARVWPartner Functionnvarchar20
138TEWAVHCLPARTNERPartner Function for Business Partner for Vehicle2PARVWPartner Functionnvarchar20