PRD_PROC
Product: Draft PROCUREMENT Node
PRD_PROC is an SAP database table in S/4HANA. Product: Draft PROCUREMENT Node. It contains 12 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Productprocurementd | view | from | BASIC |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | draftkey | /BOBF/CONF_KEY | NodeID | |||
| parentdraftkey | /BOBF/CONF_KEY | NodeID | ||||
| hasactiveentity | BOOLE_D | TRUE | ||||
| activeproduct | PRODUCTNUMBER | Product | ||||
| purchaseorderquantityunit | PURORDERQUANTITYUNIT | Order Unit | ||||
| purchasingacknprofile | PURCHASINGACKNPROFILE | Purch.value key | ||||
| varblpurordunitstatus | VARBLPURORDUNITISACTIVE | Var. Order Unit | ||||
| manufacturernumber | MANUFACTURERNUMBER | Manufacturer No | ||||
| sourceofsupplycategory | SRCOFSUPPLYCATEGORY | Supply source | ||||
| purchasinggroup | PURCHASINGGROUP | Purch. group | ||||
| dummy_prd_incl_eew_ps | PRD_INCL_EEW | Dummy Field |
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.
-- Product: Draft PROCUREMENT Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_PROC (
CLIENT, -- Client [MANDT]
DRAFTKEY, -- NodeID [/BOBF/CONF_KEY]
PARENTDRAFTKEY, -- NodeID [/BOBF/CONF_KEY]
HASACTIVEENTITY, -- TRUE [BOOLE_D]
ACTIVEPRODUCT, -- Product [PRODUCTNUMBER]
PURCHASEORDERQUANTITYUNIT, -- Order Unit [PURORDERQUANTITYUNIT]
PURCHASINGACKNPROFILE, -- Purch.value key [PURCHASINGACKNPROFILE]
VARBLPURORDUNITSTATUS, -- Var. Order Unit [VARBLPURORDUNITISACTIVE]
MANUFACTURERNUMBER, -- Manufacturer No [MANUFACTURERNUMBER]
SOURCEOFSUPPLYCATEGORY, -- Supply source [SRCOFSUPPLYCATEGORY]
PURCHASINGGROUP, -- Purch. group [PURCHASINGGROUP]
DUMMY_PRD_INCL_EEW_PS, -- Dummy Field [PRD_INCL_EEW]
PRIMARY KEY (CLIENT, DRAFTKEY)
);
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