EHPMAD_SVT_SALCO

Transparent Table Application Table
46 Fields 1 CDS Views

SVT Sales Confirmed Quantities Table

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SVTSalesPrprocgDocument view from BASIC SVT sales preprocessing document

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY svtconfirmedsalesdocuuid EHPMA_SVT_SALCO_UUID UUID for SALCO
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
businesspartnercustomer EHPMA_SVT_BUPA_CUSTOMER BP Customer
shippingpoint VSTEL Shipping Point
sellingplant EHPMA_SVT_SELLING_PLANT Selling Plant
deliveringcountry EHPMA_SVT_DELIVERING_COUNTRY Delivering Ctry/Reg
shiptocountry EHPMA_SVT_SHIP_TO_COUNTRY Ship to Ctry/Reg
supplierisimporter EHPMA_SVT_SUPPLIER_IS_IMPORTER Supplier is importer
deliverydocument EHPMA_SVT_DELIVERY_DOCUMENT Delivery Document
deliverydocumentitem EHPMA_SVT_DELIVERY_DOC_ITEM Delivery Doc Item
sddocumentcategory VBTYP Document cat.
deliverydocumenttype LFART Delivery Type
deliverydocumentitemcategory PSTYV_VL Item Category
sellingcompanycode EHPMA_SVT_SELLING_COMPANY_CODE Selling Company Code
shiptoregion EHPMA_SVT_SHIP_TO_REGION Ship To Region
shiptoplant EHPMA_SVT_SHIP_TO_PLANT Ship To Plant
shiptoaddress EHPMA_SVT_SHIP_TO_ADDRESS Ship To Address
isreturnsitem RETPO Returns Item
shiptostoragelocation EHPMA_SVT_SHIP_TO_STORAGE_LOC Ship to Storage Loc.
sellingstoragelocation EHPMA_SVT_SELLING_STORAGE_LOC Selling Storage Loc.
deliveringregion EHPMA_SVT_DELIVERING_REGION Delivering Region
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 Sales 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_SALCO (
    CLIENT,                          -- Client [MANDT]
    SVTCONFIRMEDSALESDOCUUID,        -- UUID for SALCO [EHPMA_SVT_SALCO_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]
    BUSINESSPARTNERCUSTOMER,         -- BP Customer [EHPMA_SVT_BUPA_CUSTOMER]
    SHIPPINGPOINT,                   -- Shipping Point [VSTEL]
    SELLINGPLANT,                    -- Selling Plant [EHPMA_SVT_SELLING_PLANT]
    DELIVERINGCOUNTRY,               -- Delivering Ctry/Reg [EHPMA_SVT_DELIVERING_COUNTRY]
    SHIPTOCOUNTRY,                   -- Ship to Ctry/Reg [EHPMA_SVT_SHIP_TO_COUNTRY]
    SUPPLIERISIMPORTER,              -- Supplier is importer [EHPMA_SVT_SUPPLIER_IS_IMPORTER]
    DELIVERYDOCUMENT,                -- Delivery Document [EHPMA_SVT_DELIVERY_DOCUMENT]
    DELIVERYDOCUMENTITEM,            -- Delivery Doc Item [EHPMA_SVT_DELIVERY_DOC_ITEM]
    SDDOCUMENTCATEGORY,              -- Document cat. [VBTYP]
    DELIVERYDOCUMENTTYPE,            -- Delivery Type [LFART]
    DELIVERYDOCUMENTITEMCATEGORY,    -- Item Category [PSTYV_VL]
    SELLINGCOMPANYCODE,              -- Selling Company Code [EHPMA_SVT_SELLING_COMPANY_CODE]
    SHIPTOREGION,                    -- Ship To Region [EHPMA_SVT_SHIP_TO_REGION]
    SHIPTOPLANT,                     -- Ship To Plant [EHPMA_SVT_SHIP_TO_PLANT]
    SHIPTOADDRESS,                   -- Ship To Address [EHPMA_SVT_SHIP_TO_ADDRESS]
    ISRETURNSITEM,                   -- Returns Item [RETPO]
    SHIPTOSTORAGELOCATION,           -- Ship to Storage Loc. [EHPMA_SVT_SHIP_TO_STORAGE_LOC]
    SELLINGSTORAGELOCATION,          -- Selling Storage Loc. [EHPMA_SVT_SELLING_STORAGE_LOC]
    DELIVERINGREGION,                -- Delivering Region [EHPMA_SVT_DELIVERING_REGION]
    SOURCEISBONDEDWAREHOUSE,         -- Is Bonded Wrhs [EHPMA_SVT_SOURCE_IS_BWRHS]
    TARGETISBONDEDWAREHOUSE,         -- Is Bonded Wrhs [EHPMA_SVT_TARGET_IS_BWRHS]
    PRIMARY KEY (CLIENT, SVTCONFIRMEDSALESDOCUUID)
);

Learn More