CRMS4D_PARTNER - Customer Mgmt S4 DB Table for Business Partner Information

Customer Mgmt S4 DB Table for Business Partner Information information is stored in SAP table CRMS4D_PARTNER.
It is part of development package CRMS4_ORDER in software component CRM-S4-BTX. This development package consists of objects that can be grouped under "One Order: Redesign of Persistence Layer".

Fields for table CRMS4D_PARTNER

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6T000
OBJTYPE_HBusiness Trans. Cat.XCRMT_SUBOBJECT_CATEGORY_DBCHAR20CRMC_SUBOB_CAT
OBJECT_IDTransaction IDXCRMT_OBJECT_ID_DBCHAR20
NUMBER_INTShortened Item Number in DocumentXCRMS4_NUMBER_INTNUMC12
PARTNER_FCTPartner func.XCRMT_PARTNER_FCTCHAR16CRMC_PARTNER_FCT
PARTNER_NOPartner NumberXCRMT_PARTNER_NOCHAR64
NO_TYPEPartner Number Type (e.g. GUID, Pers. No., ...), InternalXCRMT_PARTNER_NO_TYPECHAR4
COMPRESSEDPartner has Dependent, Compressed RecordsCRMT_PARTNER_COMPRESSEDCHAR2
ATTRIBUTESPartner has Dependent AttributesCRMT_PARTNER_ATTRIBUTESCHAR2
KIND_OF_ENTRYSource of a partner in a transactionCRMT_PARTNER_KIND_OF_ENTRYCHAR2
CUST_ATTR_DBFlag: Customizable Attributes Exist in PartnerCOMT_PARTNER_CUST_ATTRIBUTESCHAR2
CUST_REL_DBPartner Relationship ExistsCOMT_PARTNER_CUST_RELATIONCHAR2
MAINPARTNERMain Partner (For Ambiguous Partner Functions)CRMT_PARTNER_MAINCHAR2
RELATION_PARTNERBusiness Partner GUIDBU_PARTNER_GUIDRAW16
ADDR_NRAddress NumberAD_ADDRNUMCHAR20ADRC
ADDR_NPPerson NumberAD_PERSNUMCHAR20ADRP
ADDR_TYPEAddress type (1=Organization, 2=Person, 3=Contact person)AD_ADRTYPECHAR2
PARTNER_GUIDGUID for an Individual PartnerCRMT_PARTNER_GUIDRAW16
ADDR_ORIGINOrigin of a Partner AddressCRMT_ADDR_ORIGIN_MDCHAR2
STD_BP_ADDRESSStandard Business Partner Address (Depending on Addr.Type)CRMT_PARTNER_STD_BP_ADDRESSCHAR2
ADDR_OPERATIONTransaction for BP Address DeterminationBU_OPERATIONCHAR12TB008S
CALENDARMaintain Calendar for the Partner?CRMT_PARTNER_CALENDARCHAR2
ERROR_FLAGCheckboxXFELDCHAR2
COMP_PRD_DBLogical VariableCRMT_BOOLEANCHAR2
DISPLAY_TYPEObject Type, for Which Partner Number is to be ShownCRMT_PARTNER_DISPLAY_TYPECHAR4
PARTNER_PFTPartner Function CategoryCRMT_PARTNER_PFTCHAR8CRMC_PARTNER_PFT
PARTNER_IDBusiness Partner NumberBU_PARTNERCHAR20BUT000
Privacy Policy