SAP ABAP Table CRMT_BUS050_BW (BW Extraction: BUT050 Extended to Include Deletion Indicator)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUPA_EXT (Package) CRM BP Extraction BW for Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUS050_BW	Table Relationship Diagram
Short Description	BW Extraction: BUT050 Extended to Include Deletion Indicator

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	BP relationships/role definitions: General data
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	RELNR	☐	BU_RELNR	BU_RELNR	CHAR	12	0	BP Relationship Number	*
4	PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
5	PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
6	DATE_TO	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
7	.INCLUDE	☐				0	0	SAB BP: General Management Data for BP Relationship
8	DATE_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
9	RELTYP	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category	*
10	XRF	☐	BU_XRF	XFELD	CHAR	1	0	Business partner role definition instead of BP relationship
11	DFTVAL	☐	BU_DFTVAL	CHAR20	CHAR	20	0	BP: Differentiation type characteristic (change doc.-rel.)
12	RLTYP	☐	BU_RLTYPE	BU_ROLE	CHAR	6	0	Business partner role (change doc.-relevant)	*
13	RELKIND	☐	BU_RELKIND	BU_RELKIND	CHAR	4	0	Business partner relationship type	*
14	CRUSR	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
15	CRDAT	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
16	CRTIM	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
17	CHUSR	☐	BU_CHUSR	USNAM	CHAR	12	0	Last user to change object
18	CHDAT	☐	BU_CHDAT	DATUM	DATS	8	0	Date when object was last changed
19	CHTIM	☐	BU_CHTIM	UZEIT	TIMS	6	0	Time at which object was last changed
20	.INCLUDE	☐				0	0	BP Relationships: Time-Dependent Attributes
21	XDFREL	☐	BU_XDFREL	XFELD	CHAR	1	0	Standard Relationship
22	XDFREL2	☐	BU_XDFREL	XFELD	CHAR	1	0	Standard Relationship
23	.INCLUDE	☐				0	0	BPR: SETGUIDs for Identifying Relationship Data Records
24	DB_KEY	☐	BUP_SETGUID	SYSUUID	RAW	16	0	GP: UUID for Identifying the Data Record (SETGUID)
25	DB_KEY_TD	☐	BUP_SETGUID	SYSUUID	RAW	16	0	GP: UUID for Identifying the Data Record (SETGUID)
26	FLG_DELETED	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BUS050_BW	CLIENT	T000	MANDT	KEY	1	CN
2	CRMT_BUS050_BW	PARTNER1	BUT000	PARTNER	KEY	1	CN
3	CRMT_BUS050_BW	PARTNER2	BUT000	PARTNER	KEY	1	CN

History

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