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

100 columns | Print definition?ERP 6.0  | ORGUNIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTSELCONFRConfrontation of org-independent group IDs6ORGUNITOrganizational Structurenvarchar100
2CNVMBTSELORGTDMS: Orgunits used in GROUP_IDs4ORGUNITOrganizational Structurenvarchar100
3CNVTDMSBI_SELECSelected "From date" for a package4ORGUNITOrganizational Structurenvarchar100
4CNVTDMSBW_ORMASMaster Table for Orgunits recogonised by TDMS BW3ORGUNITOrganizational Structurenvarchar100
5CNVTDMS_01_CCSELCompany dependant org units3ORGUNITOrganizational Unitnvarchar300
6CNVTDMS_01_INCONInconsistent Entries as per the package for 'From Date'4ORGUNITOrganizational Structurenvarchar100
7CNVTDMS_01_ORMASMaster table for all orgunits and reference tables3ORGUNITOrganizational Structurenvarchar100
8CNVTDMS_01_ORSELTDMS table to select Orgunits to be transferred3ORGUNITOrganizational Structurenvarchar100
9CNVTDMS_01_PERIOPosting Period Analysis4ORGUNITOrganizational Structurenvarchar100
10CNVTDMS_01_SCENtable that tells the details of the approach selected4ORGUNITOrganizational Structurenvarchar100
11CNVTDMS_01_SELECdetails of the picked "From date" for a certain package3ORGUNITOrganizational Structurenvarchar100
12CNVTDMS_03_CONFRConfrontation of org-independent group IDs6ORGUNITOrganizational Structurenvarchar100
13CNVTDMS_03_ORGTDMS: Orgunits used in GROUP_IDs4ORGUNITOrganizational Structurenvarchar100
14CNVTDMS_CR_SELECdetails of the picked "From date" for a certain package3ORGUNITOrganizational Structurenvarchar100
15COPC_PAYRQ_DTLCOPC: PAYRQ Detail17ORGUNITCOPC Orgnization Unitnvarchar80
16DMC_ACT_RECActivity record - info about the execution of DMC activities5ORGUNITDMC: General IDnvarchar200
17DMC_RFC_SETTINGSRFC Destinations and System IDs1ORGUNITMWB: Type of Org. Unit (Global, Proj., Subproj., Conv.Obj. )nvarchar10
18DMC_VALIDATEcontrol table for check functions1ORGUNITMWB: Type of Org. Unit (Global, Proj., Subproj., Conv.Obj. )nvarchar10
19GRACREQUSERADRUser Communication Fields11ORGUNITOrg Unitnvarchar120
20GRPCFSAUPGRADEProcessed Control-FSA relations2ORGUNITOrganizational Unit IDnvarchar80
21GRPCSIGNOFFPLANSign-Off Guid6ORGUNITObject IDnvarchar80
22GRRMOBRCSARCSA Plan Matrix7ORGUNITObject IDnvarchar80
23GRRMOBRCSAMATRIXRCSA Plan Matrix5ORGUNITObject IDnvarchar80
24GRRMPROPRESPONSETable for Response Proposal6ORGUNITResponse Proposal - Org unit IDnvarchar80
25ZDEMODATESSelection of Personnel and Monitor Daate types for Demos2ORGUNITOrganizational Unitnvarchar80
26ZSUPM_IM_INT_BRIncident integration with SuPM for Brazil Standard Scenario2ORGUNITnvarchar80
27ZZRMILD800GRCRMILD Generated3ORGUNITConcatenation of Object Type and Object IDnvarchar100
TOPArchiveLink
28TOAO2SAP ArchiveLink extended meta table4ORGUNITOrganizational unitnvarchar200
TOPBasic Functions
29FAAASSETIDAssignment Table - Asset Key to Asset GUID3ORGUNITLeading Organizational Unit for Asset Accountingnvarchar40
TOPBatch-Oriented Parallel Processing of Mass Data
30BANK_PPDEMO_ORGMass Run Parameters for Demonstration5ORGUNITOrganizational Unit to Demonstrate Use of Parallel Process.nvarchar40
31BANK_PPDEMO_PACKPackage-Related Parameters for Demonstration4ORGUNITOrganizational Unit to Demonstrate Use of Parallel Process.nvarchar40
32BANK_PP_DEMOData to Demonstrate Use of Parallel Processing3ORGUNITOrganizational Unit to Demonstrate Use of Parallel Process.nvarchar40
33PPF_TST_EMPLOYEEMaster Data for PPF Test Application4ORGUNITOrganizational Unitnvarchar100
34PPF_TST_ORGOrganizational Units for Test Application2ORGUNITOrganizational Unitnvarchar100
35PPF_TST_ORG_RUNOrg. Units of a Mass Run for Processing5ORGUNITOrganizational Unitnvarchar100
36TBANK_PPDEMOORGOragnizational Units for Demonstration2ORGUNITOrganizational Unit to Demonstrate Use of Parallel Process.nvarchar40
TOPBusiness Application Support
37CNVDOMSCNV: Domains required by conversion package9ORGUNITConversion: Organizational unit for delimitationnvarchar100
38CNVDOMSCCNV: from conv. pack. domains with conflicts in blending10ORGUNITConversion: Organizational unit for delimitationnvarchar100
TOPBusiness Package for Manager Self-Service FI
39FPB_SNI_STATELast Status of a Hierarchy6ORGUNITOrganizational Assignment of Objectnvarchar100
TOPCommunication Services Mail, Fax, SMS, Telephony
40BCST_OUBCS: Folder for Semantic and Technical Org. Units Key2ORGUNITConcatenated Identification (Type and ID) of Org.Objectsnvarchar140
TOPData Access in Agreement with German Tax Law
41TPCDATEPeriods for Authorization Check3ORGUNITChar 20nvarchar200
42TPCDATENPeriods for Authorization Check3ORGUNITChar 20nvarchar200
TOPEngineering Change Management
43ECM_CTXTContext6ORGUNITOrganizational Unitvarbinary160
44ECM_ORGOrganizational Unit2ORGUNITOrganizational Unitvarbinary160
TOPEnterprise Compensation Management
45T71ADM_PROC_EECompensation Tracking: Employee Assignments7ORGUNITObject IDnvarchar80
TOPGlobal Trade Services
46/SAPSLL/BOPHDORGGTS: General Bill of Product - Org. Object Assignment4ORGUNITBusiness Partner Numbernvarchar100
TOPGovernance, Risk and Compliance
47GRFNTASKPLANData for task plan5ORGUNITObject IDnvarchar80
48GRFN_ORM_PROTORM Transfer: Log2ORGUNITObject IDnvarchar80
TOPGRC Risk Management
49/ORM/ORMTEVNTThe ILD Event Main table3ORGUNITObject IDnvarchar80
TOPImplementation Guide
50TPRORGUNITSOrganizational Units Affected in a Project3ORGUNITOrganizational Unit in a Projectnvarchar600
TOPLoans Management
51TTONFTVDARLTest neue Fima: Grunddaten und VDARL166ORGUNITOrganisationseinheitnvarchar120
52VDARLLoans152ORGUNITOrganizational Unitnvarchar120
53VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)20ORGUNITOrganizational Unitnvarchar120
TOPManagement of Internal Controls
54FOPCAISOUAssignment of AIS Systems to the Org Units2ORGUNITOrganizational Unit IDnvarchar80
55FOPCCORPORATEMIC: Corporate Objects3ORGUNITObject IDnvarchar80
56FOPCDEFICORGMIC: Deficiency Analysis Status for Org Unit3ORGUNITOrganizational Unit IDnvarchar80
57FOPCPRTUSERPARAUser Parameters for Print5ORGUNITOrganizational Unit IDnvarchar80
58FOPCRBFAGLUEReporting Buffer: Account Group - Fin. Statement Assertion3ORGUNITOrganizational Unit IDnvarchar80
59FOPCRBFCASETEXTSReport Buffer: Cases - Texts3ORGUNITOrganizational Unit IDnvarchar80
60FOPCRBFISReporting Buffer: Cases - Issues3ORGUNITOrganizational Unit IDnvarchar80
61FOPCRBFMCReporting Buffer: Buffered Structures3ORGUNITOrganizational Unit IDnvarchar80
62FOPCRBFPGLUEReporting Buffer: P-CO-R3ORGUNITOrganizational Unit IDnvarchar80
63FOPCRBFPLReporting Buffer: Cases - Remediation Plans3ORGUNITOrganizational Unit IDnvarchar80
64FOPCRBFSTRReporting Buffer: Buffered Structures3ORGUNITOrganizational Unit IDnvarchar80
65FOPCRBFTLReporting Buffer: Cases - Test Logs3ORGUNITOrganizational Unit IDnvarchar80
66FOPCSHMSetting for Shared Memory2ORGUNITOrganizational Hierarchynvarchar10
67FOPCSIGNOFFSign-Off5ORGUNITObject IDnvarchar80
68FOPCTASKFREQFrequency of the Tasks3ORGUNITObject IDnvarchar80
69FOPCTASKFREQ_TFTimeframes of Tasks That Can Be Scheduled at Corporate Level3ORGUNITObject IDnvarchar80
70FOPCTASKFREQ_TFCControls for Timeframes of Tasks that Can Be Scheduled3ORGUNITObject IDnvarchar80
71FOPCUSERDATAUser-Specific Settings5ORGUNITOrganizational Unit IDnvarchar80
72FOPC_ORM_PROTORM Transfer: Log4ORGUNITObject IDnvarchar80
TOPMaster Data
73TD19Organizational Unit (Contract Management)2ORGUNITOrganizational Unitnvarchar120
74TD19TOrganizational Unit (Contract Management)3ORGUNITOrganizational Unitnvarchar120
TOPProcess Controls
75GRPCAISOUAssignment of AIS Systems to the Org Units2ORGUNITOrganization IDnvarchar80
76GRPCAODDATAaod data3ORGUNITOrganization IDnvarchar80
77GRPCAODGROUPaod group4ORGUNITOrganization IDnvarchar80
78GRPCAODGRPCTRLrelation table for aod group and it's controls5ORGUNITOrganization IDnvarchar80
79GRPCAODORGaod org3ORGUNITOrganization IDnvarchar80
80GRPCCORPORATEPC: Corporate Objects3ORGUNITObject IDnvarchar80
81GRPCDEFICORGPC: Deficiency Analysis Status for Org Unit3ORGUNITOrganization IDnvarchar80
82GRPCPRTUSERPARAUser Parameters for Print5ORGUNITOrganization IDnvarchar80
83GRPCRBFAGLUEReporting Buffer: Account Group - Fin. Statement Assertion3ORGUNITOrganization IDnvarchar80
84GRPCRBFASReporting Buffer: Cases - Assessments3ORGUNITOrganization IDnvarchar80
85GRPCRBFCASETEXTSReport Buffer: Cases - Texts3ORGUNITOrganization IDnvarchar80
86GRPCRBFISReporting Buffer: Cases - Issues3ORGUNITOrganization IDnvarchar80
87GRPCRBFMCReporting Buffer: Buffered Structures3ORGUNITOrganization IDnvarchar80
88GRPCRBFPGLUEReporting Buffer: P-CO-R3ORGUNITOrganization IDnvarchar80
89GRPCRBFPLReporting Buffer: Cases - Remediation Plans3ORGUNITOrganization IDnvarchar80
90GRPCRBFSTRReporting Buffer: Buffered Structures3ORGUNITOrganization IDnvarchar80
91GRPCRBFTLReporting Buffer: Cases - Test Logs3ORGUNITOrganization IDnvarchar80
92GRPCSHMSetting for Shared Memory2ORGUNITOrganizational Hierarchynvarchar10
93GRPCSIGNOFFSign-Off5ORGUNITObject IDnvarchar80
94GRPCTASKFREQObsolete: Frequency of the Tasks3ORGUNITObject IDnvarchar80
95GRPCTASKFREQ_TFObsolete: Tasks That Can Be Scheduled at Corporate Level3ORGUNITObject IDnvarchar80
96GRPCTASKFREQ_TFCObsolete: Timeframes of Tasks that Can Be Scheduled3ORGUNITObject IDnvarchar80
97GRPCTASKPLANObsolete: Data for task plan5ORGUNITObject IDnvarchar80
98GRPCUSERDATAUser-Specific Settings5ORGUNITOrganization IDnvarchar80
99GRPC_ORM_PROTORM Transfer: Log4ORGUNITObject IDnvarchar80
TOPRecords and Case Management
100RMPS_DISUNITRetention Unit, Record Segment11ORGUNITPlace/Organizational Unit Initiating Recordnvarchar300