I

132 Fields

I is an SAP database table in S/4HANA. It contains 132 fields.

Fields (132)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY ebeln aufnr,ebeln 4
KEY ebelp ebelp,posnr 4
KEY posnr posnr 4
KEY TaxCode TaxCode 1
KEY TaxGroup TaxGroup 1
KEY TaxItem TaxItem 1
abeln abeln 3
abelp abelp 3
aedat aedat,erdat 3
arun_fix_batch arun_fix_batch 6
attyp attyp 4
augbl augbl 1
augcp augcp 1
augdt augdt 1
auggj auggj 1
batch_req batch,batch_req 2
bdart bdart 2
bedae bedae 2
bedat audat,bedat 3
berid berid 6
bsart bsart 3
bstyp bstyp 3
bukrs bukrs 3
BusinessPartner BusinessPartner 1
BusinessPlace BusinessPlace 1
charg batch_req 2
color color 5
color_atinn color_atinn 5
CompanyCodeCurrency Currency 1
dismm dismm 4
dmenge dmenge 2
DocumentDate DocumentDate 1
DocumentReferenceID ReferenceNumber 1
ekgrp ekgrp 3
ekorg ekorg 3
execuuid irpa_execuuid 1
FiscalYear FiscalYear 1
fixmg fixmg 7
fsh_candate fsh_candate 3
fsh_collection fsh_collection 5
fsh_grid_cond_rec fsh_grid_cond_rec 5
fsh_item fsh_item 5
fsh_item_group fsh_item_group 5
fsh_mg_arun_req fsh_mg_arun_req 4
fsh_mg_at1 fsh_mg_at1 3
fsh_mg_at2 fsh_mg_at2 3
fsh_mg_at3 fsh_mg_at3 3
fsh_season fsh_season 5
fsh_season_year fsh_season_year 5
fsh_theme fsh_theme 5
fsh_transaction fsh_transaction 5
fsh_vas_prnt_id fsh_vas_prnt_id 5
fsh_vas_rel fsh_vas_rel 5
grkor grkor 2
guid item_guid 3
ilfgsa ilfgsa 1
IsReversal IsReversal 1
IsReversed IsReversed 1
iuvall iuvall 1
iuvfak iuvfak 1
iuvvlk iuvvlk 2
klmeng klmeng 4
koart koart 1
kowrr kowrr 2
kwmeng kwmeng 7
lfsta lfsta 2
lgort lgort,sloc_req 6
life_cycle_status irpa_life_cycle_status 1
lmein lmein,meins 3
lprio lprio 2
maktg maktg 4
material material 3
material_avail_date material_avail_date 3
material_baseunit material_baseunit 2
matkl matkl 5
matnr material,matnr 5
mspart mspart 1
mtvfp mtvfp 6
mvgr1 mvgr1 2
netpr netpr 4
netwr netwr 4
plant plant 3
portfolio_guid portfolio_guid 3
prreg prreg 2
pstyv pstyv 2
rebzg rebzg 1
rebzj rebzj 1
rebzt rebzt 1
rebzz rebzz 1
ReportingDate ReportingDate 1
req_conf_qty req_conf_qty 3
req_segment req_segment 3
requested_date requested_date 3
reswk plant,reswk,werks 3
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
rfm_psst_group rfm_psst_group 4
route route 2
satnr satnr 5
sgt_covs sgt_covs 7
sgt_rcat req_segment,sgt_rcat 5
sgt_scope sgt_scope 6
sgt_stk_prt sgt_stk_prt 5
size1 size1 5
size1_atinn size1_atinn 5
size2 size2 5
size2_atinn size2_atinn 5
sloc_req sloc_req,storage_location 2
sobkz sobkz 2
spart spart 2
sposn sposn 2
stapo stapo 3
stdat stdat 2
stlnr stlnr 2
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxItemGroup TaxItemGroup 1
TaxRate TaxRate 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
TaxType TaxType 1
uebpo uebpo 3
uepos uepos 2
umren umren 3
umrez umrez 3
uvvlk uvvlk 1
vbeln vbeln 2
vstel vstel 2
waerk waerk 2
werks plant 2
xchpf xchpf 5

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 I (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    EBELN,
    EBELP,
    POSNR,
    TAXCODE,
    TAXGROUP,
    TAXITEM,
    ABELN,
    ABELP,
    AEDAT,
    ARUN_FIX_BATCH,
    ATTYP,
    AUGBL,
    AUGCP,
    AUGDT,
    AUGGJ,
    BATCH_REQ,
    BDART,
    BEDAE,
    BEDAT,
    BERID,
    BSART,
    BSTYP,
    BUKRS,
    BUSINESSPARTNER,
    BUSINESSPLACE,
    CHARG,
    COLOR,
    COLOR_ATINN,
    COMPANYCODECURRENCY,
    DISMM,
    DMENGE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EKGRP,
    EKORG,
    EXECUUID,
    FISCALYEAR,
    FIXMG,
    FSH_CANDATE,
    FSH_COLLECTION,
    FSH_GRID_COND_REC,
    FSH_ITEM,
    FSH_ITEM_GROUP,
    FSH_MG_ARUN_REQ,
    FSH_MG_AT1,
    FSH_MG_AT2,
    FSH_MG_AT3,
    FSH_SEASON,
    FSH_SEASON_YEAR,
    FSH_THEME,
    FSH_TRANSACTION,
    FSH_VAS_PRNT_ID,
    FSH_VAS_REL,
    GRKOR,
    GUID,
    ILFGSA,
    ISREVERSAL,
    ISREVERSED,
    IUVALL,
    IUVFAK,
    IUVVLK,
    KLMENG,
    KOART,
    KOWRR,
    KWMENG,
    LFSTA,
    LGORT,
    LIFE_CYCLE_STATUS,
    LMEIN,
    LPRIO,
    MAKTG,
    MATERIAL,
    MATERIAL_AVAIL_DATE,
    MATERIAL_BASEUNIT,
    MATKL,
    MATNR,
    MSPART,
    MTVFP,
    MVGR1,
    NETPR,
    NETWR,
    PLANT,
    PORTFOLIO_GUID,
    PRREG,
    PSTYV,
    REBZG,
    REBZJ,
    REBZT,
    REBZZ,
    REPORTINGDATE,
    REQ_CONF_QTY,
    REQ_SEGMENT,
    REQUESTED_DATE,
    RESWK,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    RFM_PSST_GROUP,
    ROUTE,
    SATNR,
    SGT_COVS,
    SGT_RCAT,
    SGT_SCOPE,
    SGT_STK_PRT,
    SIZE1,
    SIZE1_ATINN,
    SIZE2,
    SIZE2_ATINN,
    SLOC_REQ,
    SOBKZ,
    SPART,
    SPOSN,
    STAPO,
    STDAT,
    STLNR,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXITEMGROUP,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXTYPE,
    UEBPO,
    UEPOS,
    UMREN,
    UMREZ,
    UVVLK,
    VBELN,
    VSTEL,
    WAERK,
    WERKS,
    XCHPF,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, EBELN, EBELP, POSNR, TAXCODE, TAXGROUP, TAXITEM)
);

Learn More