EHPMAD_SVT_PURCO

Transparent Table Application Table
52 Fields 1 CDS Views

SVT Purchase Confirmed Quantities Table

EHPMAD_SVT_PURCO is an SAP database table in S/4HANA. SVT Purchase Confirmed Quantities Table. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SVTPurgPrprocgDocument view from BASIC SVT purchasing preprocessing document

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY svtconfirmedpurchasingdocuuid EHPMA_SVT_PURG_CONFD_DOC_UUID Purg Confd Qty UUID
isdeleted EHPMA_SVT_IS_DELETED Object is deleted
postingdate EHFND_DATE Date
postingdatecreationtime EHPMA_SVT_POSTING_DATETIME Posting DateTime
creationtimelogsystem EHPMA_SVT_CREATION_TIME Creation Time
creationdatetimelogsystem EHPMA_SVT_CREATION_DATETIME Creation Date Time
material MATNR Material
goodsmovementtype BWART Movement Type
materialdocumentyear MJAHR Mat. Doc. Year
materialdocumentitem MBLPO Mat. Doc.Item
debitcreditcode SHKZG Debit/Credit
accountingdocumenttype BLART Document Type
inventorytransactiontype VGART Trans. Ev. Type
materialdocument EHPMA_SVT_MATERIAL_DOC_NUMBER Mat. Doc. Number
lastchangedatetime EHPMA_SVT_LAST_CHANGE_DATETIME Ch. Date Time
materialquantity EHPMA_SVT_MAT_QUANTITY Material Quantity
materialquantityunit EHPMA_SVT_MAT_QUANTITY_UNIT Material Qty Unit
docsourceexternalsystem EHPMA_SVT_DOC_SOURCE_SYSTEM Source System
docsourceinternallogicalsystem EHPMA_SVT_INT_LOGICAL_SYSTEM Int Logical System
processedstatus EHPMA_SVT_PROCESSED_STATUS Processing Status
prodcmplnceventuuid EHFND_PCE_UUID Product Compliance Event
prodcmplncexclcoplntuuid EHPMA_SVT_EXCL_CMPN_PLNT_UUID Excl Cmpn Plnt UUID
orderquantity MB_BSTMG Qty in OUn
orderquantityuom BSTME Order Unit
businesspartnersupplier EHFND_BUPA_SUPPLIER Supplier
supplierid EHFND_SUPPLIER Supplier
supplieraddressid EHFND_ADDR_NUMBER Address No.
receivingplant EHPMA_SVT_RECEIVING_PLANT Receiving Plant
receivingcountry EHPMA_SVT_RCVG_COUNTRY Rcvg Cntry/Reg
deliveringcountry EHPMA_SVT_DELIVERING_COUNTRY Delivering Ctry/Reg
supplierisimporter EHPMA_SVT_SUPPLIER_IS_IMPORTER Supplier is importer
purchaseorder EBELN Purchasing Doc.
purchaseorderitem EBELP Item
purchasingdocumentcategory BSTYP Doc. Category
purchasingdocumenttype BSART Order Type
purchasingdocumentitemcategory PSTYP Item Category
receivingcompanycode EHPMA_SVT_RCVG_COMPANY_CODE Rcvg Co Code
deliveringregion EHPMA_SVT_DELIVERING_REGION Delivering Region
deliveringplant EHPMA_SVT_DELIVERING_PLANT Delivering Plant
svtcalculatedsupplier EHFND_BUPA_SUPPLIER Supplier
svtcalculatedsupplierid EHFND_SUPPLIER Supplier
svtcalulatedsupplierfunction PARVW Partner Functn
svtcalulatedsupplieraddressid EHFND_ADDR_NUMBER Address No.
receivingregion EHPMA_SVT_RCVG_REGION Receiving Region
isreturnsitem RETPO Returns Item
receivingstoragelocation EHPMA_SVT_RECEIVING_STOR_LOC RecStorLoc
deliveringstoragelocation EHPMA_SVT_DELIVERING_STOR_LOC Deliv. Stor. Loc.
imprtrespycalcdrespimporter EHPMA_RESP_IMPORTER_CALCD Calcd Resp Importer
imprtrespymntndrespimporter EHPMA_RESP_IMPORTER_MNTND Mntnd Resp Importer
sourceisbondedwarehouse EHPMA_SVT_SOURCE_IS_BWRHS Is Bonded Wrhs
targetisbondedwarehouse EHPMA_SVT_TARGET_IS_BWRHS Is Bonded Wrhs

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.

