I_LASTMILEVISITSALESPROPOSAL

CDS View
9 Fields 3 CDS Views

LMD Visit Sales Proposal Base

I_LASTMILEVISITSALESPROPOSAL is a CDS View in S/4HANA. LMD Visit Sales Proposal Base. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_LastMileProductProposalDEX view_entity from CONSUMPTION LMD Product Proposal Data Extraction
C_LastMileVisitProductProposal view_entity from CONSUMPTION Product Proposal in Visit
C_LstMiVstSalesProposalDEX view from CONSUMPTION Last Mile Distribution Visit Lst SP DEX

Fields (9)

KeyField CDS FieldsUsed in Views
KEY LastMileVisitSalesProposalPos LastMileVisitSalesProposalPos 2
KEY LastMileVisitUUID LastMileVisitUUID 2
DistributionChannel DistributionChannel 2
Division Division 2
LastMileVisitListUUID LastMileVisitListUUID 2
Product Product 2
Quantity Quantity 2
QuantityUnit QuantityUnit 2
SalesOrganization SalesOrganization 2

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.

-- LMD Visit Sales Proposal Base
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LASTMILEVISITSALESPROPOSAL (
    LASTMILEVISITSALESPROPOSALPOS,
    LASTMILEVISITUUID,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    LASTMILEVISITLISTUUID,
    PRODUCT,
    QUANTITY,
    QUANTITYUNIT,
    SALESORGANIZATION,
    PRIMARY KEY (LASTMILEVISITSALESPROPOSALPOS, LASTMILEVISITUUID)
);

Learn More