PPS_PO_SUBCTR_D

Transparent Table Application Table
66 Fields 1 CDS Views

Draft table for entity R_PPS_POSUBCONTRGCOMPONENTTP

PPS_PO_SUBCTR_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_POSUBCONTRGCOMPONENTTP. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_POSubcontrgCompDrft view_entity from BASIC PurchaseOrder SubCont Comp - Draft

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchaseorder PPH_EBELN Purchasing Document
KEY purchaseorderitem PPH_EBELP Purchasing Document Item
KEY scheduleline EETEN Schedule Line
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
reservationitem PPH_RSPOS Reservation Item
recordtype PPH_RSART Reservation Record Type
material MATNR Material
ismaterialprovision BEIKZ Mat. Prov. Ind.
materialprovisiontype VDM_BEIKZ Material Provision Type
materialqtytobaseqtynmrtr UMREZ Numerator
materialqtytobaseqtydnmntr UMREN Denominator
materialrevisionlevel VDM_QM_REVLV Revision Level
materialcompisvariablesized ROHPS Var-Sized Item
materialcomponentisphantomitem PPH_DUMPS Phantom Item
reservation RSNUM Reservation
requiredquantity BDMNG Requirement qty
requirementdate PPH_BDTER Requirement Date
requirementtime PPH_BDZTP Requirement Time
reservationisfinallyissued KZEAR Final Issue
baseunit MEINS Base Unit
quantityinentryunit PPH_ERFMG Quantity in Unit of Entry
entryunit ERFME Unit of Entry
variablesizeitemquantity PPH_ROANZ Number of Variable-Size Components
variablesizeitemunit VDM_ROAME Variable-Size Item Unit
variablesizecomponentunit PPH_ROKME Variable-Size Component Unit
variablesizecomponentquantity PPH_ROMEN VSI Quantity
unitofmeasureforsize1to3 ROMEI Size unit
size1 ROMS1 Size 1
size2 ROMS2 Size 2
size3 ROMS3 Size 3
plant WERKS_D Plant
latestrequirementdate PPH_SBTER Latest Requirement Date
orderlevelvalue AUFST Order level
orderpathvalue AUFWG Order path
billofmaterialitemnumber VDM_SPOSN Bill Of Material Item Number
matlcompfreedefinedattribute SORTP Sort String
bomitemcategory PPH_POSTP BOM Item Category
isbulkmaterialcomponent SCHGT Bulk material
accountassignmentcategory PPH_KNTTP Account Assignment Category
inventoryspecialstocktype INVENTORYSPECIALSTOCKTYPE Special Stock Type
consumptionposting PPH_KZVBR Consumption Posting
inventoryspecialstockvalntype PPH_KZBWS Special Stock Valuation Type
debitcreditcode PPH_SHKZG Debit Credit Code
withdrawnquantity PPH_ENMNG Withdrawn Quantity
quantityisfixed FMENG Qty. is fixed
componentscrapinpercent KAUSF Component Scrap
operationscrapinpercent AVOAU Operation Scrap
isnetscrap NETAU Net Indicator
leadtimeoffset PPH_NLFZT Lead-Time Offset
quantitydistributionkey SA_VERTL Distribution
formulakey RFORM VSI Formula
storagelocation PPH_LGORT Storage Location
productionsupplyarea PPH_PRVBE Production Supply Area
batch CHARG_D Batch
bomitemdescription POTX1 Item Text
bomitemtext2 POTX2 Item Text
changenumber AENNR Change Number
purchaseorderdraftuuid SDRAFT_UUID Draft Document ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_PPS_POSUBCONTRGCOMPONENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PO_SUBCTR_D (
    MANDT,                           -- Client [MANDT]
    PURCHASEORDER,                   -- Purchasing Document [PPH_EBELN]
    PURCHASEORDERITEM,               -- Purchasing Document Item [PPH_EBELP]
    SCHEDULELINE,                    -- Schedule Line [EETEN]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    RESERVATIONITEM,                 -- Reservation Item [PPH_RSPOS]
    RECORDTYPE,                      -- Reservation Record Type [PPH_RSART]
    MATERIAL,                        -- Material [MATNR]
    ISMATERIALPROVISION,             -- Mat. Prov. Ind. [BEIKZ]
    MATERIALPROVISIONTYPE,           -- Material Provision Type [VDM_BEIKZ]
    MATERIALQTYTOBASEQTYNMRTR,       -- Numerator [UMREZ]
    MATERIALQTYTOBASEQTYDNMNTR,      -- Denominator [UMREN]
    MATERIALREVISIONLEVEL,           -- Revision Level [VDM_QM_REVLV]
    MATERIALCOMPISVARIABLESIZED,     -- Var-Sized Item [ROHPS]
    MATERIALCOMPONENTISPHANTOMITEM,  -- Phantom Item [PPH_DUMPS]
    RESERVATION,                     -- Reservation [RSNUM]
    REQUIREDQUANTITY,                -- Requirement qty [BDMNG]
    REQUIREMENTDATE,                 -- Requirement Date [PPH_BDTER]
    REQUIREMENTTIME,                 -- Requirement Time [PPH_BDZTP]
    RESERVATIONISFINALLYISSUED,      -- Final Issue [KZEAR]
    BASEUNIT,                        -- Base Unit [MEINS]
    QUANTITYINENTRYUNIT,             -- Quantity in Unit of Entry [PPH_ERFMG]
    ENTRYUNIT,                       -- Unit of Entry [ERFME]
    VARIABLESIZEITEMQUANTITY,        -- Number of Variable-Size Components [PPH_ROANZ]
    VARIABLESIZEITEMUNIT,            -- Variable-Size Item Unit [VDM_ROAME]
    VARIABLESIZECOMPONENTUNIT,       -- Variable-Size Component Unit [PPH_ROKME]
    VARIABLESIZECOMPONENTQUANTITY,   -- VSI Quantity [PPH_ROMEN]
    UNITOFMEASUREFORSIZE1TO3,        -- Size unit [ROMEI]
    SIZE1,                           -- Size 1 [ROMS1]
    SIZE2,                           -- Size 2 [ROMS2]
    SIZE3,                           -- Size 3 [ROMS3]
    PLANT,                           -- Plant [WERKS_D]
    LATESTREQUIREMENTDATE,           -- Latest Requirement Date [PPH_SBTER]
    ORDERLEVELVALUE,                 -- Order level [AUFST]
    ORDERPATHVALUE,                  -- Order path [AUFWG]
    BILLOFMATERIALITEMNUMBER,        -- Bill Of Material Item Number [VDM_SPOSN]
    MATLCOMPFREEDEFINEDATTRIBUTE,    -- Sort String [SORTP]
    BOMITEMCATEGORY,                 -- BOM Item Category [PPH_POSTP]
    ISBULKMATERIALCOMPONENT,         -- Bulk material [SCHGT]
    ACCOUNTASSIGNMENTCATEGORY,       -- Account Assignment Category [PPH_KNTTP]
    INVENTORYSPECIALSTOCKTYPE,       -- Special Stock Type [INVENTORYSPECIALSTOCKTYPE]
    CONSUMPTIONPOSTING,              -- Consumption Posting [PPH_KZVBR]
    INVENTORYSPECIALSTOCKVALNTYPE,   -- Special Stock Valuation Type [PPH_KZBWS]
    DEBITCREDITCODE,                 -- Debit Credit Code [PPH_SHKZG]
    WITHDRAWNQUANTITY,               -- Withdrawn Quantity [PPH_ENMNG]
    QUANTITYISFIXED,                 -- Qty. is fixed [FMENG]
    COMPONENTSCRAPINPERCENT,         -- Component Scrap [KAUSF]
    OPERATIONSCRAPINPERCENT,         -- Operation Scrap [AVOAU]
    ISNETSCRAP,                      -- Net Indicator [NETAU]
    LEADTIMEOFFSET,                  -- Lead-Time Offset [PPH_NLFZT]
    QUANTITYDISTRIBUTIONKEY,         -- Distribution [SA_VERTL]
    FORMULAKEY,                      -- VSI Formula [RFORM]
    STORAGELOCATION,                 -- Storage Location [PPH_LGORT]
    PRODUCTIONSUPPLYAREA,            -- Production Supply Area [PPH_PRVBE]
    BATCH,                           -- Batch [CHARG_D]
    BOMITEMDESCRIPTION,              -- Item Text [POTX1]
    BOMITEMTEXT2,                    -- Item Text [POTX2]
    CHANGENUMBER,                    -- Change Number [AENNR]
    PURCHASEORDERDRAFTUUID,          -- Draft Document ID [SDRAFT_UUID]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, SCHEDULELINE, DRAFTUUID)
);

Learn More