SAP ABAP Table CRMT_BW_GCL_I (BW: Data Source for CRM Grantor Agreement)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
⤷ CRM_REPORT (Package) Operative Reporting in CRM
⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
⤷ CRM_REPORT (Package) Operative Reporting in CRM
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BW_GCL_I | Table Relationship Diagram |
Short Description | BW: Data Source for CRM Grantor Agreement |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | ORDERADM_H Data for BW DataSources | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
4 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
5 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
6 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
7 | DESCRIPTION_UC | CRMT_PROCESS_DESCRIPTION_UC | CRM_PROCESS_DESCRIPTION_UC | CHAR | 40 | 0 | Transaction Description (Upper Case) | ||
8 | DESCR_LANGUAGE | CRMT_PROCESS_DESCRIPTION_LANGU | SPRAS | LANG | 1 | 0 | Language Key of Description | * | |
9 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
10 | OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY | CRM_OJ_NAME_PROCESS | CHAR | 10 | 0 | Business Transaction Category | CRMC_SUBOB_CAT | |
11 | CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
12 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
13 | CHANGED_AT | CRMT_OPPT_CHANGED_AT | DATUM | DATS | 8 | 0 | Time of Last Change to the Transaction | ||
14 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
15 | RECORDMODE | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode | ||
16 | NUM_OF_HEAD | CRMT_NUMBER_OF_H | INT4 | INT4 | 10 | 0 | Order Header Number | ||
17 | OCCURRENCE | CRMT_OCC_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
18 | SCENARIO | CRMT_SCENARIO | CRM_SCENARIO | CHAR | 10 | 0 | Scenario Identity | ||
19 | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | CRM_TEMPLATE_TYPE | CHAR | 1 | 0 | Template Type of CRM Transaction | ||
20 | OCCURR_QUOT | CRMT_QUO_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
21 | OCCURR_CONT | CRMT_CON_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
22 | REF_UPDATE | CRMT_FLG_REF_UPDATE_BW | XFELD | CHAR | 1 | 0 | Flag: Ref. Update (Extract Structure Only Partially Filled) | ||
23 | INPUT_CHANNEL | CRMT_INPUT_CHANNEL | CRM_INPUT_CHANNEL | CHAR | 3 | 0 | Input channel | ||
24 | CREATED_TS | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
25 | CHANGED_TS | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
26 | .INCLUDE | 0 | 0 | ORDERADM_I Data for BW DataSources | |||||
27 | ITEM_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
28 | ITEM_CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
29 | ITEM_CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
30 | ITEM_CHANGED_AT | CRMT_OPPT_CHANGED_AT | DATUM | DATS | 8 | 0 | Time of Last Change to the Transaction | ||
31 | ITEM_CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
32 | ORDER_DATE | CRMT_OPPT_ORDER_DATE | DATUM | DATS | 8 | 0 | Posting Date | ||
33 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
34 | ITEM_OBJECT_TYPE | CRMT_SWO_OBJTYP_PROCESS_ITEM | CRM_OJ_NAME_PROCESS_ITEM | CHAR | 10 | 0 | CRM Item Object Type | * | |
35 | ITM_TYPE | CRMT_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
36 | NUMBER_OF_I | CRMT_NUMBER_OF_I | INT4 | INT4 | 10 | 0 | Order Item Number | ||
37 | BW_ASSIGN | CRMT_BW_ASSIGN | CRMT_BW_ASSIGN | CHAR | 1 | 0 | Assign BW and CO | ||
38 | ITM_USAGE | CRMT_ITEM_USAGE | CRM_ITEM_USAGE | CHAR | 2 | 0 | Usage of Higher-Level Item | ||
39 | ITM_TYPE_USAGE | CRMT_IT_TYPE_USAGE | CRM_IT_TYPE_USAGE | CHAR | 4 | 0 | Item Category Usage | * | |
40 | ALTERNATIVE | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
41 | PARENT | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
42 | ITM_BP | CRM_ISU_PARTNER_NO | CRM_ISU_PARTNER_NO | CHAR | 10 | 0 | Partner Number | ||
43 | ITEM_CREATED_TS | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
44 | ITEM_CHANGED_TS | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
45 | ORDER_DATE_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
46 | .INCLUDE | 0 | 0 | PARTNER (Sales) Data for BW DataSources | |||||
47 | SOLD_TO_PARTY | CRMT_SOLD_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Sold-To Party | * | |
48 | SHIP_TO_PARTY | CRMT_SHIP_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Ship-To Party | * | |
49 | BILL_TO_PARTY | CRMT_BILL_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Bill-To Party | * | |
50 | PAYER | CRMT_RP_PAYER | BU_PARTNER | CHAR | 10 | 0 | Payer | * | |
51 | SOLD_FROM | CRMT_SOLD_FROM_PARTY_ID | BU_PARTNER | CHAR | 10 | 0 | Salesperson ID | * | |
52 | .INCLUDE | 0 | 0 | PARTNER (General) Data for BW DataSoures | |||||
53 | SALES_EMPLOYEE | CRMT_SALES_EMPLOYEE | BU_PARTNER | CHAR | 10 | 0 | Employee | * | |
54 | PERSON_RESP | CRMT_PERSON_RESP | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible | * | |
55 | CONTACT_PERSON | CRMT_CONTACT_PERSON | BU_PARTNER | CHAR | 10 | 0 | Customer Contact Person | * | |
56 | SALESPARTNER | CRMT_SALESPARTNER | BU_PARTNER | CHAR | 10 | 0 | Sales Partners | * | |
57 | RESP_GROUP_RFW | CRMT_RESPONSIBLE_GROUP | BU_PARTNER | CHAR | 10 | 0 | Responsible Group | * | |
58 | PLANNING_ACCOUNT | CRMT_PLANNING_ACCOUNT | BU_PARTNER | CHAR | 10 | 0 | Planning Account | * | |
59 | .INCLUDE | 0 | 0 | Service Partner for BW Extraction | |||||
60 | SERVICE_TEAM | CRMT_SERVICE_TEAM | BU_PARTNER | CHAR | 10 | 0 | Service Team | * | |
61 | SERVICE_EMPLOYEE | CRMT_SERVICE_EMPLOYEE | BU_PARTNER | CHAR | 10 | 0 | Executing Service Employee | * | |
62 | .INCLUDE | 0 | 0 | BW Partner/Grantor | |||||
63 | PAYMENT_RECIPT | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
64 | PO_NUMBER_UC | CRMT_PO_NUMBER_UC | CHAR35 | CHAR | 35 | 0 | Sold-to Party's External Reference No. (in Capital Letters) | ||
65 | .INCLUDE | 0 | 0 | ORGMAN Data for BW DataSources | |||||
66 | SALES_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
67 | SALES_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
68 | SALES_OFFICE | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
69 | SALES_GROUP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
70 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
71 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
72 | SERVICE_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
73 | SERVICE_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
74 | PURCH_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
75 | PURCH_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
76 | PURCH_GROUP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
77 | IC_BD_CCODE | CRM_IC_BD_CCODE | BUKRS | CHAR | 4 | 0 | Company Code for a Business Transaction | * | |
78 | IC_BD_LOGSYS | CRM_IC_BD_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System for a Business Transaction | * | |
79 | .INCLUDE | 0 | 0 | SALES Data for BW DataSources | |||||
80 | CUST_GROUP1 | CRMT_CUST_GROUP1 | CRM_CUST_GROUP1 | CHAR | 3 | 0 | Customer Group 1 | * | |
81 | CUST_GROUP2 | CRMT_CUST_GROUP2 | CRM_CUST_GROUP2 | CHAR | 3 | 0 | Customer Group 2 | * | |
82 | CUST_GROUP3 | CRMT_CUST_GROUP3 | CRM_CUST_GROUP3 | CHAR | 3 | 0 | Customer Group 3 | * | |
83 | CUST_GROUP4 | CRMT_CUST_GROUP4 | CRM_CUST_GROUP4 | CHAR | 3 | 0 | Customer Group 4 | * | |
84 | CUST_GROUP5 | CRMT_CUST_GROUP5 | CRM_CUST_GROUP5 | CHAR | 3 | 0 | Customer Group 5 | * | |
85 | INDUSTRY | CRMT_INDUSTRY | CRM_INDUSTRY | CHAR | 4 | 0 | Industry Sector | * | |
86 | REJECTION | CRMT_REJECTION_CODE | CRM_REJECTION_CODE | CHAR | 2 | 0 | Cancellation Reason Code | * | |
87 | PROBABILITY | CRMT_ORDER_PROBABILITY | CRM_PROBABILITY | NUMC | 3 | 0 | Order Probability | ||
88 | PCAT_HDR_ID | COMT_PCAT_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Product Catalog Number | ||
89 | PCAT_VRT_ID | COMT_PCAT_VRT_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Catalog Variant Number | ||
90 | PCAT_CTY_ID | COMT_PCAT_CTY_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Catalog Area Number | ||
91 | ABNORMAL_DEMAND | CRMT_ABNORMAL_DEMAND | CRM_ABNORMAL_DEMAND | CHAR | 1 | 0 | Abnormal Demand | ||
92 | DLV_RELEVANCE | CRMT_DELIVERY_RELEVANT | CRM_DELIVERY_RELEVANT | CHAR | 1 | 0 | Delivery-Relevant | ||
93 | DATE_QTY_FIXED | CRMT_DATE_QTY_FIXED | CRM_BOOLEAN | CHAR | 1 | 0 | Fixed Date and Quantity | ||
94 | .INCLUDE | 0 | 0 | PRICING_H Data for BW DataSources | |||||
95 | EXCHG_TYPE | CRMT_EXCHG_TYPE | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
96 | EXCHG_DATE | CRMT_EXCHG_DATE | CRM_EXCHG_DATE | DATS | 8 | 0 | Exchange Rate Date | ||
97 | EXCHG_RATE | CRMT_EXCHG_RATE | CRM_EXCHG_RATE | DEC | 9 | 5 | Exchange Rate | ||
98 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
99 | PRICE_DATE | CRMT_PRICE_DATE | CRM_PRICE_DATE | DATS | 8 | 0 | Pricing Date | ||
100 | REF_CURRENCY | CRMT_REF_CURRENCY | WAERS | CUKY | 5 | 0 | Reference Currency | * | |
101 | PMNTTRMS | CRMT_PMNTTRMS | CRM_PMNTTRMS | CHAR | 4 | 0 | Terms of Payment | * | |
102 | CUST_GROUP | CRMT_CUST_GROUP | CRM_CUST_GROUP | CHAR | 2 | 0 | Customer Group | * | |
103 | CUSTOMER_TYPE | CRMT_CUSTOMER_TYPE | BU_KIND | CHAR | 4 | 0 | Business Partner Type | * | |
104 | .INCLUDE | 0 | 0 | PRICING_I Data for BW DataSources | |||||
105 | NET_VALUE_MAN | CRMT_NET_VALUE_MAN | WERTV8 | CURR | 15 | 2 | Total Expected Net Value Products in Document Currency | ||
106 | TARGET_VALUE | CRMT_TARGET_VALUE | WERTV10 | CURR | 19 | 2 | Target Value for Contracts | ||
107 | NET_PRICE | CRMT_NET_PRICE | WERTV8 | CURR | 15 | 2 | Net Price | ||
108 | NET_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
109 | TAX_AMOUNT | CRMT_TAX_AMOUNT | WERTV8 | CURR | 15 | 2 | Tax amount in document currency | ||
110 | FREIGHT | CRMT_FREIGHT | WERTV8 | CURR | 15 | 2 | Shipment costs in document currency | ||
111 | SUBTOTAL1 | CRMT_SUBTOTAL1 | WERTV8 | CURR | 15 | 2 | Subtotal 1 from pricing procedure for condition | ||
112 | SUBTOTAL2 | CRMT_SUBTOTAL2 | WERTV8 | CURR | 15 | 2 | Subtotal 2 from pricing procedure for condition | ||
113 | SUBTOTAL3 | CRMT_SUBTOTAL3 | WERTV8 | CURR | 15 | 2 | Subtotal 3 from pricing procedure for condition | ||
114 | SUBTOTAL4 | CRMT_SUBTOTAL4 | WERTV8 | CURR | 15 | 2 | Subtotal 4 from pricing procedure for condition | ||
115 | SUBTOTAL5 | CRMT_SUBTOTAL5 | WERTV8 | CURR | 15 | 2 | Subtotal 5 from pricing procedure for condition | ||
116 | SUBTOTAL6 | CRMT_SUBTOTAL6 | WERTV8 | CURR | 15 | 2 | Subtotal 6 from pricing procedure for condition | ||
117 | CREDIT_INDICATOR | CRMT_CREDIT_INDICATOR | CRMT_CREDIT_INDICATOR | CHAR | 1 | 0 | Credit Debit Indicator | ||
118 | GROSS_VALUE | CRMT_GROSS_VALUE | WERTV8 | CURR | 15 | 2 | Gross Order Value in PO Currency | ||
119 | .INCLUDE | 0 | 0 | SRV_OSSET Data for BW DataSources | |||||
120 | KATALOGART | COMT_CATALOG | COM_CATALOG | CHAR | 2 | 0 | Catalog | * | |
121 | CODEGRUPPE | QCODEGRP | QCODEGRP | CHAR | 8 | 0 | Code Group | * | |
122 | CODE | QCODE | QCODE | CHAR | 4 | 0 | Code | * | |
123 | ACT_REASON_CAT | COMT_CATALOG | COM_CATALOG | CHAR | 2 | 0 | Catalog | * | |
124 | ACT_REASON_GROUP | QCODEGRP | QCODEGRP | CHAR | 8 | 0 | Code Group | * | |
125 | ACT_REASON_CODE | QCODE | QCODE | CHAR | 4 | 0 | Code | * | |
126 | EXT_REFOBJ | CRMT_EXT_REFOBJ | CHAR40 | CHAR | 40 | 0 | External Reference Object | ||
127 | .INCLUDE | 0 | 0 | CRM BW Dates Grantor | |||||
128 | VALID_FROM | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
129 | VALID_TO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
130 | ITEM_VALFR | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
131 | ITEM_VALTO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
132 | DURA | TIMEDURA | TIMEDURA | DEC | 13 | 0 | Numerical Value of Duration | ||
133 | DUE_DATE | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
134 | DURA_UNIT | TIMEUNITDU | TIMEUNITNA | CHAR | 12 | 0 | Default Value for Time Unit | * | |
135 | EXPENSE_DATE | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
136 | .INCLUDE | 0 | 0 | CRM BW Grantor Business Agreement | |||||
137 | BUAG_GUID | CRMT_BUAG_GUID | SYSUUID | RAW | 16 | 0 | GUID of the Business Agreement | ||
138 | BUAG_ID | CRMT_BUAG_ID | CRMT_BUAG_ID | CHAR | 12 | 0 | Number of Business Agreement | ||
139 | BUAG_CLASS | CRMT_BUAG_CLASS | CRMT_BUAG_CLASS | CHAR | 10 | 0 | Business Agreement Class | * | |
140 | .INCLUDE | 0 | 0 | BILLING Data for BW DataSources | |||||
141 | BILLING_DATE | CRMT_BW_BILL_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Billing Date | ||
142 | BILLING_BLOCK | CRMT_BUS_BILL_BLOCK_REASON | CRM_BILLING_BLOCK | CHAR | 2 | 0 | Business Partner (CRM): Billing Block Reason | * | |
143 | LOC_GUID | CRMT_LOC_GUID | SYSUUID_C | CHAR | 32 | 0 | Letter of Credit GUID from SAP Global Trade Services | ||
144 | LOC_EXT_NUMBER | CRMT_LOC_EXTERNAL_NUMBER | CHAR | 40 | 0 | External Number Letter of Credit | |||
145 | BILLING_DATE_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
146 | .INCLUDE | 0 | 0 | CRM BW Grantor Billplan_D | |||||
147 | START_DATE | CRMT_DATE | DATUM | DATS | 8 | 0 | Date for Different Goals (Posting Date etc.) | ||
148 | END_DATE | CRMT_DATE | DATUM | DATS | 8 | 0 | Date for Different Goals (Posting Date etc.) | ||
149 | DATE_FROM | CRMT_DATE | DATUM | DATS | 8 | 0 | Date for Different Goals (Posting Date etc.) | ||
150 | DATE_TO | CRMT_DATE | DATUM | DATS | 8 | 0 | Date for Different Goals (Posting Date etc.) | ||
151 | ADD_BP_USAGE | CRMT_BP_USAGE | CRMT_BP_USAGE | CHAR | 1 | 0 | Billing Plan Usage | ||
152 | CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CHAR | 4 | 0 | Flow Category | ||
153 | RULE_PER_DATE_T | CRMT_RULE_PERIOD_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining the Period Date | ||
154 | PERCENTAGE | CRMT_BILL_PERCENTAGE | DEC3_2 | DEC | 5 | 2 | Percentage of Value to be Billed | ||
155 | BILLPLAN_TYPE | CRMT_BILLPLAN_TYPE | CRM_BILLPLAN_TYPE | CHAR | 2 | 0 | Billing Plan Type | * | |
156 | .INCLUDE | 0 | 0 | CUMULATED_H Data for BW Data Sources | |||||
157 | GROSS_VALUE_H | CRMT_GROSS_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Gross Value of Document in Document Currency | ||
158 | NET_VALUE_H | CRMT_NET_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Net Value of Document in Document Currency | ||
159 | NET_VALUE_MAN_H | CRMT_NET_VALUE_MAN_CUM | WERTV8 | CURR | 15 | 2 | Expected Total Net Value of Products in Document Currency | ||
160 | .INCLUDE | 0 | 0 | Time Characteristics for BW Reporting | |||||
161 | CALDAY | SMOCALDAY | DATUM | DATS | 8 | 0 | Calendar Day | ||
162 | CALDAY_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
163 | .INCLUDE | 0 | 0 | DOC_FLOW Data for BW - Grantor | |||||
164 | GPM_NODE_GUID | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
165 | GAP_H_GUID | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
166 | GAP_H_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
167 | GAP_I_GUID | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
168 | GAP_I_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
169 | GAG_H_GUID | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
170 | GAG_H_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
171 | GAG_I_GUID | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
172 | GAG_I_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
173 | GCL_H_GUID | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
174 | GCL_H_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
175 | GCL_I_GUID | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
176 | GCL_I_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
177 | .INCLUDE | 0 | 0 | STATUS GROUPS Data for BW Datasources | |||||
178 | BWSTONESYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
179 | BWSTONESYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
180 | BWSTONESYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
181 | BWSTONESYS3 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
182 | BWSTONESYS4 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
183 | BWSTONESYS5 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
184 | BWSTONESYS6 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
185 | BWSTONESYS7 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
186 | BWSTONESYS8 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
187 | BWSTONESYS9 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
188 | BWSTONESYSA | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
189 | BWSTTECSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
190 | BWSTTECSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
191 | BWSTTECSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
192 | BWSTLOCSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
193 | BWSTLOCSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
194 | BWSTLOCSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
195 | BWSTONESYSB | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
196 | BWSTONESYSC | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
197 | .INCLUDE | 0 | 0 | Grantor Status Groups Data for BW Datasources | |||||
198 | BWSTGRMSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
199 | BWSTGRMSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
200 | .INCLUDE | 0 | 0 | CRM BW Grantor Application Key Figures | |||||
201 | REQUESTED_AMT | PRCT_COND_RATE | WERTV8 | CURR | 15 | 2 | Condition Rate | ||
202 | ELIGIBLE_AMT | PRCT_COND_RATE | WERTV8 | CURR | 15 | 2 | Condition Rate | ||
203 | AUTHORIZED_AMT | PRCT_COND_RATE | WERTV8 | CURR | 15 | 2 | Condition Rate | ||
204 | CLEARED_AMT | PRCT_COND_RATE | WERTV8 | CURR | 15 | 2 | Condition Rate | ||
205 | HOLDBACK_AMT | PRCT_COND_RATE | WERTV8 | CURR | 15 | 2 | Condition Rate | ||
206 | BILLED_VALUE | CRMT_DOC_FLOW_VALUE | CRM_COND_VALUE | CURR | 19 | 2 | Value in Document Flow | ||
207 | TOTAL_BRI_AUTH | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
208 | .INCLUDE | 0 | 0 | CRM BW Grantor Expense | |||||
209 | EXPENSE_CATALOG | COMT_CATALOG | COM_CATALOG | CHAR | 2 | 0 | Catalog | * | |
210 | EXPENSE_TYPE | QCODE | QCODE | CHAR | 4 | 0 | Code | * | |
211 | EXPENSE_TYPE_GRP | QCODEGRP | QCODEGRP | CHAR | 8 | 0 | Code Group | * | |
212 | .INCLUDE | 0 | 0 | CRM BW Grantor Application Item Attributes | |||||
213 | FIN_EXE_TXT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BW_GCL_I | OBJECT_TYPE | CRMC_SUBOB_CAT | SUBOBJ_CATEGORY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 510 |