I_ENVRMTWASTETRANSPDOC

CDS View
13 Fields 4 CDS Views

Basic Waste Transportation Document

I_ENVRMTWASTETRANSPDOC is a CDS View in S/4HANA. Basic Waste Transportation Document. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_WasteTranspDocOutpParam view from CONSUMPTION Transp Document OM Output Parameters
I_EHSEnvRptPRTRSubstWaste view_entity from COMPOSITE PRTR waste sensitive data
I_WasteAnalyticsDimension view from COMPOSITE Waste Data Dimension
R_EnvrmtWasteTranspDocTP view_entity from TRANSACTIONAL Waste Transportation Document - TP

Fields (13)

KeyField CDS FieldsUsed in Views
KEY EnvrmtWasteTranspDocUUID EnvrmtWasteTranspDocUUID 2
_Location _Location 1
CmplRqVersPermitNumber CmplRqVersPermitNumber 1
CmplRqVersUUID CmplRqVersUUID 1
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport 1
EnvrmtWasteGnrtrUUID EHSLocationUUID,EnvrmtWasteGnrtrUUID 2
EnvrmtWasteTranspDocStatus EnvrmtWasteTranspDocStatus 2
EnvrmtWasteTranspDocType EnvrmtWasteTranspDocType 2
EnvWstTranspDocHandoverDate EnvWstTranspDocHandoverDate 1
EnvWstTranspDocPrintedDate EnvWstTranspDocPrintedDate 1
WasteIsTransportedAbroad WasteIsTransportedAbroad 1
WasteStreamDsplChnlUUID WasteStreamDsplChnlUUID 2
WasteTranspDocID WasteTranspDocID 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.

-- Basic Waste Transportation Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ENVRMTWASTETRANSPDOC (
    ENVRMTWASTETRANSPDOCUUID,
    _LOCATION,
    CMPLRQVERSPERMITNUMBER,
    CMPLRQVERSUUID,
    DNGRSGOODSMODEOFTRANSPORT,
    ENVRMTWASTEGNRTRUUID,
    ENVRMTWASTETRANSPDOCSTATUS,
    ENVRMTWASTETRANSPDOCTYPE,
    ENVWSTTRANSPDOCHANDOVERDATE,
    ENVWSTTRANSPDOCPRINTEDDATE,
    WASTEISTRANSPORTEDABROAD,
    WASTESTREAMDSPLCHNLUUID,
    WASTETRANSPDOCID,
    PRIMARY KEY (ENVRMTWASTETRANSPDOCUUID)
);

Learn More