Fields (27)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA