SDSLS_SORPRGELM
Sales Order Request Pricing Element
SDSLS_SORPRGELM is an SAP database table in S/4HANA. Sales Order Request Pricing Element. It contains 10 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SlsOrdReqItmPricingElement | view_entity | from | BASIC | Sales Order Request Item Pricing Element |
| I_SlsOrdReqPricingElement | view_entity | from | BASIC | Sales Order Request Pricing Element |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | salesorderrequest | sd_sales_order_request | Sales Order Request | |||
| KEY | salesorderrequestitem | sd_sales_order_request_item | Item | |||
| KEY | slsordreqprcgcndnincrement | vfprc_cond_count | Counter | |||
| conditiontype | kscha | Condition Type | ||||
| conditionrateamount | vfprc_rate_amount | Condition Amount | ||||
| conditionrateratio | vfprc_element_ratio | Ratio | ||||
| conditioncurrency | waers | Currency | ||||
| conditionquantity | kpein | Pricing Unit | ||||
| conditionquantityunit | kvmei | Condition Unit |
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.
-- Sales Order Request Pricing Element
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SORPRGELM (
MANDT, -- Client [mandt]
SALESORDERREQUEST, -- Sales Order Request [sd_sales_order_request]
SALESORDERREQUESTITEM, -- Item [sd_sales_order_request_item]
SLSORDREQPRCGCNDNINCREMENT, -- Counter [vfprc_cond_count]
CONDITIONTYPE, -- Condition Type [kscha]
CONDITIONRATEAMOUNT, -- Condition Amount [vfprc_rate_amount]
CONDITIONRATERATIO, -- Ratio [vfprc_element_ratio]
CONDITIONCURRENCY, -- Currency [waers]
CONDITIONQUANTITY, -- Pricing Unit [kpein]
CONDITIONQUANTITYUNIT, -- Condition Unit [kvmei]
PRIMARY KEY (MANDT, SALESORDERREQUEST, SALESORDERREQUESTITEM, SLSORDREQPRCGCNDNINCREMENT)
);
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