CRMD_ORGMAN_TEMP

Transparent Table Temporary Data
11 Fields 4 CDS Views

Temp. table for storing the org. model Sales area data

CRMD_ORGMAN_TEMP is an SAP database table in S/4HANA. Temp. table for storing the org. model Sales area data. It contains 11 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ResponsibleSalesOrgUnitIDVH view from BASIC Sales Organization Unit
I_SalesGroupOrgUnitIDVH view inner BASIC Sales Group in Service
I_SalesOfficeOrgUnitIDVH view inner BASIC Sales Office in Service
I_SubscrpnMassProcgSlsOrgUnt view_entity from BASIC Sales Organization Unit

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY otype otype Object type
KEY objid hrobjid Object ID
KEY findings om_scnactv Determination
KEY counter numc10 Field length 10
sales_org crmt_sales_org Sales Org. ID
sales_office crmt_sales_office Sales Office
sales_group crmt_sales_group Sales Group
dis_channel crmt_distribution_channel Distribution Channel
division crmt_division Division
is_sales_area flag Indicator

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.

-- Temp. table for storing the org. model Sales area data
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMD_ORGMAN_TEMP (
    CLIENT,         -- Client [mandt]
    OTYPE,          -- Object type [otype]
    OBJID,          -- Object ID [hrobjid]
    FINDINGS,       -- Determination [om_scnactv]
    COUNTER,        -- Field length 10 [numc10]
    SALES_ORG,      -- Sales Org. ID [crmt_sales_org]
    SALES_OFFICE,   -- Sales Office [crmt_sales_office]
    SALES_GROUP,    -- Sales Group [crmt_sales_group]
    DIS_CHANNEL,    -- Distribution Channel [crmt_distribution_channel]
    DIVISION,       -- Division [crmt_division]
    IS_SALES_AREA,  -- Indicator [flag]
    PRIMARY KEY (CLIENT, OTYPE, OBJID, FINDINGS, COUNTER)
);

Learn More