SERVICEDEMAND
Enterprise Service Demand
SERVICEDEMAND is an SAP database table in S/4HANA. Enterprise Service Demand. It contains 14 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_ProjectDemandService | view_entity | from | BASIC | Project Demand for Service |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | projectdemandserviceuuid | TV_PROJ_DMND_SERVICE_UUID | Service Dmnd UUID | |||
| projectdemanduuid | TV_PROJ_DMND_UUID | Demand UUID | ||||
| material | TV_MATERIAL | Material Number | ||||
| materialgroup | TV_MATERIALGROUP | Material Group | ||||
| supplier | TV_DESIREDSUPPLIER | Desired Supplier | ||||
| purchasinginforecord | TV_INFORECORD | Demand Info Record | ||||
| purchasecontract | TV_PURCHASECONTRACT | Purchasing Doc Nmbr | ||||
| purchasecontractitem | TV_PURCHASECONTRACTITEM | Contract Item Numbr | ||||
| materialplanneddeliverydurn | TV_PLANNEDDELIVERYTIME | Pl. Deliv. Time | ||||
| createdbyuser | ABP_CREATION_USER | Created By | ||||
| creationdatetime | ABP_CREATION_TSTMPL | Created On | ||||
| lastchangedbyuser | ABP_LASTCHANGE_USER | Changed By | ||||
| lastchangedatetime | ABP_LASTCHANGE_TSTMPL | Changed On |
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.
-- Enterprise Service Demand
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SERVICEDEMAND (
CLIENT, -- Client [MANDT]
PROJECTDEMANDSERVICEUUID, -- Service Dmnd UUID [TV_PROJ_DMND_SERVICE_UUID]
PROJECTDEMANDUUID, -- Demand UUID [TV_PROJ_DMND_UUID]
MATERIAL, -- Material Number [TV_MATERIAL]
MATERIALGROUP, -- Material Group [TV_MATERIALGROUP]
SUPPLIER, -- Desired Supplier [TV_DESIREDSUPPLIER]
PURCHASINGINFORECORD, -- Demand Info Record [TV_INFORECORD]
PURCHASECONTRACT, -- Purchasing Doc Nmbr [TV_PURCHASECONTRACT]
PURCHASECONTRACTITEM, -- Contract Item Numbr [TV_PURCHASECONTRACTITEM]
MATERIALPLANNEDDELIVERYDURN, -- Pl. Deliv. Time [TV_PLANNEDDELIVERYTIME]
CREATEDBYUSER, -- Created By [ABP_CREATION_USER]
CREATIONDATETIME, -- Created On [ABP_CREATION_TSTMPL]
LASTCHANGEDBYUSER, -- Changed By [ABP_LASTCHANGE_USER]
LASTCHANGEDATETIME, -- Changed On [ABP_LASTCHANGE_TSTMPL]
PRIMARY KEY (CLIENT, PROJECTDEMANDSERVICEUUID)
);
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