MOM052
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA