SAP ABAP Table CRMT_BUAG_JOIN (Structure for JOIN Access to CRMM_BUAG and CRMM_BUAG_H)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-BAG (Application Component) Business Agreements
     ⤷ CRM_BUPA_FRG0130 (Package) CRM Business Agreements for Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUAG_JOIN	Table Relationship Diagram
Short Description	Structure for JOIN Access to CRMM_BUAG and CRMM_BUAG_H

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	Business Partner: Business Agreement Set
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
4	VALID_TO	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
5	VALID_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
6	BABR_GUID	☐	CRMT_BABR_GUID	SYSUUID	RAW	16	0	Business Rule GUID
7	OWNER	☐	CRMT_BUAG_OWNER	CRMT_BUAG_OWNER	CHAR	1	0	Owner of the Business Agreement
8	.INCLUDE	☐				0	0	Business Agreement Data
9	BUAG_DEFAULT	☐	CRMT_BUAG_DEFAULT	CRMT_BUAG_DEFAULT	CHAR	1	0	Standard Business Agreement
10	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
11	REF_NUMBER	☐	CRMT_BUAG_REF_NUMBER	CHAR25	CHAR	25	0	Reference Number of Business Agreement
12	ADDR_CR_GUID	☐	CRMT_BUAG_CORR_ADDR_GUID	SYSUUID	RAW	16	0	Address GUID of Correspondence Address
13	BAPF_GUID	☐	BUAG_PF_GUID	SYSUUID	RAW	16	0	GUID of the Partner Functions for a Business Agreement
14	PPACC_H_GUID	☐	CRMT_ISX_PA_H_GUID	SYSUUID	RAW	16	0	BusAgr - Prepaid Account: GUID of Time Slice
15	PPACC_RELATION	☐	CRMT_ISX_PA_RELATION	CRM_ISX_PA_RELATION	CHAR	1	0	Business Agreement: Prepaid Account Relation
16	.INCLUDE	☐				0	0	Special Bill Agreements (Business Agreement)
17	BDID_IN	☐	CRMT_BUAG_BDID_IN	CHAR04	CHAR	4	0	Bank Details ID for Incoming Payments
18	BDID_OUT	☐	CRMT_BUAG_BDID_OUT	CHAR04	CHAR	4	0	Bank details ID for outgoing payments
19	CCARD_IN	☐	CRMT_BUAG_CCARD_IN	CHAR6	CHAR	6	0	Payment Card ID for Incoming Payments
20	CCARD_OUT	☐	CRMT_BUAG_CCARD_OUT	CHAR6	CHAR	6	0	Payment Card ID for Outgoing Payments
21	ADDR_DR_GUID	☐	CRMT_BUAG_DUNN_ADDR_GUID	SYSUUID	RAW	16	0	Address GUID for Alternative Dunning Recipient
22	ADDR_PY_GUID	☐	CRMT_BUAG_PAYER_ADDR_GUID	SYSUUID	RAW	16	0	Address GUID for Alternative Payer
23	ADDR_PR_GUID	☐	CRMT_BUAG_PAYREC_ADDR_GUID	SYSUUID	RAW	16	0	Address GUID fpr Alternative Payee
24	BUAG_PAYER	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
25	DIR_DEB_AMOUNT	☐	CRMT_BUAG_DD_AMOUNT	WRTV7	CURR	13	2	Direct Debit Limit
26	DIR_DEB_CURRENCY	☐	CRMT_BUAG_DD_CURRENCY	WAERS	CUKY	5	0	Currency of Direct Debit Limit	*
27	DIR_DEB_MONTHS	☐	CRMT_BUAG_DD_MONTHS	NUM02	NUMC	2	0	Number of Months for Calculation of Direct Debit Limit
28	DIR_DEB_ROLLING	☐	CRMT_BUAG_DD_ROLLING	XFELD	CHAR	1	0	Indicator: Rolling Calculation of Direct Debit Limit
29	SEPA_MNDID	☐	CRMT_BUAG_SEPA_MNDID	CRMT_BUAG_SEPA_MNDID	CHAR	35	0	Unique Reference to Mandate per Payment Recipient
30	.INCLUDE	☐				0	0	Special Bill Agreements (Business Agreement)
31	ADDR_IR_GUID	☐	CRMT_BUAG_INVREC_ADDR_GUID	SYSUUID	RAW	16	0	Address GUID for Alternative Bill-To Party
32	COLL_BILL_BUAG	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
33	.INCLUDE	☐				0	0	Tax (Business Agreement)
34	ADDR_TAX_GUID	☐	CRMT_BUAG_TAX_ADDR_GUID	SYSUUID	RAW	16	0	Address GUID for Tex-Relevant Address
35	TAX_CAT	☐	CRMT_BUAG_TAXCAT	CRMT_BUAG_TAXCAT	CHAR	2	0	Tax Type	*
36	TAX_CODE	☐	CRMT_BUAG_TAXCODE	CRMT_BUAG_TAXCODE	CHAR	2	0	Tax Characteristic	*
37	.INCLUDE	☐				0	0	Data Part of Table CRMM_BUAG (NH = Not Historical)
38	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
39	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
40	BUAG_TEXT35	☐	CRMT_BUAG_TEXT35	CRMT_BUAG_TEXT35	CHAR	35	0	Text for Business Agreement (length 35)
41	DELETION_FLAG	☐	CRMT_BUAG_DELETION_FLAG	CRMT_BUAG_DELETION_FLAG	CHAR	1	0	Deletion Indicator for Business Agreement
42	BUAG_ID_LEGACY	☐	CRMT_BUAG_ID_LEGACY	CHAR20	CHAR	20	0	Business Agreement Number in Legacy System
43	.INCLUDE	☐				0	0	BP Management Data for Instances of Sub-Objects
44	HOME_SYSTEM	☐	BU_HOME_SYSTEM	LOGSYS	CHAR	10	0	Business partner: Master system of data record	*
45	.INCLUDE	☐				0	0	Management Data for Data Records of a Table
46	CREATED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
47	CHANGED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
48	CREATED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
49	CHANGED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

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