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

107 columns | Print definition?ERP 6.0  | CHDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BSNAGT/FILE_INFFile Status Information15CHDATChange Datenvarchar80
2BKK_OPD_IT_EXTExternal Item Selection Table - Outgoing Payment Dispatcher50CHDATDate on which the object was last changednvarchar80
3CNVMBTCLUSTTABCluster tables DDIC for de-clustered systems4CHDATSystem Datenvarchar80
4CNV_10400_SETUPSettings for characteristic conversion32CHDATChange datenvarchar80
5CNV_10400_TABUSESettings for characteristic conversion7CHDATChange datenvarchar80
6CNV_10940_FCONSTFinal consistency check status16CHDAT(8-character) Date for SYSTnvarchar80
7DFKKPARTADJTrigger for Adjustment of Partner Billable Items13CHDATLast Changed Onnvarchar80
8DMC_UPG_ACTIONMWB: Upgrade Actions10CHDATMWB: Date on which the object was changed for the last timenvarchar80
9DMC_UPG_COMPMWB: Upgrade Directory (Component/Release)10CHDATMWB: Date on which the object was changed for the last timenvarchar80
10DMC_UPG_CPROJMWB: Customer Project7CHDATMWB: Date on which the object was changed for the last timenvarchar80
11DMC_UPG_CUSTMWB: Customer Data for a Project6CHDATMWB: Date on which the object was changed for the last timenvarchar80
12P05EIR_MTY_STATElectronic Illness Reporting: Status Table8CHDATDatenvarchar80
TOPAccount Management
13BKK42_NTCMaster Data for Notice and Allowances20CHDATDate on which the object was last changednvarchar80
14BKKNTCNotice: Partial Amount and Full Amount Notice21CHDATDate on which the object was last changednvarchar80
TOPAddress ManagementBusiness Address
15SADRAddress Management: Company Data44CHDATAddresses: Change datenvarchar80
16SADRPAddress Management: Personal Data14CHDATAddresses: Change datenvarchar80
TOPALE Integration Technology
17BDEOIO_INEOIO: Queue Management in IDoc Inbound Processing6CHDATDatenvarchar80
18BDEOIO_OUTEOIO: Queue Management in IDoc Outbound Processing8CHDATDatenvarchar80
19BDRGINALE: Inbound Channel Registry7CHDATDatenvarchar80
20BDRGOUTALE: Outbound Channel Registry7CHDATDatenvarchar80
21TBD71ALE Customizing Distribution: Distribution Groups3CHDATDatenvarchar80
TOPAnalyzer
22AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics49CHDATChanged Onnvarchar80
TOPApplication-Specific Upgrade
23/ASU/HEADERASU Version Header9CHDATField of type DATSnvarchar80
TOPBank Customer Accounts
24BKK58Master Data Savings Prod: Fxd-Term Deposit, Installmnt Savgs25CHDATDate on which the object was last changednvarchar80
25BKKCORRITEMAuxiliary Table: Payment Items for Adjustments95CHDATDate on which the object was last changednvarchar80
26BKKSOBCA: Standing Orders40CHDATDate on which the object was last changednvarchar80
27BKK_PRENOTEPrenotes41CHDATDate on which the object was last changednvarchar80
28NIHC_DB_PO_PNTASource Document for Incoming Payment Orders46CHDATDate Object Created or Changednvarchar80
29TBKKCORRBCA: Table showing if Correspondence is Active7CHDATDate on which the object was last changednvarchar80
TOPBasic Data
30NINSIInstitution-Dependent Insurance Provider Master Data7CHDATChangeover Date of Copayment Procedurenvarchar80
31TN18IInstitution-Dependent Insurance Provider Type Attributes7CHDATChangeover Date of Copayment Procedurenvarchar80
TOPBasic Functions
32T853Company status38CHDATDatenvarchar80
TOPBusiness Partner
33BPOBTABPartner-Object Relationship17CHDATDate when object was last changednvarchar80
TOPBusiness Planning
34UPBXPlanning Applications: Generic Data Container6CHDATDate data element for SYSTnvarchar80
TOPConsolidation
35TF90FActive Field Catalog, Consolidation49CHDATChanged Onnvarchar80
36TF90SBasis Field Catalog Consolidation (Fixed Fields)49CHDATChanged Onnvarchar80
37TF91FField Catalog, Consolidation49CHDATChanged Onnvarchar80
TOPContract Accounts Receivable and Payable
38DFKKPPPromises to Pay Header Table24CHDATCheck Date for Status Determinationnvarchar80
39DFKK_BL_BPLocked Business Partners from GTS6CHDATDate when object was last changednvarchar80
40DFKK_EMBARGOEmbargo Countries from GTS4CHDATDate when object was last changednvarchar80
41DFKK_EMBARGO2Embargo Countries From - To from GTS5CHDATDate when object was last changednvarchar80
42EKLPCIHistory of Charges for Installment Plan Items (LPC in USA)10CHDATDatenvarchar80
TOPData Collection
43TKAFField catalog for Accounting50CHDATChanged Onnvarchar80
44TKCFSAP-EIS Field Catalog49CHDATChanged Onnvarchar80
45TKCHHSAP-EIS: Hierarchy header7CHDATChanged Onnvarchar80
46TKCKKey figures14CHDATChanged Onnvarchar80
47TKCSBasic field catalog SAP-EIS (fixed fields)49CHDATChanged Onnvarchar80
TOPDown Payment Chains
48/SAPPCE/TDPC01Down Payment Chains35CHDATDate of last change to objectnvarchar80
TOPFinancials Basis
49UGCMBACKData Model Synchronization: Backup for Conversion5CHDAT(8-character) Date for SYSTnvarchar80
TOPFSCM In-House Cash
50IHC_DB_PNSource Document for Incoming Payment Orders92CHDATChanged Onnvarchar80
TOPGL transfer
51BKKC01Gen.Ledger: Reconciliation Key Accounting Documents13CHDATDate on which the object was last changednvarchar80
52BKKCNOITGLTable of Items not Updated on the Account43CHDATDate on which the object was last changednvarchar80
53BKKCVAAdministration Table Individual Value Adjustment14CHDATDate on which the object was last changednvarchar80
TOPIncentive and Commission Management ICM
54TCACSFCommissions: Field Catalog Search50CHDATChanged Onnvarchar80
TOPInformation System
55TKAF_USER_APPD_KField Catalog for Customer Key Figures18CHDATChanged Onnvarchar80
56TKAF_USER_APPD_MField Catalog for Customer Characteristics23CHDATChanged Onnvarchar80
TOPInvestment Programs
57TAIFIM Drilldown: Characteristic Catalog50CHDATChanged Onnvarchar80
TOPInvoicing
58EKLPCINVHistory of Charges for Installment Plan Items (LPC in USA)11CHDATDatenvarchar80
TOPMaster Data
59BCA_US_HLD2RELHold Records which have not been released - Dual Control27CHDATDate on which the object was last changednvarchar80
60BCA_US_HOLDHold Amounts Which Affect Available Balance26CHDATDate on which the object was last changednvarchar80
TOPMaster data
61PACKKPPacking Object Header36CHDATDate of last changenvarchar80
TOPNetherlands
62P05EIR_MSG_STATElectronic Illness Reporting : Status (Obsolete)7CHDATDatenvarchar80
TOPObject Dependencies
63CUVFUN_ADMAdministrative Data for variant function6CHDATChanged Onnvarchar80
TOPOrganizational Management
64HRMDRGINHR Master Data: Registry for Serialization in ALE Inbound7CHDATDatenvarchar80
65HRMDRGOUTHR Master Data: Registry for Serialization in ALE Outbound7CHDATDatenvarchar80
TOPPayment Item
66BKKITPayment Item95CHDATDate on which the object was last changednvarchar80
67BKKITAIInfo Items for Interest Penalty at Balancing28CHDATDate on which the object was last changednvarchar80
68BKKITENQBlocked Payment Items95CHDATDate on which the object was last changednvarchar80
69BKKITRELPayment Item95CHDATDate on which the object was last changednvarchar80
70BKKITTMPPlanned Payment Items96CHDATDate on which the object was last changednvarchar80
71BKKITTMP_DELPlanned Payment Items - Completed96CHDATDate on which the object was last changednvarchar80
TOPPayment Order
72BKKPOHDPayment Order, Header Data34CHDATDate on which the object was last changednvarchar80
73BKKPOHD_TMPPlanned Payment Order, Header Data35CHDATDate on which the object was last changednvarchar80
74BKKPOHD_TMP_DELPlanned Payment Order, Header Data35CHDATDate on which the object was last changednvarchar80
TOPPayroll
75T5TPSTXT02Texty pro formuláre v doplncích opatrení .11CHDATnvarchar80
TOPPension fund General Parts
76T5CPBHR-CH: Pension fund postings16CHDATChange Date of a PF Posting Documentnvarchar80
TOPProfitability Analysis
77TJBFField Catalog IS-B-PA49CHDATChanged Onnvarchar80
78TJBSBase Field Catalog IS-B-PA (Fixed Fields)49CHDATChanged Onnvarchar80
79TKEFCO-PA field catalog49CHDATChanged Onnvarchar80
80TKESCO-PA Basis Field Catalog (fixed fields)49CHDATChanged Onnvarchar80
TOPProgress Tracking
81TSTNTExpediting Status Information12CHDATChanged Onnvarchar80
TOPReal Estate Management
82BPOBIMMOBusiness Partner - Object Relationship: Real Estate28CHDATDate when object was last changednvarchar80
TOPRecycling Administration Core Functions
83J_7LSADRAddress Management: Company Data44CHDATAddresses: Change datenvarchar80
TOPRisk Analysis
84JBRRMTKEFRM: Copy of CO-PA Field Catalog49CHDATChanged Onnvarchar80
85JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures49CHDATChanged Onnvarchar80
TOPStakeholder Relationship Management
86USC_CONTACTSRM Contact: Central Storage of Contacts18CHDATDate when object was last changednvarchar80
87USC_CONT_DOCSRM Contact: Documents12CHDATDate when object was last changednvarchar80
88USC_CONT_KWDSRM Contact: Keywords9CHDATDate when object was last changednvarchar80
89USC_CONT_RELSRM Contact: Related Contacts9CHDATDate when object was last changednvarchar80
90USC_CONT_STHSRM Contact: Stakeholders15CHDATDate when object was last changednvarchar80
91USS_STAKEHOLDERSEM-SRM: Specific Master Data of Stakeholder13CHDATDate when object was last changednvarchar80
92USS_STH_COVERSEM-SRM: Relationship Stakeholder and Coverage9CHDATDate when object was last changednvarchar80
93USS_STH_EXPECTSEM-SRM: Expectations of Stakeholders19CHDATDate when object was last changednvarchar80
94USS_STH_INFLSEM-SRM: Influence of Stakeholders14CHDATDate when object was last changednvarchar80
95USS_STH_SHARESEM-SRM: Shares of Stakeholders13CHDATDate when object was last changednvarchar80
96USS_STH_STH_GRPSEM-SRM: Group of Stakeholders12CHDATDate when object was last changednvarchar80
TOPTreasury
97TTMRFField catalog for Risk Management49CHDATChanged Onnvarchar80
98TTMRSBasis field catalog Risk Management (fixed fields)49CHDATChanged Onnvarchar80
TOPUse AP-MD-BP Components
99BUT000BP: General data I80CHDATDate when object was last changednvarchar80
100BUT000_TDBP: General Data I, Shadow Table Time Dependency81CHDATDate when object was last changednvarchar80
101BUT000_TDSBP: General Data I, Shadow Table Time Dependency82CHDATDate when object was last changednvarchar80
102BUT050BP relationships/role definitions: General data16CHDATDate when object was last changednvarchar80
103BUT050SBP Relationships/Role Definitions: General Data17CHDATDate when object was last changednvarchar80
TOPUse Subcomponents
104SOFDSAPoffice: Object Definition20CHDATDate of Last Changenvarchar80
105SOODSAPoffice: Object definition23CHDATDate of Last Changenvarchar80
106SORFSAPoffice: Replication Table20CHDATDate of Last Changenvarchar80
107SOUDSAPoffice: user definition15CHDATDate of Last Changenvarchar80