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