EHPMAD_SVT_SALCO

Transparent Table Application Table

SVT Sales Confirmed Quantities Table

EHPMAD_SVT_SALCO is an SAP database table in S/4HANA. SVT Sales Confirmed Quantities Table. It contains 30 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 (30)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY svtconfirmedsalesdocuuid ehpma_svt_salco_uuid UUID for SALCO
businesspartnercustomer ehpma_svt_bupa_customer BP Customer
customerid ehfnd_customer_id Customer
svtselectedcustomerfunction parvw Partner Functn
shippingpoint vstel Shipping Point
sellingcompanycode ehpma_svt_selling_company_code Selling Company Code
deliveringcountry ehpma_svt_delivering_country Delivering Ctry/Reg
deliveringregion ehpma_svt_delivering_region Delivering Region
sellingplant ehpma_svt_selling_plant Selling Plant
sellingstoragelocation ehpma_svt_selling_storage_loc Selling Storage Loc.
sourceaddressid ehpma_svt_source_address_id
sourceaddresstype ehpma_svt_src_address_type_sal
sourceisbondedwarehouse ehpma_svt_source_is_bwrhs Is Bonded Wrhs
shiptocountry ehpma_svt_ship_to_country Ship to Ctry/Reg
shiptoregion ehpma_svt_ship_to_region Ship To Region
shiptoplant ehpma_svt_ship_to_plant Ship To Plant
shiptostoragelocation ehpma_svt_ship_to_storage_loc Ship to Storage Loc.
shiptoaddress ehpma_svt_ship_to_address Ship To Address
targetaddressid ehpma_svt_target_address_id
targetaddresstype ehpma_svt_trg_address_type_sal
targetisbondedwarehouse ehpma_svt_target_is_bwrhs Is Bonded Wrhs
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
isreturnsitem retpo Returns Item
supplierisimporter ehpma_svt_supplier_is_importer Supplier is importer
imprtrespycalcdrespimporter ehpma_resp_importer_calcd Calcd Resp Importer

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]
    BUSINESSPARTNERCUSTOMER,       -- BP Customer [ehpma_svt_bupa_customer]
    CUSTOMERID,                    -- Customer [ehfnd_customer_id]
    SVTSELECTEDCUSTOMERFUNCTION,   -- Partner Functn [parvw]
    SHIPPINGPOINT,                 -- Shipping Point [vstel]
    SELLINGCOMPANYCODE,            -- Selling Company Code [ehpma_svt_selling_company_code]
    DELIVERINGCOUNTRY,             -- Delivering Ctry/Reg [ehpma_svt_delivering_country]
    DELIVERINGREGION,              -- Delivering Region [ehpma_svt_delivering_region]
    SELLINGPLANT,                  -- Selling Plant [ehpma_svt_selling_plant]
    SELLINGSTORAGELOCATION,        -- Selling Storage Loc. [ehpma_svt_selling_storage_loc]
    SOURCEADDRESSID,               -- ehpma_svt_source_address_id
    SOURCEADDRESSTYPE,             -- ehpma_svt_src_address_type_sal
    SOURCEISBONDEDWAREHOUSE,       -- Is Bonded Wrhs [ehpma_svt_source_is_bwrhs]
    SHIPTOCOUNTRY,                 -- Ship to Ctry/Reg [ehpma_svt_ship_to_country]
    SHIPTOREGION,                  -- Ship To Region [ehpma_svt_ship_to_region]
    SHIPTOPLANT,                   -- Ship To Plant [ehpma_svt_ship_to_plant]
    SHIPTOSTORAGELOCATION,         -- Ship to Storage Loc. [ehpma_svt_ship_to_storage_loc]
    SHIPTOADDRESS,                 -- Ship To Address [ehpma_svt_ship_to_address]
    TARGETADDRESSID,               -- ehpma_svt_target_address_id
    TARGETADDRESSTYPE,             -- ehpma_svt_trg_address_type_sal
    TARGETISBONDEDWAREHOUSE,       -- Is Bonded Wrhs [ehpma_svt_target_is_bwrhs]
    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]
    ISRETURNSITEM,                 -- Returns Item [retpo]
    SUPPLIERISIMPORTER,            -- Supplier is importer [ehpma_svt_supplier_is_importer]
    IMPRTRESPYCALCDRESPIMPORTER,   -- Calcd Resp Importer [ehpma_resp_importer_calcd]
    PRIMARY KEY (CLIENT, SVTCONFIRMEDSALESDOCUUID)
);