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

84 columns | Print definition?ERP 6.0  | PARNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000436KNVK5PARNRnvarchar100
2CNV_20800_KNVKCNV backup copy: Customer master contact person3PARNRNumber of contact personnvarchar100
3EHPRCD_ADRPDCP: expanded data for personal partner2PARNRNumber of contact personnvarchar100
4J_3RF_RGTORG_OUTOutgoing Journal of Acceptance Documents29PARNRMessage partnernvarchar100
5KCONSConsent Data: Consent data provided for legal entity9PARNRNumber of contact personnvarchar100
6T001ECompany Code-Dependent Address Data6PARNRNumber of contact personnvarchar100
TOPAccounts Receivable Accounting Process Integration
7FDM_CONTACT_BUFPersonalization of Contact Person Data6PARNRNumber of contact personnvarchar100
TOPAdvertising Management
8JHAGPZIS-M/AM: Assign Business Partner to Order and Item18PARNRIS-M: Contact Personnvarchar100
9JHAKIS-M/AM: Order-Publishing-Media (Header Data)112PARNRIS-M: Contact Personnvarchar100
10JHAPIS-M/AM: Order-Publishing-Media Item123PARNRIS-M: Contact Personnvarchar100
11JHTFPAIS-M/AM: Settlement/Billing Document Item: Partner9PARNRNumber of contact personnvarchar100
12JJTAFIS-M/AM: Free Subscription for Media Contact Person3PARNRIS-M: Contact Personnvarchar100
13JJTAMIS-M/AM: Media Contact Person3PARNRIS-M: Contact Personnvarchar100
14JJTAZIS-M/AM: Media Contact Person Responsibility3PARNRIS-M: Contact Personnvarchar100
TOPAgency Business Global Trade
15WBPAAgency Business: Business Partner Assignment11PARNRNumber of contact personnvarchar100
TOPBank Customer Accounts
16BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA121PARNRContact person's number (not personnel number)nvarchar300
TOPBasic Functions
17FTCOMTForeign Trade: Communication: Audit table for FT documents9PARNRMessage partnernvarchar100
18KNVPCustomer Master Partner Functions11PARNRNumber of contact personnvarchar100
19VBPASales Document: Partner8PARNRNumber of contact personnvarchar100
TOPBasis Services Communication Interfaces
20NASTMessage Status6PARNRMessage partnernvarchar100
TOPCATT Computer Aided Test Tool
21CATUCATT variants3PARNRCATT - Param. Inn, Text var. Tnn, Ext. file Xnnnvarchar30
22CATVCATT: Variable Texts3PARNRCATT - Param. Inn, Text var. Tnn, Ext. file Xnnnvarchar30
TOPChargeback
23WCOCOPCondition Contract: Partner Assignment12PARNRNumber of contact personnvarchar100
TOPClinical System
24N1DCS_AGR_RANGEDCS: Quick Entry of Settings for Roles (Ranges)5PARNRSequential Number of Parameternvarchar30
25N1DCS_OUIS-H*med: DCS: OU-Related Quick Entry Control5PARNRSequential Number of Parameternvarchar30
26N1DCS_USRIS-H*med: DCS: Quick Entry: Settings for User5PARNRSequential Number of Parameternvarchar30
27N1DCS_USR_RANGEIS-H*MED: DCS: Quick Entry User Settings (Ranges)5PARNRSequential Number of Parameternvarchar30
TOPCross-Application Components
28ETP_PARTNERTask Partner4PARNRTask Partnernvarchar120
29SKNVKCustomer Master Contact table for BC417 Course2PARNRNumber of contact personnvarchar100
30VBBPASales Document: Partner8PARNRNumber of contact personnvarchar100
31VVBBPASales Document: Partner8PARNRNumber of contact personnvarchar100
32VVVBPASales Document: Partner8PARNRNumber of contact personnvarchar100
TOPCustomer Master
33KNVKCustomer Master Contact Partner2PARNRNumber of contact personnvarchar100
TOPDownloadUpload
34/DSD/HH_DL_RECOVDSD: Download Recovery5PARNRMessage partnernvarchar100
TOPDSD Connector
35/DSD/ME_CONTACTDSD Connector: Contact Person4PARNRDSD Connector: Customer Numbernvarchar100
36/DSD/ME_VIST_HDDSD CN: Customer Visit Header20PARNRNumber of contact personnvarchar100
TOPEnvironment, Health and Safety
37/TDAG/CPT_ADRPDCP: expanded data for personal partner2PARNRNumber of contact personnvarchar100
TOPFreight Processing
38VFPAPartner for Shipment Costs8PARNRNumber of contact personnvarchar100
TOPFunctional Locations
39IHPAPlant Maintenance: Partners6PARNRPartnernvarchar120
TOPGlobal Trade Services
40/SAPSLL/PARMAGTS: Partner Mapping11PARNRPartner Identification in Partner Systemnvarchar400
TOPIDoc Interfaces for EDI
41PUMAConversion to External Partner Number (outb.)5PARNRPartner number to be convertednvarchar100
TOPInvestment Programs
42IMPRInvestment Program Positions28PARNRParent position numbernvarchar80
TOPLine Maintenance
43/ISDFPS/LMSPRELDatabase Table for Sites and Person Relation3PARNRPartnernvarchar120
44/ISDFPS/LM_SPRELDatabase Table for Sites and Person Relation2PARNRPartnernvarchar120
TOPLogistics - General
45WBHPTrading Contract: Partner Assignment12PARNRNumber of contact personnvarchar100
TOPMaintenance Notifications
46QMSMQuality notification - tasks31PARNRPerson Responsible for Task (Partner Number)nvarchar120
47QMURQuality notification - causes22PARNRParty Responsible for Cause (Partner Number)nvarchar120
48T355E_WResponse times10PARNRPerson Responsible for Task (Partner Number)nvarchar120
TOPMaterials Management
49OPS_SE_SOC_LOGLog for Service Output Control7PARNRPartner numbernvarchar100
TOPMessages
50DNOD_NOTIF_PPartner5PARNRPartner Numbernvarchar120
TOPNon-Ferrous Metal enhancements
51/NFM/TABEINPermitted Different Coverage Customer4PARNRPartner Numbernvarchar100
52/NFM/TCOVHISCoverage History4PARNRPartner Numbernvarchar100
53/NFM/TCOVMASCoverage Master4PARNRPartner Numbernvarchar100
54/NFM/TDEF_DIFFDifferent Rate Determination5PARNRCustomer Numbernvarchar100
55/NFM/TPROVHISProvision: History4PARNRPartner Numbernvarchar100
56/NFM/TPROVLIFProvision Master: Vendor4PARNRPartner Numbernvarchar100
57/NFM/TPROVMASProvision Master4PARNRPartner Numbernvarchar100
58/NFM/TPROVMOVProvision: Goods Movement8PARNRPartner Numbernvarchar100
59/NFM/TVGWNFK Charge Weights for Materials on Organizational Level2PARNRPartner Numbernvarchar100
60/NFM/TVGW_TMPFile for Incorrect Data in Direct Input5PARNRPartner Numbernvarchar100
TOPOrganizational Flexibility
61/ISDFPS/PM_TP_OFlight Programs for Order4PARNRPartnernvarchar120
TOPOutput Determination
62NACHDetailed output data14PARNRMessage partnernvarchar100
TOPPension fund General Parts
63T5CBOAdditional Selection Parameters for Reports5PARNRHR-CH: Number of additional selection parameternvarchar10
TOPPeriodical Sales and Distribution
64JKPASales Order: Partner11PARNRNumber of contact personnvarchar100
65JLPASales Document: Partner8PARNRNumber of contact personnvarchar100
TOPProfile Maintenance
66TPFESPrototype: Table for profile parameters4PARNRConsecutive number of parameter in profilenvarchar40
67TPFETTable of profile parameters4PARNRConsecutive number of parameter in profilenvarchar40
TOPPurchasing
68EKPAPartner Roles in Purchasing14PARNRNumber of contact personnvarchar100
TOPRemaining Beverage - Obsolete Objects
69/BEV1/RBVBPASales Document: Partner, Copy VBPA for Indirect Orders8PARNRNumber of contact personnvarchar100
70/BEV1/TSSEQSales Routes Sequence Numbers7PARNRNumber of contact personnvarchar100
71/BEV1/TSZKKCyclical Customer Sales Activities for Telephone Sales7PARNRNumber of contact personnvarchar100
72/BEV1/TSZKKSTelephone Sales: Changes to Planned Sales Activities7PARNRNumber of contact personnvarchar100
TOPReturnable Packaging Logistics
73RLACCTReturnable packaging account19PARNROutput Partnernvarchar100
TOPSAP Business Workflow
74WFPRCWorkflow: Process object: Definition6PARNRWorkflow: Parent process: Process numbernvarchar160
TOPService Station Retailing
75OIRBBP1PFLocation partner role SD partner functions (IS-Oil SSR)10PARNRNumber of contact personnvarchar100
TOPSubsequent Settlement
76KOPARebate Arrangement/Partner Assignment7PARNRNumber of contact personnvarchar100
TOPTransportation
77VTPAShipping Partner8PARNRNumber of contact personnvarchar100
TOPTransportation and Distribution
78OIGSPAPartner in TD-shipment8PARNRNumber of contact personnvarchar100
TOPVendor Master
79WYT3Partner Functions13PARNRNumber of contact personnvarchar100
TOPVisit Control
80/DSD/VC_VLPDSD: Visit List - Item Data12PARNRNumber of contact personnvarchar100
81/DSD/VC_VPPDSD: Visit Schedule - Item Data14PARNRNumber of contact personnvarchar100
TOPWarranty Claim Processing
82CWTY001Claim Types Warranty Claim9PARNRDefault Value Partner Reimbursernvarchar100
83PNWTYHWarranty Claim Header (PVS Node)18PARNRPartnernvarchar100
84WTY_PARTNER_TABPartner for Warranty Claim4PARNRPartnernvarchar100