J_1BCTE_D_RES

Transparent Table Application Table
14 Fields 1 CDS Views

Information about resource

J_1BCTE_D_RES is an SAP database table in S/4HANA. Information about resource. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_CTeVehicle view from BASIC Brazil CTe Vehicles

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY docnum j_1bdocnum Document Number
KEY counter j_1bcte_res_counter Resource
renavam j_1bcte_res_renavam RENAVAM
plate j_1bcte_res_plate Vehicle Plate
tare_kg j_1bcte_res_tare_kg Tare Weight Kg
capa_kg j_1bcte_res_capa_kg Capa Kg
capa_m j_1bcte_res_capa_m Capa m3
owner_tp j_1bcte_res_owner_tp Ownership Type
res_type j_1bcte_res_type Vehicle Type
rodado_tp j_1bcte_res_rodado_tp Vehicle Axis Type
car_tp j_1bcte_res_car_tp Trailer Type
state j_1bcte_res_state Vehicle Region
seal_nr j_1bcte_res_seal_nr Seal Number

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.

-- Information about resource
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BCTE_D_RES (
    MANDT,      -- Client [mandt]
    DOCNUM,     -- Document Number [j_1bdocnum]
    COUNTER,    -- Resource [j_1bcte_res_counter]
    RENAVAM,    -- RENAVAM [j_1bcte_res_renavam]
    PLATE,      -- Vehicle Plate [j_1bcte_res_plate]
    TARE_KG,    -- Tare Weight Kg [j_1bcte_res_tare_kg]
    CAPA_KG,    -- Capa Kg [j_1bcte_res_capa_kg]
    CAPA_M,     -- Capa m3 [j_1bcte_res_capa_m]
    OWNER_TP,   -- Ownership Type [j_1bcte_res_owner_tp]
    RES_TYPE,   -- Vehicle Type [j_1bcte_res_type]
    RODADO_TP,  -- Vehicle Axis Type [j_1bcte_res_rodado_tp]
    CAR_TP,     -- Trailer Type [j_1bcte_res_car_tp]
    STATE,      -- Vehicle Region [j_1bcte_res_state]
    SEAL_NR,    -- Seal Number [j_1bcte_res_seal_nr]
    PRIMARY KEY (MANDT, DOCNUM, COUNTER)
);

Learn More