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