| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVMBTSELCONFR | Confrontation of org-independent group IDs | 6 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
2 | CNVMBTSELORG | TDMS: Orgunits used in GROUP_IDs | 4 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
3 | CNVTDMSBI_SELEC | Selected "From date" for a package | 4 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
4 | CNVTDMSBW_ORMAS | Master Table for Orgunits recogonised by TDMS BW | 3 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
5 | CNVTDMS_01_CCSEL | Company dependant org units | 3 | ORGUNIT | Organizational Unit | nvarchar | 30 | 0 | | |
6 | CNVTDMS_01_INCON | Inconsistent Entries as per the package for 'From Date' | 4 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
7 | CNVTDMS_01_ORMAS | Master table for all orgunits and reference tables | 3 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
8 | CNVTDMS_01_ORSEL | TDMS table to select Orgunits to be transferred | 3 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
9 | CNVTDMS_01_PERIO | Posting Period Analysis | 4 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
10 | CNVTDMS_01_SCEN | table that tells the details of the approach selected | 4 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
11 | CNVTDMS_01_SELEC | details of the picked "From date" for a certain package | 3 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
12 | CNVTDMS_03_CONFR | Confrontation of org-independent group IDs | 6 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
13 | CNVTDMS_03_ORG | TDMS: Orgunits used in GROUP_IDs | 4 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
14 | CNVTDMS_CR_SELEC | details of the picked "From date" for a certain package | 3 | ORGUNIT | Organizational Structure | nvarchar | 10 | 0 | | |
15 | COPC_PAYRQ_DTL | COPC: PAYRQ Detail | 17 | ORGUNIT | COPC Orgnization Unit | nvarchar | 8 | 0 | | |
16 | DMC_ACT_REC | Activity record - info about the execution of DMC activities | 5 | ORGUNIT | DMC: General ID | nvarchar | 20 | 0 | | |
17 | DMC_RFC_SETTINGS | RFC Destinations and System IDs | 1 | ORGUNIT | MWB: Type of Org. Unit (Global, Proj., Subproj., Conv.Obj. ) | nvarchar | 1 | 0 | | |
18 | DMC_VALIDATE | control table for check functions | 1 | ORGUNIT | MWB: Type of Org. Unit (Global, Proj., Subproj., Conv.Obj. ) | nvarchar | 1 | 0 | | |
19 | GRACREQUSERADR | User Communication Fields | 11 | ORGUNIT | Org Unit | nvarchar | 12 | 0 | | |
20 | GRPCFSAUPGRADE | Processed Control-FSA relations | 2 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
21 | GRPCSIGNOFFPLAN | Sign-Off Guid | 6 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
22 | GRRMOBRCSA | RCSA Plan Matrix | 7 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
23 | GRRMOBRCSAMATRIX | RCSA Plan Matrix | 5 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
24 | GRRMPROPRESPONSE | Table for Response Proposal | 6 | ORGUNIT | Response Proposal - Org unit ID | nvarchar | 8 | 0 | | |
25 | ZDEMODATES | Selection of Personnel and Monitor Daate types for Demos | 2 | ORGUNIT | Organizational Unit | nvarchar | 8 | 0 | | |
26 | ZSUPM_IM_INT_BR | Incident integration with SuPM for Brazil Standard Scenario | 2 | ORGUNIT | | nvarchar | 8 | 0 | | |
27 | ZZRMILD800GRCRM | ILD Generated | 3 | ORGUNIT | Concatenation of Object Type and Object ID | nvarchar | 10 | 0 | | |
TOPArchiveLink |
28 | TOAO2 | SAP ArchiveLink extended meta table | 4 | ORGUNIT | Organizational unit | nvarchar | 20 | 0 | | |
TOPBasic Functions |
29 | FAAASSETID | Assignment Table - Asset Key to Asset GUID | 3 | ORGUNIT | Leading Organizational Unit for Asset Accounting | nvarchar | 4 | 0 | | |
TOPBatch-Oriented Parallel Processing of Mass Data |
30 | BANK_PPDEMO_ORG | Mass Run Parameters for Demonstration | 5 | ORGUNIT | Organizational Unit to Demonstrate Use of Parallel Process. | nvarchar | 4 | 0 | | |
31 | BANK_PPDEMO_PACK | Package-Related Parameters for Demonstration | 4 | ORGUNIT | Organizational Unit to Demonstrate Use of Parallel Process. | nvarchar | 4 | 0 | | |
32 | BANK_PP_DEMO | Data to Demonstrate Use of Parallel Processing | 3 | ORGUNIT | Organizational Unit to Demonstrate Use of Parallel Process. | nvarchar | 4 | 0 | | |
33 | PPF_TST_EMPLOYEE | Master Data for PPF Test Application | 4 | ORGUNIT | Organizational Unit | nvarchar | 10 | 0 | | |
34 | PPF_TST_ORG | Organizational Units for Test Application | 2 | ORGUNIT | Organizational Unit | nvarchar | 10 | 0 | | |
35 | PPF_TST_ORG_RUN | Org. Units of a Mass Run for Processing | 5 | ORGUNIT | Organizational Unit | nvarchar | 10 | 0 | | |
36 | TBANK_PPDEMOORG | Oragnizational Units for Demonstration | 2 | ORGUNIT | Organizational Unit to Demonstrate Use of Parallel Process. | nvarchar | 4 | 0 | | |
TOPBusiness Application Support |
37 | CNVDOMS | CNV: Domains required by conversion package | 9 | ORGUNIT | Conversion: Organizational unit for delimitation | nvarchar | 10 | 0 | | |
38 | CNVDOMSC | CNV: from conv. pack. domains with conflicts in blending | 10 | ORGUNIT | Conversion: Organizational unit for delimitation | nvarchar | 10 | 0 | | |
TOPBusiness Package for Manager Self-Service FI |
39 | FPB_SNI_STATE | Last Status of a Hierarchy | 6 | ORGUNIT | Organizational Assignment of Object | nvarchar | 10 | 0 | | |
TOPCommunication Services Mail, Fax, SMS, Telephony |
40 | BCST_OU | BCS: Folder for Semantic and Technical Org. Units Key | 2 | ORGUNIT | Concatenated Identification (Type and ID) of Org.Objects | nvarchar | 14 | 0 | | |
TOPData Access in Agreement with German Tax Law |
41 | TPCDATE | Periods for Authorization Check | 3 | ORGUNIT | Char 20 | nvarchar | 20 | 0 | | |
42 | TPCDATEN | Periods for Authorization Check | 3 | ORGUNIT | Char 20 | nvarchar | 20 | 0 | | |
TOPEngineering Change Management |
43 | ECM_CTXT | Context | 6 | ORGUNIT | Organizational Unit | varbinary | 16 | 0 | | |
44 | ECM_ORG | Organizational Unit | 2 | ORGUNIT | Organizational Unit | varbinary | 16 | 0 | | |
TOPEnterprise Compensation Management |
45 | T71ADM_PROC_EE | Compensation Tracking: Employee Assignments | 7 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
TOPGlobal Trade Services |
46 | /SAPSLL/BOPHDORG | GTS: General Bill of Product - Org. Object Assignment | 4 | ORGUNIT | Business Partner Number | nvarchar | 10 | 0 | | |
TOPGovernance, Risk and Compliance |
47 | GRFNTASKPLAN | Data for task plan | 5 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
48 | GRFN_ORM_PROT | ORM Transfer: Log | 2 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
TOPGRC Risk Management |
49 | /ORM/ORMTEVNT | The ILD Event Main table | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
TOPImplementation Guide |
50 | TPRORGUNITS | Organizational Units Affected in a Project | 3 | ORGUNIT | Organizational Unit in a Project | nvarchar | 60 | 0 | | |
TOPLoans Management |
51 | TTONFTVDARL | Test neue Fima: Grunddaten und VDARL | 166 | ORGUNIT | Organisationseinheit | nvarchar | 12 | 0 | | |
52 | VDARL | Loans | 152 | ORGUNIT | Organizational Unit | nvarchar | 12 | 0 | | |
53 | VDCORR_ALOI | Loans: Search Index for Correspondence (Document Finder) | 20 | ORGUNIT | Organizational Unit | nvarchar | 12 | 0 | | |
TOPManagement of Internal Controls |
54 | FOPCAISOU | Assignment of AIS Systems to the Org Units | 2 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
55 | FOPCCORPORATE | MIC: Corporate Objects | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
56 | FOPCDEFICORG | MIC: Deficiency Analysis Status for Org Unit | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
57 | FOPCPRTUSERPARA | User Parameters for Print | 5 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
58 | FOPCRBFAGLUE | Reporting Buffer: Account Group - Fin. Statement Assertion | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
59 | FOPCRBFCASETEXTS | Report Buffer: Cases - Texts | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
60 | FOPCRBFIS | Reporting Buffer: Cases - Issues | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
61 | FOPCRBFMC | Reporting Buffer: Buffered Structures | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
62 | FOPCRBFPGLUE | Reporting Buffer: P-CO-R | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
63 | FOPCRBFPL | Reporting Buffer: Cases - Remediation Plans | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
64 | FOPCRBFSTR | Reporting Buffer: Buffered Structures | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
65 | FOPCRBFTL | Reporting Buffer: Cases - Test Logs | 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
66 | FOPCSHM | Setting for Shared Memory | 2 | ORGUNIT | Organizational Hierarchy | nvarchar | 1 | 0 | | |
67 | FOPCSIGNOFF | Sign-Off | 5 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
68 | FOPCTASKFREQ | Frequency of the Tasks | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
69 | FOPCTASKFREQ_TF | Timeframes of Tasks That Can Be Scheduled at Corporate Level | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
70 | FOPCTASKFREQ_TFC | Controls for Timeframes of Tasks that Can Be Scheduled | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
71 | FOPCUSERDATA | User-Specific Settings | 5 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | | |
72 | FOPC_ORM_PROT | ORM Transfer: Log | 4 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
TOPMaster Data |
73 | TD19 | Organizational Unit (Contract Management) | 2 | ORGUNIT | Organizational Unit | nvarchar | 12 | 0 | | |
74 | TD19T | Organizational Unit (Contract Management) | 3 | ORGUNIT | Organizational Unit | nvarchar | 12 | 0 | | |
TOPProcess Controls |
75 | GRPCAISOU | Assignment of AIS Systems to the Org Units | 2 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
76 | GRPCAODDATA | aod data | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
77 | GRPCAODGROUP | aod group | 4 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
78 | GRPCAODGRPCTRL | relation table for aod group and it's controls | 5 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
79 | GRPCAODORG | aod org | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
80 | GRPCCORPORATE | PC: Corporate Objects | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
81 | GRPCDEFICORG | PC: Deficiency Analysis Status for Org Unit | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
82 | GRPCPRTUSERPARA | User Parameters for Print | 5 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
83 | GRPCRBFAGLUE | Reporting Buffer: Account Group - Fin. Statement Assertion | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
84 | GRPCRBFAS | Reporting Buffer: Cases - Assessments | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
85 | GRPCRBFCASETEXTS | Report Buffer: Cases - Texts | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
86 | GRPCRBFIS | Reporting Buffer: Cases - Issues | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
87 | GRPCRBFMC | Reporting Buffer: Buffered Structures | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
88 | GRPCRBFPGLUE | Reporting Buffer: P-CO-R | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
89 | GRPCRBFPL | Reporting Buffer: Cases - Remediation Plans | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
90 | GRPCRBFSTR | Reporting Buffer: Buffered Structures | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
91 | GRPCRBFTL | Reporting Buffer: Cases - Test Logs | 3 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
92 | GRPCSHM | Setting for Shared Memory | 2 | ORGUNIT | Organizational Hierarchy | nvarchar | 1 | 0 | | |
93 | GRPCSIGNOFF | Sign-Off | 5 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
94 | GRPCTASKFREQ | Obsolete: Frequency of the Tasks | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
95 | GRPCTASKFREQ_TF | Obsolete: Tasks That Can Be Scheduled at Corporate Level | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
96 | GRPCTASKFREQ_TFC | Obsolete: Timeframes of Tasks that Can Be Scheduled | 3 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
97 | GRPCTASKPLAN | Obsolete: Data for task plan | 5 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
98 | GRPCUSERDATA | User-Specific Settings | 5 | ORGUNIT | Organization ID | nvarchar | 8 | 0 | | |
99 | GRPC_ORM_PROT | ORM Transfer: Log | 4 | ORGUNIT | Object ID | nvarchar | 8 | 0 | | |
TOPRecords and Case Management |
100 | RMPS_DISUNIT | Retention Unit, Record Segment | 11 | ORGUNIT | Place/Organizational Unit Initiating Record | nvarchar | 30 | 0 | | |