SAP ABAP Table CDBD_BILLING (Business transaction - billing - set)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CDB_ORDER (Package) CRM Order: CDB Objects for General Sales Order Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_BILLING	Table Relationship Diagram
Short Description	Business transaction - billing - set

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BILLING_GUID	☑	CDBT_BILLING_GUID	SYSUUID	RAW	16	0	Billing Set guid
3	ORDERADM_H_GUID	☐	CDBT_ORDERADM_H_GUID	SYSUUID	RAW	16	0	Order Header Guid
4	.INCLUDE	☐				0	0	Billing Data: External Fields
5	.INCLUDE	☐				0	0	Date Fields at Deadline Level: External Part
6	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
7	RULE_PERIOD_DATE	☐	CRMT_RULE_PERIOD_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Period Date	*
8	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
9	RULE_SETTL_FROM	☐	CRMT_RULE_SETTL_FROM	TIMERULEID	RAW	16	0	Rule for Determining Start of Settlement Period	*
10	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
11	RULE_SETTL_TO	☐	CRMT_RULE_SETTL_TO	TIMERULEID	RAW	16	0	Rule for Determining End of Settlement Period	*
12	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
13	RULE_BILL_DATE	☐	CRMT_RULE_BILL_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Next Billing Date	*
14	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
15	RULE_INVCR_DATE	☐	CRMT_RULE_INVCR_DATE	TIMERULEID	RAW	16	0	Rule for Determining Next Billing Document Creation Date	*
16	VALUE_DATE	☐	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
17	RULE_VALUE_DATE	☐	CRMT_RULE_VALUE_DATE	TIMERULEID	RAW	16	0	Rule for Origin of Next Fixed Value Date	*
18	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	TTZZ
19	.INCLUDE	☐				0	0	Billing Data: External Fields
20	SETTL_FIMA	☐	CRMT_SETTL_FIMA	BCOS_TSTMP	DEC	15	0	Internal Billing Date for Financial Mathematics
21	FIMA_KONDIND	☐	CRMT_FIMA_KONDIND		NUMC	10	0	Reference FIMA Condition Item
22	FIMA_BEWEIND	☐	CRMT_FIMA_BEWEIND		NUMC	10	0	Reference FIMA Flow Record
23	BILLING_BLOCK	☐	CRMT_BUS_BILL_BLOCK_REASON	CRM_BILLING_BLOCK	CHAR	2	0	Business Partner (CRM): Billing Block Reason	*
24	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
25	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
26	.INCLUDE	☐				0	0	External UBB Fields for a Billing Plan Date
27	PERIOD_TYPE	☐	CRMT_PERIOD_TYPE	CRM_PERIOD_TYPE	CHAR	2	0	Period Type (First, Last, First and Last, etc.)	*
28	LOC_GUID	☐	CRMT_LOC_GUID	SYSUUID_C	CHAR	32	0	Letter of Credit GUID from SAP Global Trade Services
29	LOC_REQUIRED	☐	CRMT_LOC_REQUIRED	CRM_BOOLEAN	CHAR	1	0	Letter of Credit required
30	LOC_EXT_NUMBER	☐	CRMT_LOC_EXTERNAL_NUMBER		CHAR	40	0	External Number Letter of Credit
31	.INCLUDE	☐				0	0	EEW Include
32	BILLING_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
33	.INCLUDE	☐				0	0
34	SEPA_ON	☐	CRMT_SEPA_ON	CRM_SEPA_ON	CHAR	1	0	Indicator for SEPA-Relevant Transactions
35	MANDATE_ID	☐	CRMT_MANDATE_ID	CRM_MANDATE_ID	CHAR	35	0	Unique Reference to Mandate per Payment Recipient
36	.INCLUDE	☐				0	0	Billing Data: Internal Fields
37	.INCLUDE	☐				0	0	Date Fields at Deadline Level: Internal Part
38	KIND_PERIOD_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
39	KIND_SETTL_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
40	KIND_SETTL_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
41	KIND_BILL_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
42	KIND_INVCR_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
43	KIND_VALUE_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
44	KIND_START_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
45	KIND_END_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
46	KIND_DATE_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
47	KIND_DATE_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
48	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
49	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
50	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
51	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
52	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
53	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
54	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

Foreign Keys

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

History

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