VICSAPPORTRULE_D

Transparent Table Application Table

Draft table for entity R_RESRVCGRPAPPORTIONMENTRULETP

VICSAPPORTRULE_D is an SAP database table in S/4HANA. Draft table for entity R_RESRVCGRPAPPORTIONMENTRULETP. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_REApportionmentRuleDraft view_entity from BASIC RE Apportionment Rule - Draft

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY reapportionmentruleuuid RECSAPPORTRULEGUID Apport. Rule GUID
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
internalrealestatenumber RECAINTRENO RE Key
retermtype RETMTERMTYPE Term Category
retermnumber RETMTERMNO Number
retermname RETMXTERM Name of Term
revacancypercent RECSVACANCYPERCENT Vacancy
realestateobjecttype RECAOBJTYPE Object Type
validitystartdate REBDVDMVALIDFROM Validity Start Date
validityenddate REBDVDMVALIDTO Validity End Date
unitofmeasure abap.unit
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_RESRVCGRPAPPORTIONMENTRULETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICSAPPORTRULE_D (
    MANDT,                          -- Client [MANDT]
    REAPPORTIONMENTRULEUUID,        -- Apport. Rule GUID [RECSAPPORTRULEGUID]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    INTERNALREALESTATENUMBER,       -- RE Key [RECAINTRENO]
    RETERMTYPE,                     -- Term Category [RETMTERMTYPE]
    RETERMNUMBER,                   -- Number [RETMTERMNO]
    RETERMNAME,                     -- Name of Term [RETMXTERM]
    REVACANCYPERCENT,               -- Vacancy [RECSVACANCYPERCENT]
    REALESTATEOBJECTTYPE,           -- Object Type [RECAOBJTYPE]
    VALIDITYSTARTDATE,              -- Validity Start Date [REBDVDMVALIDFROM]
    VALIDITYENDDATE,                -- Validity End Date [REBDVDMVALIDTO]
    UNITOFMEASURE,                  -- abap.unit
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, REAPPORTIONMENTRULEUUID, DRAFTUUID)
);