-- SVT Purchase Confirmed Quantities Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHPMAD_SVT_PURCO (
    CLIENT,                          -- Client [MANDT]
    SVTCONFIRMEDPURCHASINGDOCUUID,   -- Purg Confd Qty UUID [EHPMA_SVT_PURG_CONFD_DOC_UUID]
    ISDELETED,                       -- Object is deleted [EHPMA_SVT_IS_DELETED]
    POSTINGDATE,                     -- Date [EHFND_DATE]
    POSTINGDATECREATIONTIME,         -- Posting DateTime [EHPMA_SVT_POSTING_DATETIME]
    CREATIONTIMELOGSYSTEM,           -- Creation Time [EHPMA_SVT_CREATION_TIME]
    CREATIONDATETIMELOGSYSTEM,       -- Creation Date Time [EHPMA_SVT_CREATION_DATETIME]
    MATERIAL,                        -- Material [MATNR]
    GOODSMOVEMENTTYPE,               -- Movement Type [BWART]
    MATERIALDOCUMENTYEAR,            -- Mat. Doc. Year [MJAHR]
    MATERIALDOCUMENTITEM,            -- Mat. Doc.Item [MBLPO]
    DEBITCREDITCODE,                 -- Debit/Credit [SHKZG]
    ACCOUNTINGDOCUMENTTYPE,          -- Document Type [BLART]
    INVENTORYTRANSACTIONTYPE,        -- Trans. Ev. Type [VGART]
    MATERIALDOCUMENT,                -- Mat. Doc. Number [EHPMA_SVT_MATERIAL_DOC_NUMBER]
    LASTCHANGEDATETIME,              -- Ch. Date Time [EHPMA_SVT_LAST_CHANGE_DATETIME]
    MATERIALQUANTITY,                -- Material Quantity [EHPMA_SVT_MAT_QUANTITY]
    MATERIALQUANTITYUNIT,            -- Material Qty Unit [EHPMA_SVT_MAT_QUANTITY_UNIT]
    DOCSOURCEEXTERNALSYSTEM,         -- Source System [EHPMA_SVT_DOC_SOURCE_SYSTEM]
    DOCSOURCEINTERNALLOGICALSYSTEM,  -- Int Logical System [EHPMA_SVT_INT_LOGICAL_SYSTEM]
    PROCESSEDSTATUS,                 -- Processing Status [EHPMA_SVT_PROCESSED_STATUS]
    PRODCMPLNCEVENTUUID,             -- Product Compliance Event [EHFND_PCE_UUID]
    PRODCMPLNCEXCLCOPLNTUUID,        -- Excl Cmpn Plnt UUID [EHPMA_SVT_EXCL_CMPN_PLNT_UUID]
    ORDERQUANTITY,                   -- Qty in OUn [MB_BSTMG]
    ORDERQUANTITYUOM,                -- Order Unit [BSTME]
    BUSINESSPARTNERSUPPLIER,         -- Supplier [EHFND_BUPA_SUPPLIER]
    SUPPLIERID,                      -- Supplier [EHFND_SUPPLIER]
    SUPPLIERADDRESSID,               -- Address No. [EHFND_ADDR_NUMBER]
    RECEIVINGPLANT,                  -- Receiving Plant [EHPMA_SVT_RECEIVING_PLANT]
    RECEIVINGCOUNTRY,                -- Rcvg Cntry/Reg [EHPMA_SVT_RCVG_COUNTRY]
    DELIVERINGCOUNTRY,               -- Delivering Ctry/Reg [EHPMA_SVT_DELIVERING_COUNTRY]
    SUPPLIERISIMPORTER,              -- Supplier is importer [EHPMA_SVT_SUPPLIER_IS_IMPORTER]
    PURCHASEORDER,                   -- Purchasing Doc. [EBELN]
    PURCHASEORDERITEM,               -- Item [EBELP]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [BSTYP]
    PURCHASINGDOCUMENTTYPE,          -- Order Type [BSART]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [PSTYP]
    RECEIVINGCOMPANYCODE,            -- Rcvg Co Code [EHPMA_SVT_RCVG_COMPANY_CODE]
    DELIVERINGREGION,                -- Delivering Region [EHPMA_SVT_DELIVERING_REGION]
    DELIVERINGPLANT,                 -- Delivering Plant [EHPMA_SVT_DELIVERING_PLANT]
    SVTCALCULATEDSUPPLIER,           -- Supplier [EHFND_BUPA_SUPPLIER]
    SVTCALCULATEDSUPPLIERID,         -- Supplier [EHFND_SUPPLIER]
    SVTCALULATEDSUPPLIERFUNCTION,    -- Partner Functn [PARVW]
    SVTCALULATEDSUPPLIERADDRESSID,   -- Address No. [EHFND_ADDR_NUMBER]
    RECEIVINGREGION,                 -- Receiving Region [EHPMA_SVT_RCVG_REGION]
    ISRETURNSITEM,                   -- Returns Item [RETPO]
    RECEIVINGSTORAGELOCATION,        -- RecStorLoc [EHPMA_SVT_RECEIVING_STOR_LOC]
    DELIVERINGSTORAGELOCATION,       -- Deliv. Stor. Loc. [EHPMA_SVT_DELIVERING_STOR_LOC]
    IMPRTRESPYCALCDRESPIMPORTER,     -- Calcd Resp Importer [EHPMA_RESP_IMPORTER_CALCD]
    IMPRTRESPYMNTNDRESPIMPORTER,     -- Mntnd Resp Importer [EHPMA_RESP_IMPORTER_MNTND]
    SOURCEISBONDEDWAREHOUSE,         -- Is Bonded Wrhs [EHPMA_SVT_SOURCE_IS_BWRHS]
    TARGETISBONDEDWAREHOUSE,         -- Is Bonded Wrhs [EHPMA_SVT_TARGET_IS_BWRHS]
    PRIMARY KEY (CLIENT, SVTCONFIRMEDPURCHASINGDOCUUID)
);

Learn More