SAP ABAP Table CRMT_FS_BP_PRINT_PD (Structure for Personal Data of BP-Print)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IFS-MD-BP (Application Component) Business Partner
     ⤷ CRM_BSP_MODEL_IL_FSBP (Package) Model Implementation: FS Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_FS_BP_PRINT_PD	Table Relationship Diagram
Short Description	Structure for Personal Data of BP-Print

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	BPARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
3	LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
4	MIDDLENAME	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
5	SECONDNAME	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
6	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
7	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
8	TITLE_SPPL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
9	TITLE_SPPL_TXT	☐	AD_TITLEST	TEXT20	CHAR	20	0	Name supplement, e.g. noble title (written form)
10	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
11	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
12	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
13	FULLNAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
14	SEX	☐	BU_SEXID	BU_SEXID	CHAR	1	0	Sex of business partner (person)
15	BIRTHPLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
16	BIRTHDATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
17	DEATHDATE	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
18	MARITALSTATUS	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	TB027
19	MARITALSTATUS_TXT	☐	BU_BEZ20	TEXT20	CHAR	20	0	Short name
20	CORRESPONDLANGUAGE	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language	T002
21	CORRESPONDLANGUAGE_TXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
22	EMPLOYER	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
23	OCCUPATION	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	*
24	EMPLOYMENT	☐	BAPIBU_STATUS	BP_EMPLOYM	NUMC	2	0	Employment Status	*
25	EMPLOYMENT_TXT	☐	BP_EMPL_T	TEXT30	CHAR	30	0	Description of Employment Status
26	NATIONALITY	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
27	COUNTRYORIGIN	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	*
28	PARTNERLANGUAGE	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	*
29	TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
30	TITLE_TXT	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
31	PARTNEREXTERNAL	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
32	TITLELETTER	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
33	NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
34	NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
35	NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
36	NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
37	LEGALFORM	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
38	INDUSTRYSECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
39	INDUSTRY_TXT	☐	BU_TEXT20	TEXT20	CHAR	20	0	Description
40	FOUNDATIONDATE	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
41	LIQUIDATIONDATE	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
42	LOC_NO_1	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
43	LOC_NO_2	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
44	LEGALORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
45	BUSINESS_Y	☐	BP_BUSIN_Y	GJAHR	NUMC	4	0	Fiscal year
46	.INCLUDE	☐				0	0	Business Partner Master: Fiscal Year Information - General
47	BAL_SH_CUR	☐	BP_BAL_CUR	WAERS	CUKY	5	0	Balance Sheet Currency	TCURC
48	GEN_MEET_D	☐	BP_GE_ME_D	DATUM	DATS	8	0	Date of Annual Stockholders Meeting
49	BU_Y_BEGIN	☐	BP_B_Y_BEG	DATUM	DATS	8	0	Fiscal Year Start Date
50	BU_Y_END	☐	BP_B_Y_END	DATUM	DATS	8	0	Fiscal Year End Date
51	ANNUAL_ACC	☐	BP_ANN_ACC	XFELD	CHAR	1	0	Year-End Closing
52	ANNU_ACC_D	☐	BP_A_ACC_D	DATUM	DATS	8	0	Year-End Closing Date for Fiscal Year
53	CONS_FST_D	☐	BP_C_FST_D	DATUM	DATS	8	0	Date of Consolidated Financial Statements of Group Company
54	CAPI_STOCK	☐	BP_CAP_STK	WERTV8	CURR	15	2	Amount of Authorized Capital Stock for Company
55	SHAR_STOCK	☐	BP_SHA_STK	WERTV8	CURR	15	2	Amount of Issued Stock Capital for Company
56	PRSH_STOCK	☐	BP_PRS_STK	WERTV8	CURR	15	2	Amount of Participation Certificates Outstanding for Company
57	EQUITY	☐	BP_EQUITY	WERTV8	CURR	15	2	Amount of Equity Capital for Company
58	GROSS_AMNT	☐	BP_GROSS_A	WERTV8	CURR	15	2	Gross Premium
59	NET_AMOUNT	☐	BP_NET_A	WERTV8	CURR	15	2	Net Premium
60	TURNOVER	☐	BP_TURNOVR	WERTV8	CURR	15	2	Amount of Annual Sales for Company
61	NET_INCOME	☐	BP_NET_IN	WERTV8	CURR	15	2	Amount of Annual Net Income/Net Loss for Company
62	DIV_DIS_AM	☐	BP_DIV_DIS	WERTV8	CURR	15	2	Dividend/Profit Distribution Amount for Company
63	DEBTS_FACT	☐	BP_DEBTS_F	DEC3_3	DEC	6	3	Debt Ratio in Years
64	DIS_PROFIT	☐	BP_PROFIT	WERTV8	CURR	15	2	Amount of Annual Profit/Loss for Organization
65	BAL_AMOUNT	☐	BP_BAL_AMT	WERTV8	CURR	15	2	Amount of Balance Sheet Total for Company
66	STAFF_COUNT	☐	BP_STAFF_CNT	NUM7	NUMC	7	0	Number of Employees in Company
67	.INCLUDE	☐				0	0	Business Partner: Treasury Attributes, FY Data - Reserves
68	CAP_RES	☐	BP_CAP_RESERV	WERTV8	CURR	15	2	Amount of Capital Reserve for Company
69	REV_RES_LEG	☐	BP_REVENUE_RESERV_LEG	WERTV8	CURR	15	2	Amount of Legal Revenue Reserves for Company
70	REV_RES_OWN_SHR	☐	BP_REVENUE_RESERV_OWN_SHARES	WERTV8	CURR	15	2	Revenue Reserves for Own Stock
71	REV_RES_BY_LAWS	☐	BP_REVENUE_RESERV_BY_LAWS	WERTV8	CURR	15	2	Amount of Statutory Revenue Reserve for Company
72	REV_RES_OTHERS	☐	BP_REVENUE_RESERV_OTHERS	WERTV8	CURR	15	2	Amount of Other Revenue Reserves for Company
73	FORW_PROFIT_LOSS	☐	BP_FORWARD_PROFIT_LOSS	WERTV8	CURR	15	2	Amount of Profit/Loss Carried Forward for Company
74	LIABILIT_SECOND	☐	BP_LIABILIT_SECOND	WERTV8	CURR	15	2	Amount of Subordinated Liabilities for Company
75	.INCLUDE	☐				0	0	Business Partner: Treasury Attributes - FY Data Credit Stan.
76	RET_TOT_CAP_EMPL	☐	BP_RETURN_TOTAL_CAP_EMPL	BP_RETURN_CAPITAL	DEC	5	2	Return on Total Capital Employed for Company in Percent
77	REDUC_LONG_TERM	☐	BP_REDUC_LONG_TERM	DEC3_2	DEC	5	2	Debt Clearance Period in Years
78	COEFF_FINANCE	☐	BP_COEFF_FINANCE	DEC3_2	DEC	5	2	Financing Coefficient for Company in Percent
79	EQUITY_CAPIT	☐	BP_EQUITY_CAPIT	BP_EQUITY_CAPITAL	DEC	5	2	Equity Ratio of Company in Percent
80	NAMEGROUP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
81	NAMEGROUP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
82	GROUPTYPE	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	*
83	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
84	ADDRGUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
85	STANDARDADDRESS	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
86	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
87	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
88	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
89	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
90	POSTL_COD3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
91	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
92	PO_W_O_NO	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
93	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
94	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
95	POBOX_CTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
96	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
97	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
98	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
99	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
100	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
101	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
102	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
103	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
104	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
105	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
106	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
107	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
108	EXTADDRESSNUMBER	☐	BU_ADEXT	BU_ADEXT	CHAR	20	0	Address number in external system
109	VALIDFROMDATE	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
110	VALIDTODATE	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
111	TEL_NO	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
112	TEL_NO_MOB	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
113	FAX_NO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
114	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
115	URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
116	NET_INCOME_P	☐	BP_NET_INC	WERTV8	CURR	15	2	Net Annual Income
117	INCOME_CUR	☐	BAPIBP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	*
118	NET_INCOME_TXT	☐	CHAR100	CHAR100	CHAR	100	0	Character 100
119	CHILDREN	☐	BAPIBP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
120	VIP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
121	UNW_CUSTOMER	☐	BAPIBP_UNW_CUSTOMER	XFELD	CHAR	1	0	Undesirable Customer
122	CBPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
123	EMP_RESP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
124	EMP_RESP_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
125	EMP_RESP_TEL	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
126	EMP_RESP_FAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
127	EMP_RESP_MOBILE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
128	EMP_RESP_EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
129	SCORE	☐	CRMT_SCORE	CRM_SCORE	CHAR	10	0	Result Value of an Internal Creditworthiness Check
130	SCORE_DATE_FROM	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
131	SCORE_DATE_TO	☐	DATBI	DATUM	DATS	8	0	Valid To Date
132	SCORE_INFO	☐	CHAR100	CHAR100	CHAR	100	0	Character 100
133	CAT_TYPE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
134	FS_CLASS_TXT	☐	CHAR100	CHAR100	CHAR	100	0	Character 100
135	CUSTOMER_SINCE	☐	CRMT_CUSTOMER_SINCE	DATUM	DATS	8	0	Customer Since Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_FS_BP_PRINT_PD	BAL_SH_CUR	TCURC	WAERS
2	CRMT_FS_BP_PRINT_PD	CORRESPONDLANGUAGE	T002	SPRAS	REF	C	CN
3	CRMT_FS_BP_PRINT_PD	MARITALSTATUS	TB027	MARST		1	CN
4	CRMT_FS_BP_PRINT_PD	PREFIX1	TSAD4	PREFIX_KEY
5	CRMT_FS_BP_PRINT_PD	PREFIX2	TSAD4	PREFIX_KEY
6	CRMT_FS_BP_PRINT_PD	TITLE_ACA1	TSAD2	TITLE_KEY
7	CRMT_FS_BP_PRINT_PD	TITLE_ACA2	TSAD2	TITLE_KEY
8	CRMT_FS_BP_PRINT_PD	TITLE_SPPL	TSAD5	TITLE_KEY

History

Last changed by/on	SAP	20140117
SAP Release Created in	510