0BP_RELATIONS_ATTR

BP: Relationships | #ATTR | Extraction method: F1 | Delta: AIM | Component: Business Partner Master Data
Tables used: BUT053show details
Column Name Description
CLIENT Client
RELNR BP Relationship Number
PARTNER1 Business Partner Number
PARTNER2 Business Partner Number
RELTYP Business Partner Relationship Category
DATE_TO Validity Date (Valid To)
DATE_FROM Validity Date (Valid From)
Column Name Description
💲 Currency Key (CMPY_PART_CUR):
CMPY_PART_AMO Amount of Capital Interest
Column Name Description
Column Name Description
DATE_TO Validity Date (Valid To)
DATE_FROM Validity Date (Valid From)
Column Name Description
RELDIR Direction of a Business Partner Relationship Category Show values
CMPY_CONTROL Indicator: Shareholder Controls Company/Partnership Show values
FLG_DELETED Checkbox Show values
DQ_ONLINE_UPDATE SAP BP: Delta Queue Update Online Show values
DQ_OFFLINE_UPDATE SAP BP: Delta Queue Update Offline Show values
Column Name Description Domain name
PARTNER1_GUID Business Partner GUID SYSUUID
PARTNER2_GUID Business Partner GUID SYSUUID
PAFKT Function of partner BU_PAFKT
ABTNR Department BU_ABTNR
PAAUTH Partner's Authority BU_PAAUTH
PAVIP VIP Partner BU_PAVIP
COUNTRY Country/Region Key LAND1
POST_CODE1 City postal code CHAR10
CITY1 City TEXT40
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
TEL_NUMBER First telephone no.: dialling code+number CHAR30
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
SMTP_ADDR E-Mail Address AD_SMTPADR
CMPY_PART_PER Percentage of Capital Interest
ADDR_SHORT One-line short form of formatted address CHAR80
ADDR_SHORT_S One-line short form of formatted address CHAR80
LINE0 BP Address: Line 0 LINES
LINE1 BP Address: Line 1 LINES
LINE2 BP Address: Line 2 LINES
LINE3 BP Address: Line 3 LINES
LINE4 BP Address: Line 4 LINES
LINE5 BP Address: Line 5 LINES
LINE6 BP Address: Line 6 LINES
LINE7 BP Address: Line 7 LINES
LINE8 BP Address: Line 8 LINES
LINE9 BP Address: Line 9 LINES
DQ_TIMESTAMP Delta Queue Update Time Stamp TZNTSTMPS