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

66 columns | Print definition?ERP 6.0  | DOCUMENT_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/D_ACT_ATTAttachment of Activities5DOCUMENT_TYPEDocument Typenvarchar30
2/IAM/D_I_ATTAttachment5DOCUMENT_TYPEDocument Typenvarchar30
3/SAPSRM/C_WF_ACPAcceptance by Document Responsible2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
4/SAPSRM/C_WF_ADHAd-Hoc Process Level Defaults2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
5/SAPSRM/C_WF_LProcess Level Configuration2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
6/SAPSRM/C_WF_OPurchasing Documents for Approval Workflow2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
7/SAPSRM/C_WF_PProcess Schema Definition2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
8/SAPSRM/C_WF_PEProcess Schema Evaluation2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
9/SAPSRM/C_WF_PSProcess Schema Definition2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
10/SAPSRM/C_WF_RVRReviewer Configuration2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
11/SAPSRM/C_WF_WSub-Workflow Template Assignment Of Process Level Type2DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
12/SAPSRM/D_WF_000Table for persistent class /SAPSRM/CL_WF_PROCESS3DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
13/SAPSRM/D_WF_005Table for persistent class /SAPSRM/CL_WF_AREA_CONTEXT5DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
14/SAPSRM/D_WF_019Table for persistent class /SAPSRM/CL_PDO_BO_SERVICE3DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
15/SAPSRM/D_WF_020Migration stop and start workflow3DOCUMENT_TYPEObject Type of SRM Purchasing Documentnvarchar100
16/XFT/EPA_CDELECustomizig Automatic Deletion of Documents3DOCUMENT_TYPEDocument typenvarchar100
17/XFT/EPA_DELDECLRejected Documents4DOCUMENT_TYPEDocument typenvarchar100
18/XFT/EPA_DELMDATManually Set Deletion Date4DOCUMENT_TYPEDocument typenvarchar100
19/XFT/EPA_DELRUNNRunning Deletion Processes4DOCUMENT_TYPEDocument typenvarchar100
20/XFT/EPA_DPERS/XFT/EPA_PERS4DOCUMENT_TYPESAP ArchiveLink: Document classnvarchar200
21/XFT/EPA_DWFL_01Persistence workflow 014DOCUMENT_TYPEStringntext10737418230
22/XFT/EPA_RECPOSProperty extension: File nodes ArchiveLink documents6DOCUMENT_TYPEDocument typenvarchar100
23/XFT/EPA_T0009Dialog settings scan transactions10DOCUMENT_TYPEDocument typenvarchar100
24/XFT/EPA_TBARCOOpen barcodes10DOCUMENT_TYPEDocument typenvarchar100
25/XFT/EPA_TPROTLog11DOCUMENT_TYPEDocument typenvarchar100
26BBP_WFL_TRACEBBP_WFL_TRACE4DOCUMENT_TYPEBusiness Trans. Cat.nvarchar100
27CIAP_C_ACCOUNTDefine CIAP related financial account information11DOCUMENT_TYPEDocument Typenvarchar20
28DIAN_A_1001_08Cached Data of DIAN Format 1001 version 086DOCUMENT_TYPEDIAN Identification Typenvarchar20
29DIAN_A_1003_07Cached Data of DIAN Format 1003 version 076DOCUMENT_TYPEDIAN Identification Typenvarchar20
30DIAN_A_1005_07Cached Data of DIAN Format 1005 version 075DOCUMENT_TYPEDIAN Identification Typenvarchar20
31DIAN_A_1006_07Cached Data of DIAN Format 1006 version 075DOCUMENT_TYPEDIAN Identification Typenvarchar20
32DIAN_A_1007_08Cached Data of DIAN Format 1007 version 086DOCUMENT_TYPEDIAN Identification Typenvarchar20
33DIAN_A_1008_07Cached Data of DIAN Format 1003 version 075DOCUMENT_TYPEDIAN Identification Typenvarchar20
34DIAN_A_1009_07Cached Data of DIAN Format 1009 version 075DOCUMENT_TYPEDIAN Identification Typenvarchar20
35DIAN_A_TFORMATTesting table for Cached Data of DIAN Formats7DOCUMENT_TYPEDIAN Identification Typenvarchar20
36EDOPEINVeDocument Peru Invoice3DOCUMENT_TYPEPeru: Document typenvarchar20
37SIPT_NUMBR_OIGSiganture PT : Customizing Table for Signature in IS-OIL4DOCUMENT_TYPESignature PT : Delivery/ Shipment Indicatornvarchar10
38T7BR_DOCUMENTSTable to store XML sent for the government3DOCUMENT_TYPEDocument typenvarchar10
TOPBusiness Analytics
39UAB_XML_DATAXML Data9DOCUMENT_TYPEDocument Typenvarchar300
40UAUXS_DATAXML Data9DOCUMENT_TYPEDocument Typenvarchar300
TOPCross-Application Components
41CFX_C_DOCTYPEDocument-Type Dependent Customizing Settings3DOCUMENT_TYPEDocument Typenvarchar30
TOPDSD Connector
42/DSD/ME_ES_CANCDSD CN: Define Settings for Canc./Chang. Signed Documents2DOCUMENT_TYPEDocument type for cancellation / changenvarchar20
TOPHelp Infrastructure for ABAP
43SAPGUIHC_LINKSHelp Center: Documents8DOCUMENT_TYPEDocument Typenvarchar20
44SAPHC_LINKS_HEADHelp Center: Documents Header4DOCUMENT_TYPEDocument Typenvarchar20
TOPMaster Data
45GMBRMRules for Manual Billing3DOCUMENT_TYPEAccounting Document Typesnvarchar20
TOPOwnership
46GHO_OWN_TRO_HDRTransfer of Ownership Header Table4DOCUMENT_TYPEDocument Type for Ownership Transfer Requestnvarchar20
TOPProduct Data Management
47TCEPCLDefault Classes for Saudia Aramco2DOCUMENT_TYPEDocument Typenvarchar30
TOPProduction Orders
48COCF_CU_SNTYPEShift Note Type - Settings for Subscreen 013015DOCUMENT_TYPEDocument Typenvarchar30
TOPSAP Records Management
49RCMDOIDOCTYPERegistered DOI Doc Types on User's Desktop3DOCUMENT_TYPEError message text - long text of the errornvarchar700
TOPSelf-Service Procurement
50/SRMERP/C_ATPCRATP Check Rules3DOCUMENT_TYPEPurchasing Document Typenvarchar40
51/SRMERP/C_DOCTPDocument Types3DOCUMENT_TYPEPurchasing Document Typenvarchar40
52/SRMERP/C_DOCTPTDocument TypesText4DOCUMENT_TYPEPurchasing Document Typenvarchar40
53/SRMERP/C_FODTPFollow on Document Types3DOCUMENT_TYPEPurchasing Document Typenvarchar40
54/SRMERP/C_TXCPIText Copy Rule Item3DOCUMENT_TYPEPurchasing Document Typenvarchar40
55/SRMERP/D_SCShopping Cart Header4DOCUMENT_TYPEPurchasing Document Typenvarchar40
TOPServices
56UAB_FXMLXML Data8DOCUMENT_TYPEDocument Typenvarchar300
TOPStructure
57DPR_APPROVALApproval6DOCUMENT_TYPEDocument Categorynvarchar30
TOPTransfer to Financial Accounting
58TRAC_POSTRULETreasury Account Determination: Posting Specifications3DOCUMENT_TYPEDocument Typenvarchar20
TOPWeb Survey
59TUWS_DATAXML Data8DOCUMENT_TYPEDocument Typenvarchar300
60TUWS_FORMSERVICEXML Data9DOCUMENT_TYPEDocument Typenvarchar300
61TUWS_SURVEYSurvey9DOCUMENT_TYPEDocument Typenvarchar300
62TUWS_SURVEY_GRPSurvey9DOCUMENT_TYPEDocument Typenvarchar300
63TUWS_TARGETHIERXML Data9DOCUMENT_TYPEDocument Typenvarchar300
64TUXB_DOC_TYPEDocument Types for XML Framework1DOCUMENT_TYPEDocument Typenvarchar300
65TUXP_KW_DOCKW Persistence Layer for Transaction Data of Application6DOCUMENT_TYPEDocument Typenvarchar300
66UXS_DATAXML Data9DOCUMENT_TYPEDocument Typenvarchar300