| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/T_FMAPCOND | Field condition mapping | 9 | CONDTYPE | Condition Type | nvarchar | 1 | 0 | | |
2 | /AIF/T_FMAPCONDV | Field condition mapping variant | 12 | CONDTYPE | Condition Type | nvarchar | 1 | 0 | | |
3 | CNV_10020_COND | Conditions - Header data | 4 | CONDTYPE | Condition type | nvarchar | 2 | 0 | | |
4 | CNV_10020_CONDCC | Conditions complex | 6 | CONDTYPE | Condition type | nvarchar | 2 | 0 | | |
5 | CNV_10020_CONDT | Conditions - Descriptions | 5 | CONDTYPE | Condition type | nvarchar | 2 | 0 | | |
6 | CNV_10020_RULEP | Rules for components of non-transp. fields/determ. objects | 8 | CONDTYPE | Condition type | nvarchar | 2 | 0 | | |
7 | TIVXCITIREFT | Mapping of IRE Status to Contract-Flow type-Taxcode | 8 | CONDTYPE | IRE Condition Type for Payback Postings | nvarchar | 4 | 0 | | |
8 | TIVXCITSDINT | Settings of Italian Security Deposit Interest Calculation | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
9 | TIVYCCOND2EXP | Advance Payment Condition to Expence Types | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
10 | VIYCADVPAY | Advance Payments | 83 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
11 | VIYCRECEIVABLE | Receivables from Settlement | 7 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
12 | YTIVCDCONDTYPE | FAS13 Conditon types | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
13 | CMACDB_ITEMRES | Fee Calculation Line Results | 8 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPClinical System |
14 | N2DPREFETCH | IS-H*MED RAD: Prefetch rule | 5 | CONDTYPE | Condition type of a prefetch rule | nvarchar | 2 | 0 | | |
TOPDocument Management System |
15 | EDMS_CONDITION | Filter Conditions in Easy Document Management (Logically Or) | 6 | CONDTYPE | Kind of Filter Condition in Easy Document Management | nvarchar | 6 | 0 | | |
TOPDSD Connector |
16 | /DSD/ME_DEL_ITM | DSD CN: Delivery Items | 30 | CONDTYPE | DSD Connector: Condition Type | nvarchar | 4 | 0 | | |
17 | /DSD/ME_INV_ITM | DSD CN: Billing Doc. Items | 26 | CONDTYPE | DSD Connector: Condition Type | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
18 | TIVXCMSSPOSCE | Item in Schema: Assignment to Cost Element | 9 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
19 | TIVXCOTCOND | COA, Tax Information for Condition Type | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
20 | VISCS_RECEIVE | OBSOLETE: Receivables (Replaced by VISCRECEIVABLE) | 22 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
21 | VIXCRAESRREFI | Assignment of ISR Ref./Cash Flow Plan (Item) | 5 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPFunds Management |
22 | FMFG_RE_PPA_EX | RECN Condition: PPA Exclude Flag | 4 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPInformation System |
23 | TIVISPFCONDREL | Report Profile for Conditions: Properties | 6 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPLocalization |
24 | TIVXCFRCONDTYP | Condition types relevant for EO specific AP calculation | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
25 | TIVXCNLSUBSICOND | Define Condition Types for Subsidized Rent | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPPost Processing Framework |
26 | PPFTBADICO | PPF: Management Table for Method Conditions (BADI) | 3 | CONDTYPE | Type of Parameter Condition | nvarchar | 2 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
27 | TFMCA_PT_TAXCOND | Customizing for Tax Conditions (Property Tax) | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
28 | TIVXACDREVTYPREL | Assign Revenue Type to Condition Type | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
29 | TIVXACDRVTYPREL | Assign Revenue Type to Condition Type | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPReal Estate Contract |
30 | TIVCDCHGREAS | Reason for Change | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
31 | TIVCDCHGREAST | Reason for Change (Text) | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
32 | TIVCDCONDDEF | Default Condition | 4 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
33 | TIVCDCONDREL | Condition Type per Condition Group | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
34 | TIVCDCONDTYPE | Condition Type | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
35 | TIVCDCONDTYPET | Condition Type (Text) | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
36 | VICDCFOBJ | Object-Related Cash Flow | 78 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
37 | VICDCFPAY | Payment-Related Cash Flow | 79 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
38 | VICDCOND | Condition | 33 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
39 | VICDCONDCALC | Conditions - Calculation Factors and Condition Amounts | 6 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
40 | VICDCONDDIST | Conditions - Distribution Factors and Transfer Amounts | 6 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPRent Adjustment |
41 | TIVAJEXPGRPCD | Condition Type for Expense Item Group | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
42 | TIVAJRULECOND | Computability Provisions per Adjust.Rule and Condition Type | 4 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
43 | VIAJCEAPRESTG | Prestage Adjustment Record | 22 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPRental Accounting |
44 | VIRAADVPAY | OBSOLETE: Advance Payment | 4 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
45 | VIRAADVPAYEXT | Advance Payment - Legacy Data Transfer | 5 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
46 | VIRAADVPAYPROC | Advance Payments per Settlement | 13 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
47 | VIRAADVPAYSPLIT | Split Advance Payments | 10 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
48 | VIRADOCITEM | RE Document Item | 21 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
49 | VIRAINVITEM | RE Invoice Item | 7 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPRoom Reservations and Seating Arrangements |
50 | VIORRSCOST | Reservation - Costs | 10 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPSales-Based Rent and Settlement |
51 | VISRCALCADVPAY | Reference to Advance Payment Used | 6 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
52 | VISRCALCSUM | Calculation Results per Sales Rule | 13 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
TOPSAP Business Workflow |
53 | SWDSCONDEF | WF Definition: Conditions | 5 | CONDTYPE | WF: Type of condition | nvarchar | 2 | 0 | | |
54 | SWD_CONDEF | WF Definition/Runtime: Conditions | 6 | CONDTYPE | WF: Type of condition | nvarchar | 2 | 0 | | |
55 | SWJPHEAD | Header Table for Parameter Condition | 3 | CONDTYPE | Type of Parameter Condition | nvarchar | 2 | 0 | | |
TOPService Charge Settlement |
56 | TIVSCCONDSCK | Assignment of Condition Type to Service Charge Key | 2 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
57 | TIVSCDEFCOND | Assignment of Service Charge Key to Condition Type | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
58 | TIVSCMEAS2COND | Assignment of Measurement Type to Condition Type | 3 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
59 | VISCCNPART | Settlement Participation for Service Charge Settlement | 9 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
60 | VISCRECEIVABLE | Receivables from Settlement | 4 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |
61 | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) | 14 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | |