SAP ABAP Table CRMT_BILLING_EXT (Billing Data: External Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BILLING (Package) CRM billing data

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BILLING_EXT	Table Relationship Diagram
Short Description	Billing Data: External Fields

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

Foreign Keys

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

History

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