DETAIL

19 Fields

DETAIL is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 2
Characteristic Characteristic 1
CharcDataType CharcDataType 1
CharcGroup CharcGroup 1
CharcMaintAuthGrp CharcMaintAuthGrp 1
CharcValueUnit CharcValueUnit 1
CompanyCode CompanyCode 1
Equipment Equipment 2
FunctionalLocation FunctionalLocation 2
InvolvedAssetName InvolvedAssetName 2
InvolvedEquipmentType InvolvedEquipmentType 2
InvolvedPropertyType InvolvedPropertyType 2
InvolvedVehicleType InvolvedVehicleType 2
LabelSetAuthorizationGroup LabelSetAuthorizationGroup 1
LabelSetStatus LabelSetStatus 1
MaterialDocPostgDate MaterialDocPostgDate 1
MonitorEndDateTime MonitorEndDateTime 2
MonitorStartDateTime MonitorStartDateTime 2
Status Status 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DETAIL (
    BANKACCOUNTINTERNALID,
    CHARACTERISTIC,
    CHARCDATATYPE,
    CHARCGROUP,
    CHARCMAINTAUTHGRP,
    CHARCVALUEUNIT,
    COMPANYCODE,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    INVOLVEDASSETNAME,
    INVOLVEDEQUIPMENTTYPE,
    INVOLVEDPROPERTYTYPE,
    INVOLVEDVEHICLETYPE,
    LABELSETAUTHORIZATIONGROUP,
    LABELSETSTATUS,
    MATERIALDOCPOSTGDATE,
    MONITORENDDATETIME,
    MONITORSTARTDATETIME,
    STATUS,
    PRIMARY KEY (BANKACCOUNTINTERNALID)
);

Learn More