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

158 columns | Print definition?ERP 6.0  | CHDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVFIELDMAPConversion: Table mapping12CHDATEChange datenvarchar80
2CNVFIELDMAPFUNCConversion: Mapping Methods for Field Mapping12CHDATEChange datenvarchar80
3CNVINCLTABConversion: Includes for certain tables12CHDATEChange datenvarchar80
4CNVLTHCM_ADDTABOBSOLETE! DO NOT USE!!!12CHDATEChange datenvarchar80
5CNVLTHCM_APPLTABOBSOLETE! DO NOT USE!!!12CHDATEChange datenvarchar80
6CNVLTHCM_BASETABLT HCM: List of HCM Basis Tables10CHDATEChange datenvarchar80
7CNVLTHCM_CWBPACKLT HCM: Assigned CWB Packages12CHDATEChange datenvarchar80
8CNVLTHCM_DELOPTLT HCM: Options for Deletion of HCM Tables12CHDATEChange datenvarchar80
9CNVLTHCM_DELTABLT HCM: List of HCM Tables to be Deleted13CHDATEChange datenvarchar80
10CNVLTHCM_HRDOMOBSOLETE! DO NOT USE!!!10CHDATEChange datenvarchar80
11CNVLTHCM_HRDOM2LT HCM: Domains of HCM Tables11CHDATEChange datenvarchar80
12CNVLTHCM_HRPCKOBSOLETE! DO NOT USE!!!9CHDATEChange datenvarchar80
13CNVLTHCM_HRPCK2LT HCM: HCM Development Packages10CHDATEChange datenvarchar80
14CNVLTHCM_HRTABLT HCM: List of HCM Tables for Transfer13CHDATEChange datenvarchar80
15CNVLTHCM_INDXTRNLT HCM: Cluster Components for Transfer13CHDATEChange datenvarchar80
16CNVLTHCM_MIGSCENLT HCM: Migration Scenario14CHDATEChange datenvarchar80
17CNVLTHCM_PRESELLT HCM: HR Object Selection Assignment to Package11CHDATEChange datenvarchar80
18CNVLTHCM_RCVINFOLT HCM: Information about Receiver System15CHDATEChange datenvarchar80
19CNVLTHCM_SELTABSLT HCM: Data Selection for Tables26CHDATEChange datenvarchar80
20CNVLTHCM_SELTYPLT HCM: Customer-defined Selection Types9CHDATEChange datenvarchar80
21CNVLTHCM_TABGRPLT HCM: Table Groups10CHDATEChange datenvarchar80
22CNVLTHCM_TABOPTOBSOLETE! DO NOT USE!!!10CHDATEChange datenvarchar80
23CNVLTHCM_TP_DEFLT HCM: Time-point Processing - Definition15CHDATEChange datenvarchar80
24CNVLTHCM_TP_MAPLT HCM: Time-point Mapping11CHDATEChange datenvarchar80
25CNVMBTKPILMODULSMBT KP: initial load function moduls knowledge pool12CHDATEMBT KP: create/change datenvarchar80
26CNVMBTKPTABFIELDMBT KP: Response information of tables and fields14CHDATEMBT KP: create/change datenvarchar80
27CNVTABLEMAPConversion: Table mapping10CHDATEChange datenvarchar80
28CNV_00001_FDOMSOBSOLETE: Use CNVDOMS15CHDATEChange datenvarchar80
29CNV_00001_FORMSForm routines used in conversions19CHDATEChange datenvarchar80
30CNV_00001_PARSParameters of form routines used in conversion14CHDATEChange datenvarchar80
31CNV_00001_PDOMSDomains suitable for conversion routine parameters16CHDATEChange datenvarchar80
32CNV_10996_FIELDSSpecific conversion routines22CHDATEChange datenvarchar80
33CNV_10996_FIPARSParameters for specific conversion routines13CHDATEChange datenvarchar80
34CNV_20100_CONFLConflicts on field level (new found account fields)16CHDATESystem Datenvarchar80
35CNV_20200_SP_TABDefinition of tables for the Special Priority Handling14CHDATEChange datenvarchar80
36CNV_20200_SP_VALControl Table for the Special Priority Handling12CHDATEChange datenvarchar80
37CNV_20317_DATBIDetermination for date dependent tables22CHDATEChange datenvarchar80
38CNV_20400_EXCLUTables to be excluded15CHDATEChange datenvarchar80
39CNV_20551_OBJCVTObjecttypes for which a re-conversion shall take place6CHDATEChange datenvarchar80
40CNV_20551_SEQORDTable dependency for start sequence8CHDATESystem Datenvarchar80
41CNV_20551_TABCVTTables for special (re-) processing11CHDATEChange datenvarchar80
42CNV_INDX_CLUSTSINDX clusters11CHDATEChange datenvarchar80
43CNV_INDX_FIELDSINDX conversion: Conv.-relev. RELID component fields18CHDATEChange datenvarchar80
44CNV_INDX_FIPARSINDX conversion: Parameters for conv. of RELID comp. fields15CHDATEChange datenvarchar80
45CNV_INDX_IEINCLSIncludes for versions of RELID import/export routines13CHDATEChange datenvarchar80
46CNV_INDX_IEVERSAdditional versions of RELID import/export routines14CHDATEChange datenvarchar80
47CNV_INDX_IEVPARSParameters of RELID import/export routines15CHDATEChange datenvarchar80
48CNV_INDX_IEVRULERules for choosng RELID structure variant11CHDATEChange datenvarchar80
49CNV_INDX_IEVRULPParameters of rules for choosng RELID structure variant13CHDATEChange datenvarchar80
50CNV_INDX_INCLINDX conversion: Includes for INDX RELID conversion13CHDATEChange datenvarchar80
51CNV_INDX_PACKCNFConfiguration of the INDX conversion for the package17CHDATEChange datenvarchar80
52CNV_INDX_RELIDSINDX cluster RELIDs14CHDATEChange datenvarchar80
53CNV_INDX_STEPSINDX conversion: process-related functions17CHDATEChange datenvarchar80
54CNV_INDX_STPARSINDX conversion: Parameters for process-related functions16CHDATEChange datenvarchar80
55CNV_INDX_STRUCTSStructures of INDX RELIDs15CHDATEChange datenvarchar80
56CNV_INDX_STRVERSAdditional versions of RELID structure retrieval methods11CHDATEChange datenvarchar80
57CNV_INDX_TABLESINDX conversion: Conv.-relev. RELID components16CHDATEChange datenvarchar80
58DFKKBIXCIT_CHChange Sequence of Changed Consumption Items7CHDATELast Changed Onnvarchar80
59DFKKINV_REVTReversal Task9CHDATEDate Reversal Task Changednvarchar80
60DFKK_MA_CHG_LOGLog Record of Change of Master Agreement4CHDATELast Changed Onnvarchar80
61DMC_CU_RUN_OBJTSObject pair for Content Upgrade Analysis21CHDATESystem Datenvarchar80
62FARR_D_RAI_CHChange Sequence of Changed Items12CHDATEChange Date (UTC)nvarchar80
63IUUC_REPL_CONFIGConfiguration of a replication mt_id29CHDATESystem Datenvarchar80
64IUUC_REPL_HDRHeader for the configuration ID9CHDATESystem Datenvarchar80
65J_3RF_RGTORG_INIncoming Journal of Acceptance Documents32CHDATEDate When Document Was Changednvarchar80
66J_3RF_RGTORG_OUTOutgoing Journal of Acceptance Documents27CHDATEDate When Document Was Changednvarchar80
67LAW2D_ATTACHMENTLAW 2.0 Attachement table14CHDATELAW 2.0 Change Datenvarchar80
68LAW2D_CONTLAW 2.0: User types included in another user type9CHDATELAW 2.0 Change Datenvarchar80
69LAW2D_DATASETLAW 2.0 Dataset (Header of the LAW measurement)30CHDATELAW 2.0 Change Datenvarchar80
70LAW2D_ENG_PRESEL8CHDATEnvarchar80
71LAW2D_EXT_SYSTEMLAW 2.0 External System Data18CHDATELAW 2.0 Change Datenvarchar80
72LAW2D_GROUP13CHDATEnvarchar80
73LAW2D_GROUP_SYS8CHDATEnvarchar80
74LAW2D_MEASPLANLAW 2.0 Measurement Plan17CHDATELAW 2.0 Change Datenvarchar80
75LAW2D_SYSTEMLAW 2.0 system table30CHDATELAW 2.0 Change Datenvarchar80
76LXE_REVIEW_FLAGQuery Flag6CHDATEDatenvarchar80
77LXE_RLTP_LOGRemote Copy Registration11CHDATESystem Datenvarchar80
78T7PIQCONVERSIONCM: Data Conversions after Upgrades5CHDATEDate in CHAR formatnvarchar80
TOPALE Integration Technology
79TBD611Definition of Conversion Matrix for System5CHDATEDate data element for SYSTnvarchar80
80TBD61BLogging for Conversion Data12CHDATEDate data element for SYSTnvarchar80
TOPArchive Information System
81ASPART_ACTArchiveInfoSys: Actual Partitioning5CHDATEArchive Information System, Partitioning: Last Changed Datenvarchar80
TOPBasis Components
82/CRYSTAL/CA_JOB2Details on background publisher jobs5CHDATEDate of last job changenvarchar80
TOPBilling in Contract Accounts Receivable and Payable
83DFKKBIXBIT_CHChange Sequence of Changed Billable Items8CHDATELast Changed Onnvarchar80
TOPBusiness Application Support
84CNVDOMSCNV: Domains required by conversion package18CHDATEChange datenvarchar80
85CNVDOPARSConversion: Parameters for the FORM routines from CNVDOMS16CHDATEChange datenvarchar80
86CNVFIELDSConversion: Table fields affected22CHDATEChange datenvarchar80
87CNVFIPARSConversion: Parameters for conversion of table fields13CHDATEChange datenvarchar80
88CNVINCLConversion: of includes required by conversion package10CHDATEChange datenvarchar80
89CNVSTEPSConversion: procedure-related functions14CHDATEChange datenvarchar80
90CNVSTPARSConversion: Parameters for procedure-related functions14CHDATEChange datenvarchar80
91CNVTABLESConversion: Tables for processing by package22CHDATEChange datenvarchar80
92CNV_00001_PARAMSParameter table17CHDATEChange datenvarchar80
TOPCollectionsDisbursements
93VVSCPOSPayment Plan Item48CHDATEDate of Last Change of Scheduling Itemnvarchar80
TOPContract Accounts Receivable and Payable
94FKKPREPACC_BALMgmt Record Balance/Rounding Carryforward for Prepaid Acct5CHDATELast Changed Onnvarchar80
TOPControlling
95QISRCONFIGInternet Service Request: Scenario Configuration (XML)13CHDATEChanged Onnvarchar80
96SUR_SSM_BUFFERSurvey Status Manager: buffer table for status changes6CHDATEDatenvarchar80
TOPCross-Application Components
97/PTGWFI/F_PIRAPSWorkflow Runtime Stack for Parked Invoices19CHDATEDate on which the data record was last changednvarchar80
TOPDown Payment Chains
98/SAPPCE/TDPC19Down Payment Chain: Transactions10CHDATEDate of last change to objectnvarchar80
99/SAPPCE/TDPC20Down Payment Chain: Document Header27CHDATEDate of last change to objectnvarchar80
TOPFinancial Supply Chain Management
100BNK_BATCH_HEADERBatch Header22CHDATEChange Datenvarchar80
TOPFinancials Basis
101UGSCDT002Customizing Comparisons4CHDATEChanged Onnvarchar80
TOPFree Goods
102KONBBYHBonus Buys: Header5CHDATEChanged Onnvarchar80
103KONMATGRPMaterial Grouping: Header5CHDATEChanged Onnvarchar80
TOPGL transfer
104TBKKC_BUKRSBCA Locally Duplicated Values for Corresponding FI17CHDATEDate on which the object was last changednvarchar80
TOPInterface to Terminal Automation System
105OIKLIDTAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)34CHDATEChanged Onnvarchar80
106OIKLIDWTAS LID Working version (NOTE: keep DB eq to DB OIKLID)34CHDATEChanged Onnvarchar80
107OIKLOG01Log Table for Shipment planning10CHDATEChanged Onnvarchar80
TOPJoint Venture und Production Sharing Accounting
108T8JUJoint Operating Agreement30CHDATEDate Last Changednvarchar80
109T8JVJoint Venture16CHDATEDate Last Changednvarchar80
TOPLoans Management
110TDPR_PRODVVersion of a Prodcut, Master Data13CHDATEDate on Which the Object Was Last Changednvarchar80
TOPLocalization
111IDIN_FIAA_ADJUSTAdjustment values for the block and opening WDV - India12CHDATEField of type DATSnvarchar80
112J_3R_PTAX_ABROADTax Paid Abroad Property tax9CHDATEField of type DATSnvarchar80
TOPMaster Data
113BKK610Account Hierarchy: Assignment of Root Account to Tree Number23CHDATEDate when object was last changednvarchar80
TOPPackage Tools
114AKB_SCR_DIRObsolete: Script Index3CHDATEDate of Last Changenvarchar80
TOPPegging, Grouping, and Distribution
115GPD_TARCH_REPOBJGPD Archiving Replenishment Object table11CHDATEChanged Onnvarchar80
116GPD_TARCH_WBSGPD Archiving WBS table8CHDATEChanged Onnvarchar80
TOPProduct definition
117FIPR_PRODVVersion of a Prodcut, Master Data13CHDATEDate on which the object was last changednvarchar80
TOPProduction and Revenue Accounting
118OIUCM_T8JVPRA Joint Venture Master Data16CHDATEDate Last Changednvarchar80
TOPProgress Tracking
119TXPDSTAMPTime Stamp Changes for Progress Tracking4CHDATEChanged Onnvarchar80
TOPRemaining Beverage - Obsolete Objects
120/BEV3/CHBKERGRSLPurchase control results43CHDATEDate of Last Changenvarchar80
121/BEV3/CHBKRESHISPurchase Control Results - History43CHDATEDate of Last Changenvarchar80
122/BEV3/CHBKRESULTPurchase control results43CHDATEDate of Last Changenvarchar80
123/BEV3/CHBKTMPTemp. Purchase Control Results43CHDATEDate of Last Changenvarchar80
TOPSAP Query
124IQICATDBInfoSet Query API: InfoSet Catalog13CHDATESystem Datenvarchar80
125IQQCATDBInfoSet Query API: Query Catalog16CHDATESystem Datenvarchar80
TOPSCM Basis
126CIF_MTCFGSDefault Values for Configuration Relevance for SAP APO11CHDATEChanged Onnvarchar80
TOPSyntax, Compiler, Runtime
127TPDASESSIONSTPDA: Debug Sessions4CHDATETPDA: Letzte Änderung an der Debug Sessionnvarchar80
TOPTransaction Variant and Table Control Settings
128SHDGUIXTScreen variants <--> GuiXT scripts (attributes)6CHDATE(8-character) Date for SYSTnvarchar80
129SHDSVCIScreen variants8CHDATE(8-character) Date for SYSTnvarchar80
130SHDTVTransaction variants8CHDATE(8-character) Date for SYSTnvarchar80
131SHDTVCICross-client transaction variants7CHDATE(8-character) Date for SYSTnvarchar80
132SHDTVCIUTransaction variants independent7CHDATE(8-character) Date for SYSTnvarchar80
133SHDTVUTransaction Variants8CHDATE(8-character) Date for SYSTnvarchar80
TOPTranslation Tools
134LXE_REMRKSLXE Comments for Translation16CHDATEDatenvarchar80
135LXE_REMRKS_LTELXE Translation Comments (Long Text Editor)7CHDATEDatenvarchar80
136LXE_REMRKS_STELXE Comments for Translation (STE)7CHDATEDatenvarchar80
137SKTYREMKRemarks Relating to Translation Objects11CHDATEDatenvarchar80
TOPUpgrade - General
138CVERS_ACTActive Software Components in the System4CHDATEDatenvarchar80
139MERGENEGLNExclusion Objects Merger Central Maintenance Table16CHDATEDate on which entry was last changednvarchar80
TOPUS Prompt Payment Act
140FMFG_PPA_INVSTATPPA Invoice Status Table12CHDATEInvoice Status Change Datenvarchar80
141FMFG_PPA_INV_HISPPA Invoice Status Change History5CHDATEInvoice Status Change Datenvarchar80
TOPWeb Application Builder
142SW3M_ATTRMiniApp Attributes3CHDATEDatenvarchar80
TOPWithout Description
143CCMSBI_CPH_REORGRepository for Data that Is Copied to the CPH Reorg. ODS6CHDATEAlert: datenvarchar80
TOPWork Clearance Management
144WCAAPWCM: Application34CHDATEDate on Which Object was Last Changednvarchar80
145WCACGQWCM: Log (WCM Object <-> Catalog)18CHDATEDate on Which Object was Last Changednvarchar80
146WCACIWCM: (Temporary) Log for Tagging/Untagging (Conflict Check)29CHDATEDate on Which Object was Last Changednvarchar80
147WCACMWCM: Current Operational Condition/Type14CHDATEDate on Which Object was Last Changednvarchar80
148WCACQWCM: Log for Tagging/Untagging (Conflict Check)30CHDATEDate on Which Object was Last Changednvarchar80
149WCAGWCM: Data for Mode-Dependent Tagging13CHDATEDate on Which Object was Last Changednvarchar80
150WCAHEWCM: Work Clearance Document (Header)34CHDATEDate on Which Object was Last Changednvarchar80
151WCAJWCM: Lineup31CHDATEDate on Which Object was Last Changednvarchar80
152WCAKWCM: Verification List (Header Data)13CHDATEDate on Which Object was Last Changednvarchar80
153WCAMCWCM: Log of Operational Lists (Header Data)10CHDATEDate on Which Object was Last Changednvarchar80
154WCAMEWCM: (Temporary) Log of Operational Lists (Items)53CHDATEDate on Which Object was Last Changednvarchar80
155WCAMIWCM: Log of Operational Lists (Items)51CHDATEDate on Which Object was Last Changednvarchar80
156WCARWCM: Operational Step13CHDATEDate on Which Object was Last Changednvarchar80
157WCAWWCM: Work Approval32CHDATEDate on Which Object was Last Changednvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
158W3ATTRXMiniApp Attributes3CHDATEDatenvarchar80