SAP CRMT_BP_RELATIONS_BW table - CRM: Extraction Partner Relationships Incl.Attributes for BW details in SAP

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

Description: BP Relationship Number
Field Name: RELNR
Data Element: BU_RELNR
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_RELNR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field RELNR

Description: Business Partner Number
Field Name: PARTNER1
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field PARTNER1

Description: Business Partner Number
Field Name: PARTNER2
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field PARTNER2

Description: Direction of a Business Partner Relationship
Field Name: RELDIR
Data Element: CRM_BU_RELDIR_BW
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_BU_RELDIR_BW
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELDIR

Description: Business Partner Relationship Category
Field Name: RELTYP
Data Element: BU_RELTYP
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: BU_RELTYP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELTYP

Description: Validity Date (Valid To)
Field Name: DATE_TO
Data Element: BU_DATTO
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_TO

Description: Validity Date (Valid From)
Field Name: DATE_FROM
Data Element: BU_DATFROM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_FROM

Description: Function of partner
Field Name: PAFKT
Data Element: BU_PAFKT
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: BU_PAFKT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAFKT

Description: Department
Field Name: ABTNR
Data Element: BU_ABTNR
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: BU_ABTNR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABTNR

Description: Partner's Authority
Field Name: PAAUTH
Data Element: BU_PAAUTH
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BU_PAAUTH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAAUTH

Description: VIP Partner
Field Name: PAVIP
Data Element: BU_PAVIP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BU_PAVIP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAVIP

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

Description: City postal code
Field Name: POST_CODE1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE1

Description: City
Field Name: CITY1
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY1

Description: Street
Field Name: STREET
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET

Description: House Number
Field Name: HOUSE_NUM1
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NUM1

Description: First telephone no.: dialling code+number
Field Name: TEL_NUMBER
Data Element: AD_TLNMBR1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL_NUMBER

Description: First Fax No.: Area Code + Number
Field Name: FAX_NUMBER
Data Element: AD_FXNMBR1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX_NUMBER

Description: E-Mail Address
Field Name: SMTP_ADDR
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field SMTP_ADDR

Description: Percentage of Capital Interest
Field Name: CMPY_PART_PER
Data Element: BU_COMPANY_PART_PER
Data Type: DEC
length (Dec): 10(7)
Check table:
Conversion Routine:
Domain Name: DEC3_7
MemoryID:
AppClass: FVV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CMPY_PART_PER

Description: Amount of Capital Interest
Field Name: CMPY_PART_AMO
Data Element: BU_COMPANY_PART_AMO
Data Type: CURR
length (Dec): 13(2)
Check table:
Conversion Routine:
Domain Name: WERTV7
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CMPY_PART_AMO

Description: Currency Key
Field Name: CMPY_PART_CUR
Data Element: WAERS
Data Type: CUKY
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: WAERS
MemoryID: FWS
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CMPY_PART_CUR

Description: Indicator: Shareholder Controls Company/Partnership
Field Name: CMPY_CONTROL
Data Element: BU_COMPANY_CONTROL
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BU_COMPANY_CONTROL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CMPY_CONTROL

Description: Indicator: Deleted
Field Name: FLG_DELETED
Data Element: BU_DELETED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLG_DELETED