CRMS4D_PARTNER

Customer Mgmt S4 DB Table for Business Partner Information | #transactional | Component: S4CRM: Business Transaction Framework
Column Name Description
CLIENT FK Client
OBJTYPE_H FK Business Trans. Cat.
OBJECT_ID Transaction ID
NUMBER_INT Shortened Item Number in Document
PARTNER_FCT FK Partner func.
PARTNER_NO Partner Number
NO_TYPE Partner Number Type (e.g. GUID, Pers. No., ...), Internal Show values
Column Name Description
Column Name Description
Column Name Description
Column Name Description
NO_TYPE Partner Number Type (e.g. GUID, Pers. No., ...), Internal Show values
COMPRESSED Partner has Dependent, Compressed Records Show values
ATTRIBUTES Partner has Dependent Attributes Show values
KIND_OF_ENTRY Source of a partner in a transaction Show values
CUST_ATTR_DB Flag: Customizable Attributes Exist in Partner Show values
CUST_REL_DB Partner Relationship Exists Show values
MAINPARTNER Main Partner (For Ambiguous Partner Functions) Show values
ADDR_TYPE Address type (1=Organization, 2=Person, 3=Contact person) Show values
STD_BP_ADDRESS Standard Business Partner Address (Depending on Addr.Type) Show values
CALENDAR Maintain Calendar for the Partner? Show values
ERROR_FLAG Checkbox Show values
COMP_PRD_DB Logical Variable Show values
DISPLAY_TYPE Object Type, for Which Partner Number is to be Shown Show values
Column Name Description Domain name
RELATION_PARTNER Business Partner GUID SYSUUID
PARTNER_GUID GUID for an Individual Partner SYSUUID
ADDR_ORIGIN Origin of a Partner Address CRM_ADDR_ORIGIN_MD
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Client
  • Person Number
  • CRMS4D_PARTNER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • CRMS4D_PARTNER.[column in domain "AD_NATION"] == ADRP.NATION
  • CRMS4D_PARTNER.CLIENT == ADRP.CLIENT
  • CRMS4D_PARTNER.ADDR_NP == ADRP.PERSNUMBER
Address Number
  • Address Number
  • ?
  • ?
  • CRMS4D_PARTNER.CLIENT == ADRC.CLIENT
  • CRMS4D_PARTNER.ADDR_NR == ADRC.ADDRNUMBER
  • CRMS4D_PARTNER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • CRMS4D_PARTNER.[column in domain "AD_NATION"] == ADRC.NATION
Transaction for BP Address Determination
  • CRMS4D_PARTNER.CLIENT == TB008S.CLIENT
  • CRMS4D_PARTNER.ADDR_OPERATION == TB008S.OPERATION
Client CRMS4D_PARTNER.CLIENT == T000.MANDT
Business Trans. Cat. CRMS4D_PARTNER.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Partner func.
Business Partner Number
  • Business Partner Number
  • Client
  • CRMS4D_PARTNER.PARTNER_ID == BUT000.PARTNER
  • CRMS4D_PARTNER.CLIENT == BUT000.CLIENT