EVER

Transparent Table Application Table
98 Fields 17 CDS Views

IS-U Cont.

EVER is an SAP database table in S/4HANA. IS-U Cont.. It contains 98 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
CRMS4_IU_C_CONBP view inner Connection object by business partner
CRMS4_IU_C_CONVAR view_entity left_outer Connection Object by Various Fields
CRMS4_IU_C_CONVAR_DEVPOD view_entity left_outer Con. Object by Various Fields (Dev, PoD)
CRMS4_IU_C_PODBP view inner Point of Delivery by Business Partner
CRMS4_IU_C_PODCA view inner Point of Delivery by Contract Account
CRMS4_IU_I_UTCT view inner Utilities Contract
I_UtilitiesContract view from BASIC Contract
ISU_C4C_BILLDT_V view from Latest bill date
ISU_C4C_BP_PREMISE_V view_entity inner Premises linked to business partner
ISU_C4C_PREMISE_CONTRACTS_V view_entity left_outer Contracts details in premise
ISU_C4C_PREMISE_SERVICES_V view_entity left_outer Services in a premise
SHSM_I_EAUSC view inner Move-Out Doc. by Contract
SHSM_I_EDISCDOCISUCONTR view inner CDS SH for Disc. Doc. with Ref. Obj. IS Contract
SHSM_I_EEINC view inner Move-In Doc. by Contract
SHSM_I_EEINE view inner Move-In Doc. by Premise
SHSM_M_EVEXA view from Contracts by Old Contract Number Search Help
SHSM_V_EVERG view from Business Partner for Contract Search Help

Fields (98)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vertrag VERTRAG Contract
bukrs BUKRS Company Code
sparte SPARTE Division
eigenverbr EIGENVERBR Plant/company
kofiz E_KOFIZ Acct Determ. ID
portion PORTIONABW Alt. portion
abslanfo ABSLANFO Debtor BB req.
abszyk ABSZYKV Ovdg. BB cycle
absmnanp ABSMNANP No BB amt adj.
gemfakt E_GEMFAKT Joint Invoicing
manabr MANABR Bill manually
abrsperr ABRSPERR Bill.blck.reas.
abrfreig ABRFREIG Release reason
bstatus BEARKZ Proc. Status
kostl KOSTL Cost Center
vbez E_VBEZ Text contract
vbeginn E_VBEGINN Start
einzdat_alt EINZDAT_ALT MID fr. legSys.
vende E_VENDE End
kuenddat KUENDAT Canc. Date
kfrist KUENZEIT No. canc. units
kuenper KUENPER Canc. time unit
vbisdat E_VBISDAT Renewal date
verlaeng VERZEIT No. ren. units
verper VERPER Ren. time unit
vabschlevu E_VSCHLEVU Utility concl.
vabschlknd E_VSCHLKND Customer concl.
vabschlkndti E_VSCHLKNDTI Time customer
persnr PERNR_D Personnel No.
vrefer E_VREFER Leg.syst.contr.
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
txjcd TXJCD Tax Jur.
manoutsort MANOUTSORT Man. OS billing
fakturiert FAKTURIERT Invoiced
aufnr AUFNR Order
ps_psp_pnr PS_PSP_PNR WBS Element
prctr PRCTR Profit Center
copakont E_COPAKONT PrfSeg assigned
ausgrup AUSGRUP Outsort.chk grp
outcount OUTCOUNT No. outsortings
pyplt E_PYPLT Pymt plan type
pypls E_PYPLS Starting month
gsber GSBER Business Area
segment SEGMT_KK Segment
serviceid SERVICE_PROV Serv. Provider
srvprvref SRVPRVREF SP reference no
billmethod BILLMETHOD Billing method
stagruver E_STGRUV Stats group
pypla E_PYPLA Alt.start month
billfinit BILLFINIT BillRel.Termin.
bfa_deb_stat E_BFA_PROC_DEBIT BFamt receiv.
bfa_cred_stat E_BFA_PROC_CREDIT BFamount credit
salesemployee VRTNR Sales Employee
salespartner ESALESPARTNER Sales partners
salesdocument VBELN SD Document
ps_startdat PS_STARTDAT PS StDate
servprov_pay SERVPROV_PAY Payment Class
invoicing_party INVOICING_PARTY Inv. Serv. Prov
cokey COKEY_EE2 CO Acct Assgmt
bupla BUPLA Business place
contractclass CONTRACTCLASS Contract Class
cancreason VKGRU_VEDA Reason f.Canc.
cancreason_new ECRMT_SRV_CANCEL_REASON Canceltn reason
extrapolwaste EXTRAPOLWASTE Cat.BB Extrap.
ppm_contract E_PP_PPM_CONTRACT PPM Contract
osb_group E_OSB_GROUP OSB Group
oucont OUCONT Outline Contr.
rulegr RULEGR Rule group
regiogroup REGIOGROUP Structure Group
cmgrp CMGRP_CM_KK Master Data Grp
strat STRAT_CM_KK Coll. Strategy
cpers CPERS_CM_KK Contact Person
anlage ANLAGE Installation
vkonto VKONT_KK Contract Acct
kzsondeinz KZSONDEINZ Special Move-In
kzsondausz KZSONDAUSZ Special mv-out
auteigeinz AUTEIGEINZ AutOwnerMoveI/O
einzdat EINZDAT Move-In Date
auszdat AUSZDAT Move-Out Date
absstopdat ABSSTOPDAT BB stop date
schlfakt SCHLFAKT Joint fnl bill.
mahnv MAHNV_KK Dunning Proc.
mahnvumz MAHNV_UMZ M/i/o dunn prc
mansp MANSP_KK DunnLockReason
bezug BEZUG Purchase
transver E_TRANSVER Transfer contr.
sswtcreason SSWTCREASON Reason cont.chg
xvera XVERA Leg. sys. cont.
cactstartdatetime E_CACTSTARTDATETIME Start Date/Time
cactenddatetime E_CACTENDDATETIME End Date/Time
cologrp_inst E_COLOGRP_INST Coloc. Grp Inst
lastportion PORTIONLTZ Last Portion

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.

