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

109 columns | Print definition?ERP 6.0  | CUSTOMER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_MP_HDRMaster Project Header8CUSTOMERCustomer Numbernvarchar100
2/IXOS/DC_EX_ADDRAddresses of a customer2CUSTOMERCustomer numbernvarchar100
3/IXOS/DC_EX_CUST(J_8AGTD71) Customer2CUSTOMERCustomer numbernvarchar100
4/IXOS/DC_EX_LCP(J_8AGTD74) Link customer/product2CUSTOMERCustomer numbernvarchar100
5/IXOS/DC_EX_SRMCustomer Documents2CUSTOMERCustomer numbernvarchar100
6/OPT/AT_APPR_HISApproval History for Level Based Approvals75CUSTOMERCustomer Numbernvarchar100
7/OPT/AT_LBA_LOGApproval History for Level Based Approvals76CUSTOMERCustomer Numbernvarchar100
8ARBERP_D_SI_SOInbound Sales Order versioning for inbound messages3CUSTOMERCustomer Numbernvarchar100
9CMCBD_CONSUMECash Budgeting Consumption35CUSTOMERCustomer Numbernvarchar100
10CNVCMIS_FIELDSExplicit conversion rules for fields during migration4CUSTOMERCustomer Objectnvarchar10
11CNVCMIS_FIPARSparameters for rules mentioned in cnvmbtfields4CUSTOMERCustomer Objectnvarchar10
12CNVCMIS_MAPPINGTable for storing information about the mapping10CUSTOMERCustomer Objectnvarchar10
13CNVCMIS_NTR_STRUInformation about the known values of nontransparent field12CUSTOMERCustomer Objectnvarchar10
14CNVMBT09TABLETables to be processed12CUSTOMERFlag indicating that table is found in customer systemnvarchar10
15CNVMBTCHECKSMBT Checks4CUSTOMERCustomer Objectnvarchar10
16CNVMBTCOBJconversion objects4CUSTOMERCustomer Objectnvarchar10
17CNVMBTFIELDSexplicite conversion rules for fields during migration4CUSTOMERCustomer Objectnvarchar10
18CNVMBTFIPARSparameters for rules mentioned in cnvmbtfields4CUSTOMERCustomer Objectnvarchar10
19CNVMBTFORKEYForeign key releations in structure + fixed values4CUSTOMERCustomer Objectnvarchar10
20CNVMBTTABLESexplicite list of tables to be handled during migration4CUSTOMERCustomer Objectnvarchar10
21CNVMBTTABSTRUCField list of tables for file transfer4CUSTOMERCustomer Objectnvarchar10
22CNVMBTTREEStructure of conversion object / hierachy4CUSTOMERCustomer Objectnvarchar10
23CNVMBT_DEL_TABLETable to be processed12CUSTOMERJust one characternvarchar10
24CNVTDMSBW_ALLOBJAll Objects and their tables9CUSTOMERCustomer Objectnvarchar10
25CNVTDMSBW_EXLOBJObjects in BW system and conversion object mapping7CUSTOMERCustomer Objectnvarchar10
26CNVTDMSBW_OBJDTObjects in BW system and conversion object mapping6CUSTOMERCustomer Objectnvarchar10
27CNVTDMS_08_FIELDexplicite conversion rules for fields during migration5CUSTOMERCustomer Objectnvarchar10
28CNVTDMS_08_FIPARparameters for rules mentioned in cnvmbtfields5CUSTOMERCustomer Objectnvarchar10
29CNVTDMS_09_TABLETables to be processed12CUSTOMERFlag indicating that table is found in customer systemnvarchar10
30CNV_20100_BPRIOPriority control for B-level10CUSTOMERSingle-Character Indicatornvarchar10
31CNV_MBT_09_TABLETables for table deletion12CUSTOMERJust one characternvarchar10
32DMC_UPG_CPROJMWB: Customer Project1CUSTOMERMWB: Customernvarchar200
33DMC_UPG_CP_RELMWB: Release Upgrades in a Customer Project1CUSTOMERMWB: Customernvarchar200
34DMC_UPG_CUSTMWB: Customer Data for a Project1CUSTOMERMWB: Customernvarchar200
35EPIC_CBCEPIC:Cash budgeting control consumption table12CUSTOMERCustomer Numbernvarchar100
36EPIC_CBC_EBRCash Budgeting Control of Bank Receipt9CUSTOMERCustomer Numbernvarchar100
37FIEUD_SBINV_HSAFT: Self Billing Invoices (Header)- (MM)32CUSTOMERCustomer Numbernvarchar100
38FIEUD_SDINV_HSAFT: Invoices from SD module(Header)30CUSTOMERCustomer Numbernvarchar100
39MRP_BUF_DEM_ITEMSupply demand items and uncovered demand items20CUSTOMERCustomer Numbernvarchar100
40PPH_CACHE_ITEMSupply demand items and uncovered demand items21CUSTOMERCustomer Numbernvarchar100
41QAM_L_BCV_AQIM: Temporary Storage Activities f. Business Context Viewer9CUSTOMERCustomernvarchar100
42QAM_L_BCV_IQIM: Temporary Storage Issues for Business Context Viewer10CUSTOMERCustomernvarchar100
43REFXCN_IDOCREFX POS IDOC Inbound data3CUSTOMERCustomer number of plantnvarchar100
44REFXCN_IDOCTABREFX POS IDOC Inbound data4CUSTOMERCustomer number of plantnvarchar100
45SRA019_T_CONFIGShipment Customer Configuration3CUSTOMERCustomer Numbernvarchar100
46ZATPCUSTSITEATP Check: Customer Site Mapping2CUSTOMERCustomer Numbernvarchar100
47ZQUOTAB1Quotation details2CUSTOMERCharacter field of length 40nvarchar400
TOPAccounts Receivable Accounting Process Integration
48FDM_INVOICE_MEMInvoice Information Provided6CUSTOMERCustomer Numbernvarchar100
TOPAgency Business Global Trade
49WBRPAgency business: Item156CUSTOMERCustomernvarchar100
TOPAMI Event Management
50EFDT_EXPR003FDT: Expression - Create Service Order9CUSTOMERCustomer Numbernvarchar100
51EFDT_EXPR003AFDT: Expression - Create Service Order9CUSTOMERCustomer Numbernvarchar100
52EFDT_EXPR003SFDT: Expression - Create Service Order8CUSTOMERCustomer Numbernvarchar100
53EFDT_EXPR003TFDT: Expression - Create Service Order8CUSTOMERCustomer Numbernvarchar100
TOPBI Content Analyzer
54RSCONTCHECKPROPBI Content Checks Properties6CUSTOMERBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPBusiness Partner Enhancements for Financial Services
55BP000Business Partner Master (General Data)8CUSTOMERCustomer Numbernvarchar100
TOPClinical System
56N2HIT_ENTRYHL: Hit List Entry3CUSTOMERGeneral Flagnvarchar10
57N2HIT_ENTTHL: Text Table for /MED/GA_HL_ENTRY4CUSTOMERGeneral Flagnvarchar10
58N2HIT_EN_OBHL: Assignment: Hit List Entry -> Assigned Object4CUSTOMERGeneral Flagnvarchar10
59N2HIT_EN_OTHL: Text Table for /MED/N2HIT_EN_OB5CUSTOMERGeneral Flagnvarchar10
TOPCollections Management
60UDM_CCT_ATTRCustomer Contact3CUSTOMERBusiness Partner Numbernvarchar100
61UDM_RSM_ATTRResubmissions3CUSTOMERBusiness Partner Numbernvarchar100
TOPCondition Technique
62/SAPCND/UE_RANGEUserexit Formula Number Range7CUSTOMERCustomer System: TRESC checks enablednvarchar10
TOPControlling
63IAOM_CPRO_EXATExternal Characteristics of an Object in cProjects14CUSTOMERSold-to partynvarchar100
TOPCross-Application Component CA Enhancements
64/SAPMP/MIG_T002Migration CS -> DIMP: Object Status Batch Stock8CUSTOMERCustomer Numbernvarchar100
TOPCross-Application Components
65ETP_TASKSEasy Task Planning: Tasks12CUSTOMER128 characternvarchar1280
TOPDealer Portal
66/SAPDII/SPPSHIPAMaintaining Alternate shipping locations4CUSTOMERCustomer Numbernvarchar100
TOPDirect Store Delivery
67/DSD/DX_HDDEX Stream Header (backend)2CUSTOMERCustomer Numbernvarchar100
TOPDistributor-Reseller-Management
68/SAPHT/DRMSLSRPTDRM 867 Outbound processing table8CUSTOMERCustomer Numbernvarchar100
TOPElectronic Data Interchange
69PRICAT_K001PRICAT: Catalog header10CUSTOMERCustomer Numbernvarchar100
70PRICAT_K003SPRICAT: Status of the Catalog Item per Customer6CUSTOMERCustomer Numbernvarchar100
71PRICAT_K008CPRICAT: Catalog Item Prices/Conditions/Taxes per Customer6CUSTOMERCustomer Numbernvarchar100
72PRICAT_K009CPRICAT: Catalog Item Scales for Condition for Customer6CUSTOMERCustomer Numbernvarchar100
73PRICAT_K00CPRICAT: Customer of a Price Catalog3CUSTOMERCustomer Numbernvarchar100
74PRISBCPARAPRICAT: SBC Parameters for PRICAT Customers1CUSTOMERCustomer Numbernvarchar100
TOPEngineering Change Record
75/PLMI/ECR_HDREngineering Change Record Header data4CUSTOMERCustomer Number 1nvarchar100
TOPEnvironment, Health and Safety
76/TDAG/CPT_TASKHHeader data for tasks11CUSTOMERCustomer Numbernvarchar100
77/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv11CUSTOMERCustomer Numbernvarchar100
78/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten7CUSTOMERCustomer Numbernvarchar100
79/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv7CUSTOMERCustomer Numbernvarchar100
80/TDAG/RCSA_CAPOSCampaign position data6CUSTOMERCustomernvarchar100
TOPERP related topics
81/MRSS/D_RM_ROUT2Routing table to determing Resource management Groups13CUSTOMERCustomer Numbernvarchar100
TOPFinancials Basis
82UBC_TB_CEDATACost Events4CUSTOMERCustomer IDnvarchar200
TOPGL Account Posting
83TCJ_POSITIONSCash Journal Document Items22CUSTOMERCustomer Numbernvarchar100
TOPGlobal Trade
84WB2_D_COMSUBTrading Contract: commodity sub items27CUSTOMERSold-to partynvarchar100
85WB2_D_SHD_ITEMShadow Items16CUSTOMERSold-to partynvarchar100
TOPGrantor Management
86GTRCUST_ACCGRPAssignment Customer -> Customer account groups3CUSTOMERCustomer Numbernvarchar100
TOPInteraction Center WebClient
87CRMC_IC_EMAILEmail client customizing table4CUSTOMERDefault To Address in New E-Mailnvarchar10
TOPJoint Venture und Production Sharing Accounting
88T8PSA_LIFT_TERMLifting Volumes by terminal14CUSTOMERCustomer Numbernvarchar100
89T8PSA_LIFT_VOLLifting Volumes21CUSTOMERCustomer Numbernvarchar100
TOPMarketing, Accounting and Pricing
90OICQOILF&A Oil Table for Repository Default3CUSTOMERF&A repository customernvarchar100
TOPMaster Data Synchronization
91CVI_CUST_LINKAssignment Between Customer and Business Partner3CUSTOMERCustomer Numbernvarchar100
TOPMaterials Management
92J_1GMM2GVEnd year inventory8CUSTOMERCustomer Numbernvarchar100
TOPMessages
93DNOD_NOTIF_TANotification: Data for Task Planning8CUSTOMER128 characternvarchar1280
TOPOverhead Cost Controlling
94TKALVControl Parameter for Line Item Report with AAA4CUSTOMERCustomer Entrynvarchar10
TOPPayment Transactions
95TFIBLAPARPVAROnline Payment: Variants4CUSTOMERCustomer Numbernvarchar100
TOPPerishables Procurement
96FIP_D_PDT_TO_CUSInternal planned delivery time from suppl. Plant to customer4CUSTOMERCustomer Numbernvarchar100
97FIP_D_PROMOPromotion data5CUSTOMERCustomer Numbernvarchar100
TOPRemaining Beverage - Obsolete Objects
98/BEV3/CHCDPBKCDP: Purchase Control Results10CUSTOMERCustomer Number of Sold-to Partynvarchar100
99/BEV3/CHCDPSALESCDP: Contract Sales (Detailed)11CUSTOMERCustomer Number of Sold-to Partynvarchar100
TOPRental Accounting
100VIRAINVRE Invoice Header18CUSTOMERCustomer Numbernvarchar100
TOPReusable Components of Business Suite Foundation
101/BOFU/SO_BUPA_RTSales Order Business Partner Root Table7CUSTOMERnvarchar300
TOPSAP NetWeaver Mobile - Use subcomponents
102MEREP_TEST_CUSTMI Test Tool - Customize Tables with Values5CUSTOMERGeneral Flagnvarchar10
TOPSpecification 2
103SPCPRTNRINFPartner Information for SPEC 2000 message5CUSTOMERCustomer Identification Codenvarchar50
TOPStructure
104DPR_PROJECTProject Definition24CUSTOMERBusiness Partner GUIDvarbinary160
TOPStructures
105PSHLP_CUST_DPROFData Selection Profile11CUSTOMERCustomernvarchar10
106PSHLP_DATASET_DBTo store the user specific datasets chosen12CUSTOMERSingle-Character Indicatornvarchar10
TOPTrading Contract
107WB2_D_STRINGLogistical string,circle and washout7CUSTOMERSold-to partynvarchar100
TOPWeb Channel UM ERP aspects
108ERPD_WEC_CU_DFPMDefault Payment method for a Customer ( Web Channel )2CUSTOMERCustomer Numbernvarchar100
109ERPD_WEC_CU_PAYMCustomer Payment Methods ( Web Channel )3CUSTOMERCustomer Numbernvarchar100