SAP ABAP Table CRMT_REPORT_BILLING (Reporting Structure for CRMD_billing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_REPORT_BILLING	Table Relationship Diagram
Short Description	Reporting Structure for CRMD_billing

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	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	.INCLUDE	☐				0	0	Billing Data: External Fields
3	.INCLUDE	☐				0	0	Date Fields at Deadline Level: External Part
4	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
5	RULE_PERIOD_DATE	☐	CRMT_RULE_PERIOD_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Period Date	*
6	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
7	RULE_SETTL_FROM	☐	CRMT_RULE_SETTL_FROM	TIMERULEID	RAW	16	0	Rule for Determining Start of Settlement Period	*
8	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
9	RULE_SETTL_TO	☐	CRMT_RULE_SETTL_TO	TIMERULEID	RAW	16	0	Rule for Determining End of Settlement Period	*
10	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
11	RULE_BILL_DATE	☐	CRMT_RULE_BILL_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Next Billing Date	*
12	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
13	RULE_INVCR_DATE	☐	CRMT_RULE_INVCR_DATE	TIMERULEID	RAW	16	0	Rule for Determining Next Billing Document Creation Date	*
14	VALUE_DATE	☐	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
15	RULE_VALUE_DATE	☐	CRMT_RULE_VALUE_DATE	TIMERULEID	RAW	16	0	Rule for Origin of Next Fixed Value Date	*
16	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	TTZZ
17	.INCLUDE	☐				0	0	Billing Data: External Fields
18	SETTL_FIMA	☐	CRMT_SETTL_FIMA	BCOS_TSTMP	DEC	15	0	Internal Billing Date for Financial Mathematics
19	FIMA_KONDIND	☐	CRMT_FIMA_KONDIND		NUMC	10	0	Reference FIMA Condition Item
20	FIMA_BEWEIND	☐	CRMT_FIMA_BEWEIND		NUMC	10	0	Reference FIMA Flow Record
21	BILLING_BLOCK	☐	CRMT_BUS_BILL_BLOCK_REASON	CRM_BILLING_BLOCK	CHAR	2	0	Business Partner (CRM): Billing Block Reason	*
22	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
23	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
24	.INCLUDE	☐				0	0	External UBB Fields for a Billing Plan Date
25	PERIOD_TYPE	☐	CRMT_PERIOD_TYPE	CRM_PERIOD_TYPE	CHAR	2	0	Period Type (First, Last, First and Last, etc.)	*
26	LOC_GUID	☐	CRMT_LOC_GUID	SYSUUID_C	CHAR	32	0	Letter of Credit GUID from SAP Global Trade Services
27	LOC_REQUIRED	☐	CRMT_LOC_REQUIRED	CRM_BOOLEAN	CHAR	1	0	Letter of Credit required
28	LOC_EXT_NUMBER	☐	CRMT_LOC_EXTERNAL_NUMBER		CHAR	40	0	External Number Letter of Credit
29	.INCLUDE	☐				0	0	EEW Include
30	BILLING_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
31	.INCLUDE	☐				0	0
32	SEPA_ON	☐	CRMT_SEPA_ON	CRM_SEPA_ON	CHAR	1	0	Indicator for SEPA-Relevant Transactions
33	MANDATE_ID	☐	CRMT_MANDATE_ID	CRM_MANDATE_ID	CHAR	35	0	Unique Reference to Mandate per Payment Recipient
34	.INCLUDE	☐				0	0	Billing Data: Internal Fields
35	.INCLUDE	☐				0	0	Date Fields at Deadline Level: Internal Part
36	KIND_PERIOD_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
37	KIND_SETTL_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
38	KIND_SETTL_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
39	KIND_BILL_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
40	KIND_INVCR_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
41	KIND_VALUE_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
42	KIND_START_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
43	KIND_END_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
44	KIND_DATE_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
45	KIND_DATE_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
46	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
47	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_REPORT_BILLING	BILLING_TIMEZONE	TTZZ	TZONE	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A