EHPMAD_SVT_SALCO
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SVTSalesPrprocgDocument | view | from | BASIC | SVT sales preprocessing document |
Fields (30)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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