| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollateral Management System |
1 | TCMS_BPF | Business Partner Functions ( Customizing) | 2 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
2 | TCMS_BPF_BPF_SET | Business Partner Function Sets | 3 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
3 | TCMS_BPF_T | Business Partner Function Texts | 2 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
4 | TCMS_FSBP_MROLE | Invalid / Replaced in Rel3.0 by TCMS_FSBP_R2F | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
5 | TCMS_FSBP_R2F | Mapping FSBP-Role to CMS-Partner Function | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
TOPMaster Data |
6 | CMS_AST_BP | Asset -Business Partner Relationship | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
7 | CMS_CAG_BP | Collateral Agreement-Business Partner Relationship | 6 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
8 | CMS_CAG_RULES | Rule Details | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
9 | CMS_OMS_BP_LNK | Business Partner Link | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
TOPReal Estate |
10 | CMS_RE_OBJ_BP | Link between Real estate objects and BuPa is stored here | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
11 | CMS_RE_PRT_BP | Real Estate Part BP details | 6 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
12 | TCMS_RE_EX_BPRL | Customizing table for External BuPa roles | 3 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
TOPReceivable |
13 | CMS_RBL_BP | Receivable-Business Partner Relationshio | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |
TOPSecurities |
14 | CMS_SEC_ACC_BP | Link between securities account and BuPa is stored here | 5 | BPF | Business Partner Function | nvarchar | 6 | 0 | | |