CRMS4D_PARTNER

Transparent Table Application Table
28 Fields 2 CDS Views

Customer Mgmt S4 DB Table for Business Partner Information

CRMS4D_PARTNER is an SAP database table in S/4HANA. Customer Mgmt S4 DB Table for Business Partner Information. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CustMgmtPartner view from BASIC Customer Management Partner
I_InvgCsMActyIncdntStaffUnit view from BASIC Basic View for ICM Activity and Incident Staff and Unit

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
KEY object_id CRMT_OBJECT_ID_DB Transaction ID
KEY number_int CRMS4_NUMBER_INT Item Number in Doc.
KEY partner_fct CRMT_PARTNER_FCT Partner func.
KEY partner_no CRMT_PARTNER_NO Partner Number
KEY no_type CRMT_PARTNER_NO_TYPE Internal No. Typ
compressed CRMT_PARTNER_COMPRESSED Compressed father
attributes CRMT_PARTNER_ATTRIBUTES Dep. Attributes
kind_of_entry CRMT_PARTNER_KIND_OF_ENTRY Partner origin
cust_attr_db COMT_PARTNER_CUST_ATTRIBUTES Attr
cust_rel_db COMT_PARTNER_CUST_RELATION Partner
mainpartner CRMT_PARTNER_MAIN Main Partner
relation_partner BU_PARTNER_GUID BP GUID
addr_nr AD_ADDRNUM Address Number
addr_np AD_PERSNUM Person Number
addr_type AD_ADRTYPE Address Type
partner_guid CRMT_PARTNER_GUID Partner GUID
addr_origin CRMT_ADDR_ORIGIN_MD Address Origi
std_bp_address CRMT_PARTNER_STD_BP_ADDRESS Stand. address
addr_operation BU_OPERATION Transaction
calendar CRMT_PARTNER_CALENDAR Calendar Maint
error_flag XFELD Checkbox
comp_prd_db CRMT_BOOLEAN Flag
display_type CRMT_PARTNER_DISPLAY_TYPE No. type
partner_pft CRMT_PARTNER_PFT Function category
partner_id BU_PARTNER Busn. Partner
bp_ref_adrnr SDPD_BP_REF_ADDRNUM BP Ref. Address Num.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Customer Mgmt S4 DB Table for Business Partner Information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_PARTNER (
    CLIENT,            -- Client [MANDT]
    OBJTYPE_H,         -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,         -- Transaction ID [CRMT_OBJECT_ID_DB]
    NUMBER_INT,        -- Item Number in Doc. [CRMS4_NUMBER_INT]
    PARTNER_FCT,       -- Partner func. [CRMT_PARTNER_FCT]
    PARTNER_NO,        -- Partner Number [CRMT_PARTNER_NO]
    NO_TYPE,           -- Internal No. Typ [CRMT_PARTNER_NO_TYPE]
    COMPRESSED,        -- Compressed father [CRMT_PARTNER_COMPRESSED]
    ATTRIBUTES,        -- Dep. Attributes [CRMT_PARTNER_ATTRIBUTES]
    KIND_OF_ENTRY,     -- Partner origin [CRMT_PARTNER_KIND_OF_ENTRY]
    CUST_ATTR_DB,      -- Attr [COMT_PARTNER_CUST_ATTRIBUTES]
    CUST_REL_DB,       -- Partner [COMT_PARTNER_CUST_RELATION]
    MAINPARTNER,       -- Main Partner [CRMT_PARTNER_MAIN]
    RELATION_PARTNER,  -- BP GUID [BU_PARTNER_GUID]
    ADDR_NR,           -- Address Number [AD_ADDRNUM]
    ADDR_NP,           -- Person Number [AD_PERSNUM]
    ADDR_TYPE,         -- Address Type [AD_ADRTYPE]
    PARTNER_GUID,      -- Partner GUID [CRMT_PARTNER_GUID]
    ADDR_ORIGIN,       -- Address Origi [CRMT_ADDR_ORIGIN_MD]
    STD_BP_ADDRESS,    -- Stand. address [CRMT_PARTNER_STD_BP_ADDRESS]
    ADDR_OPERATION,    -- Transaction [BU_OPERATION]
    CALENDAR,          -- Calendar Maint [CRMT_PARTNER_CALENDAR]
    ERROR_FLAG,        -- Checkbox [XFELD]
    COMP_PRD_DB,       -- Flag [CRMT_BOOLEAN]
    DISPLAY_TYPE,      -- No. type [CRMT_PARTNER_DISPLAY_TYPE]
    PARTNER_PFT,       -- Function category [CRMT_PARTNER_PFT]
    PARTNER_ID,        -- Busn. Partner [BU_PARTNER]
    BP_REF_ADRNR,      -- BP Ref. Address Num. [SDPD_BP_REF_ADDRNUM]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, PARTNER_FCT, PARTNER_NO, NO_TYPE)
);

Learn More