INFORECORD

INFORECORD is an SAP database table in S/4HANA. It contains 27 fields.

Fields (27)

KeyField CDS FieldsUsed in Views
KEY PurchasingInfoRecord SourceOfSupply 1
bstma bstma 1
bstmi bstmi 1
bstyp bstyp 1
ekgrp ekgrp 1
ekorg ekorg 1
emlif emlif 1
esokz esokz 1
infnr infnr 1
lblkz lblkz 1
lgort lgort 1
lifnr lifnr 1
lphis lphis 1
matnr matnr 1
netpr netpr 1
peinh peinh 1
plifz plifz 1
pstyp pstyp 1
rdprf rdprf 1
reslo reslo 1
reswk reswk 1
sobkz sobkz 1
validitydate validitydate 1
verid verid 1
waers waers 1
webaz webaz 1
werks werks 1

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 INFORECORD (
    PURCHASINGINFORECORD,
    BSTMA,
    BSTMI,
    BSTYP,
    EKGRP,
    EKORG,
    EMLIF,
    ESOKZ,
    INFNR,
    LBLKZ,
    LGORT,
    LIFNR,
    LPHIS,
    MATNR,
    NETPR,
    PEINH,
    PLIFZ,
    PSTYP,
    RDPRF,
    RESLO,
    RESWK,
    SOBKZ,
    VALIDITYDATE,
    VERID,
    WAERS,
    WEBAZ,
    WERKS,
    PRIMARY KEY (PURCHASINGINFORECORD)
);