-- IS-U Cont.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EVER (
    MANDT,              -- Client [MANDT]
    VERTRAG,            -- Contract [VERTRAG]
    BUKRS,              -- Company Code [BUKRS]
    SPARTE,             -- Division [SPARTE]
    EIGENVERBR,         -- Plant/company [EIGENVERBR]
    KOFIZ,              -- Acct Determ. ID [E_KOFIZ]
    PORTION,            -- Alt. portion [PORTIONABW]
    ABSLANFO,           -- Debtor BB req. [ABSLANFO]
    ABSZYK,             -- Ovdg. BB cycle [ABSZYKV]
    ABSMNANP,           -- No BB amt adj. [ABSMNANP]
    GEMFAKT,            -- Joint Invoicing [E_GEMFAKT]
    MANABR,             -- Bill manually [MANABR]
    ABRSPERR,           -- Bill.blck.reas. [ABRSPERR]
    ABRFREIG,           -- Release reason [ABRFREIG]
    BSTATUS,            -- Proc. Status [BEARKZ]
    KOSTL,              -- Cost Center [KOSTL]
    VBEZ,               -- Text contract [E_VBEZ]
    VBEGINN,            -- Start [E_VBEGINN]
    EINZDAT_ALT,        -- MID fr. legSys. [EINZDAT_ALT]
    VENDE,              -- End [E_VENDE]
    KUENDDAT,           -- Canc. Date [KUENDAT]
    KFRIST,             -- No. canc. units [KUENZEIT]
    KUENPER,            -- Canc. time unit [KUENPER]
    VBISDAT,            -- Renewal date [E_VBISDAT]
    VERLAENG,           -- No. ren. units [VERZEIT]
    VERPER,             -- Ren. time unit [VERPER]
    VABSCHLEVU,         -- Utility concl. [E_VSCHLEVU]
    VABSCHLKND,         -- Customer concl. [E_VSCHLKND]
    VABSCHLKNDTI,       -- Time customer [E_VSCHLKNDTI]
    PERSNR,             -- Personnel No. [PERNR_D]
    VREFER,             -- Leg.syst.contr. [E_VREFER]
    ERDAT,              -- Created On [ERDAT]
    ERNAM,              -- Created By [ERNAM]
    AEDAT,              -- Changed On [AEDAT]
    AENAM,              -- Changed By [AENAM]
    BEGRU,              -- AuthorizGroup [BEGRU]
    LOEVM,              -- Delete [LOEVM]
    TXJCD,              -- Tax Jur. [TXJCD]
    MANOUTSORT,         -- Man. OS billing [MANOUTSORT]
    FAKTURIERT,         -- Invoiced [FAKTURIERT]
    AUFNR,              -- Order [AUFNR]
    PS_PSP_PNR,         -- WBS Element [PS_PSP_PNR]
    PRCTR,              -- Profit Center [PRCTR]
    COPAKONT,           -- PrfSeg assigned [E_COPAKONT]
    AUSGRUP,            -- Outsort.chk grp [AUSGRUP]
    OUTCOUNT,           -- No. outsortings [OUTCOUNT]
    PYPLT,              -- Pymt plan type [E_PYPLT]
    PYPLS,              -- Starting month [E_PYPLS]
    GSBER,              -- Business Area [GSBER]
    SEGMENT,            -- Segment [SEGMT_KK]
    SERVICEID,          -- Serv. Provider [SERVICE_PROV]
    SRVPRVREF,          -- SP reference no [SRVPRVREF]
    BILLMETHOD,         -- Billing method [BILLMETHOD]
    STAGRUVER,          -- Stats group [E_STGRUV]
    PYPLA,              -- Alt.start month [E_PYPLA]
    BILLFINIT,          -- BillRel.Termin. [BILLFINIT]
    BFA_DEB_STAT,       -- BFamt receiv. [E_BFA_PROC_DEBIT]
    BFA_CRED_STAT,      -- BFamount credit [E_BFA_PROC_CREDIT]
    SALESEMPLOYEE,      -- Sales Employee [VRTNR]
    SALESPARTNER,       -- Sales partners [ESALESPARTNER]
    SALESDOCUMENT,      -- SD Document [VBELN]
    PS_STARTDAT,        -- PS StDate [PS_STARTDAT]
    SERVPROV_PAY,       -- Payment Class [SERVPROV_PAY]
    INVOICING_PARTY,    -- Inv. Serv. Prov [INVOICING_PARTY]
    COKEY,              -- CO Acct Assgmt [COKEY_EE2]
    BUPLA,              -- Business place [BUPLA]
    CONTRACTCLASS,      -- Contract Class [CONTRACTCLASS]
    CANCREASON,         -- Reason f.Canc. [VKGRU_VEDA]
    CANCREASON_NEW,     -- Canceltn reason [ECRMT_SRV_CANCEL_REASON]
    EXTRAPOLWASTE,      -- Cat.BB Extrap. [EXTRAPOLWASTE]
    PPM_CONTRACT,       -- PPM Contract [E_PP_PPM_CONTRACT]
    OSB_GROUP,          -- OSB Group [E_OSB_GROUP]
    OUCONT,             -- Outline Contr. [OUCONT]
    RULEGR,             -- Rule group [RULEGR]
    REGIOGROUP,         -- Structure Group [REGIOGROUP]
    CMGRP,              -- Master Data Grp [CMGRP_CM_KK]
    STRAT,              -- Coll. Strategy [STRAT_CM_KK]
    CPERS,              -- Contact Person [CPERS_CM_KK]
    ANLAGE,             -- Installation [ANLAGE]
    VKONTO,             -- Contract Acct [VKONT_KK]
    KZSONDEINZ,         -- Special Move-In [KZSONDEINZ]
    KZSONDAUSZ,         -- Special mv-out [KZSONDAUSZ]
    AUTEIGEINZ,         -- AutOwnerMoveI/O [AUTEIGEINZ]
    EINZDAT,            -- Move-In Date [EINZDAT]
    AUSZDAT,            -- Move-Out Date [AUSZDAT]
    ABSSTOPDAT,         -- BB stop date [ABSSTOPDAT]
    SCHLFAKT,           -- Joint fnl bill. [SCHLFAKT]
    MAHNV,              -- Dunning Proc. [MAHNV_KK]
    MAHNVUMZ,           -- M/i/o dunn prc [MAHNV_UMZ]
    MANSP,              -- DunnLockReason [MANSP_KK]
    BEZUG,              -- Purchase [BEZUG]
    TRANSVER,           -- Transfer contr. [E_TRANSVER]
    SSWTCREASON,        -- Reason cont.chg [SSWTCREASON]
    XVERA,              -- Leg. sys. cont. [XVERA]
    CACTSTARTDATETIME,  -- Start Date/Time [E_CACTSTARTDATETIME]
    CACTENDDATETIME,    -- End Date/Time [E_CACTENDDATETIME]
    COLOGRP_INST,       -- Coloc. Grp Inst [E_COLOGRP_INST]
    LASTPORTION,        -- Last Portion [PORTIONLTZ]
    PRIMARY KEY (MANDT, VERTRAG)
);

Learn More