MOM052

Transparent Table Application Table

Workplace Addresses

MOM052 is an SAP database table in S/4HANA. Workplace Addresses. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FNDEI_MOM052_BLOCKINGINFO view from Blocking View for table mom052
FNDEI_mom052_FILTER view from Filter View for table mom052
I_BPEmployeeWorkplaceAddr view from BASIC Business Partner Employee Workplace address
I_WorkplaceAddress view from BASIC Employee Workplace Address
ICM_EMPLOYEE_CONTACT view from Employee

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY partner_guid BU_PARTNER_GUID BP GUID
KEY address_guid BU_WP_ADDRESS_GUID GUID of a Business Partner Workplace Address
org_addr_number AD_ADDRNUM Address Number
org_addr_origin BU_ORG_ADDR_ORIGIN Org.Addr.Origin
from_timestamp TZNTSTMPS Time Stamp
to_timestamp TZNTSTMPS Time Stamp

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.

-- Workplace Addresses
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MOM052 (
    CLIENT,           -- Client [MANDT]
    PARTNER_GUID,     -- BP GUID [BU_PARTNER_GUID]
    ADDRESS_GUID,     -- GUID of a Business Partner Workplace Address [BU_WP_ADDRESS_GUID]
    ORG_ADDR_NUMBER,  -- Address Number [AD_ADDRNUM]
    ORG_ADDR_ORIGIN,  -- Org.Addr.Origin [BU_ORG_ADDR_ORIGIN]
    FROM_TIMESTAMP,   -- Time Stamp [TZNTSTMPS]
    TO_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (CLIENT, PARTNER_GUID, ADDRESS_GUID)
);