VITMPY_D

Transparent Table Application Table
50 Fields 2 CDS Views

Draft table for entity R_RECONTRPOSTINGTERMTP

VITMPY_D is an SAP database table in S/4HANA. Draft table for entity R_RECONTRPOSTINGTERMTP. It contains 50 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_REPostingTermDraft view_entity from BASIC RE Posting Term - Draft
R_REContrPostingDraft view_entity from BASIC Draft query view R_REContrPostingDraft

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY internalrealestatenumber RECAINTRENO RE Key
KEY retermtype RETMTERMTYPE Term Category
KEY retermnumber RETMTERMNO Number
KEY validitystartenddatevalue RECADATEPERIOD Validity Period
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
validitystartdate REBDVDMVALIDFROM Validity Start Date
validityenddate REBDVDMVALIDTO Validity End Date
reentryvalidity RECAVDMENTRYVALIDITY Entry Validity
reentryvaliditycriticality abap.int1
retermname RETMXTERM Name of Term
realestateobjecttype RECAOBJTYPE Object Type
reidentificationkey RECAIDENTKEY Object ID
restatusobject RECAOBJNR Object Number
reaccountingobjecttype abap.char
reidentification RECAIDENT Object
paymentmethod FARP_SCHZW_BSEG Payment Method
repaymentmethodcreditmemo RETMVDMPYMTMETHCRMO Payment Method for Credit Memos
paymentblockingreason FARP_DZLSPR Item Payment Block
paymentterms RERAPYMTTERM Paymnt Terms
housebank FARP_HBKID House Bank
housebankaccount FAC_HKTID House Bank Account
bankidentification RETMVDMBANKIDENT Bank Details
renotetopayeetext RERANOTETOPAYEE Note to Payee
dunningarea FARP_MABER Dunning Area
dunningkey FARP_MSCHL Dunning Key
dunningblockingreason FARP_MANSP Dunning Block
reacctdeterminationkey RETMVDMACCDETKEY Account Determination Value
retaxtype RERATAXTYPE Tax Type
taxgroup RERATAXGROUP Tax Group
reisconditiongrossamount RECDISGROSS Gross
taxcountry RETMVDMTAXCOUNTRY Alternative Tax Reporting Country/Region
businesspartner BU_PARTNER Busn. Partner
reaccountingobject RETMVDMPARTNEROBJNR Internal Object Number
taxjurisdiction TXJCD Tax Jur.
reisconditionsplit RETMISCDSPLIT Split
recurrencytranslationrule RETMVDMCACTRULE Currency Translation Rule
reispartnerblocked RERAISPARTNERBLOCKED Partner Lock
sepamandate RETMSEPAMNDID SEPA Mandate
sepamandatecreditor RETMSEPARECCRDID Creditor ID
companycode BUKRS Company Code
country LAND1 Country/Reg.
taxcalculationprocedure KALSM_D Procedure
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_RECONTRPOSTINGTERMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VITMPY_D (
    MANDT,                          -- Client [MANDT]
    INTERNALREALESTATENUMBER,       -- RE Key [RECAINTRENO]
    RETERMTYPE,                     -- Term Category [RETMTERMTYPE]
    RETERMNUMBER,                   -- Number [RETMTERMNO]
    VALIDITYSTARTENDDATEVALUE,      -- Validity Period [RECADATEPERIOD]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    VALIDITYSTARTDATE,              -- Validity Start Date [REBDVDMVALIDFROM]
    VALIDITYENDDATE,                -- Validity End Date [REBDVDMVALIDTO]
    REENTRYVALIDITY,                -- Entry Validity [RECAVDMENTRYVALIDITY]
    REENTRYVALIDITYCRITICALITY,     -- abap.int1
    RETERMNAME,                     -- Name of Term [RETMXTERM]
    REALESTATEOBJECTTYPE,           -- Object Type [RECAOBJTYPE]
    REIDENTIFICATIONKEY,            -- Object ID [RECAIDENTKEY]
    RESTATUSOBJECT,                 -- Object Number [RECAOBJNR]
    REACCOUNTINGOBJECTTYPE,         -- abap.char
    REIDENTIFICATION,               -- Object [RECAIDENT]
    PAYMENTMETHOD,                  -- Payment Method [FARP_SCHZW_BSEG]
    REPAYMENTMETHODCREDITMEMO,      -- Payment Method for Credit Memos [RETMVDMPYMTMETHCRMO]
    PAYMENTBLOCKINGREASON,          -- Item Payment Block [FARP_DZLSPR]
    PAYMENTTERMS,                   -- Paymnt Terms [RERAPYMTTERM]
    HOUSEBANK,                      -- House Bank [FARP_HBKID]
    HOUSEBANKACCOUNT,               -- House Bank Account [FAC_HKTID]
    BANKIDENTIFICATION,             -- Bank Details [RETMVDMBANKIDENT]
    RENOTETOPAYEETEXT,              -- Note to Payee [RERANOTETOPAYEE]
    DUNNINGAREA,                    -- Dunning Area [FARP_MABER]
    DUNNINGKEY,                     -- Dunning Key [FARP_MSCHL]
    DUNNINGBLOCKINGREASON,          -- Dunning Block [FARP_MANSP]
    REACCTDETERMINATIONKEY,         -- Account Determination Value [RETMVDMACCDETKEY]
    RETAXTYPE,                      -- Tax Type [RERATAXTYPE]
    TAXGROUP,                       -- Tax Group [RERATAXGROUP]
    REISCONDITIONGROSSAMOUNT,       -- Gross [RECDISGROSS]
    TAXCOUNTRY,                     -- Alternative Tax Reporting Country/Region [RETMVDMTAXCOUNTRY]
    BUSINESSPARTNER,                -- Busn. Partner [BU_PARTNER]
    REACCOUNTINGOBJECT,             -- Internal Object Number [RETMVDMPARTNEROBJNR]
    TAXJURISDICTION,                -- Tax Jur. [TXJCD]
    REISCONDITIONSPLIT,             -- Split [RETMISCDSPLIT]
    RECURRENCYTRANSLATIONRULE,      -- Currency Translation Rule [RETMVDMCACTRULE]
    REISPARTNERBLOCKED,             -- Partner Lock [RERAISPARTNERBLOCKED]
    SEPAMANDATE,                    -- SEPA Mandate [RETMSEPAMNDID]
    SEPAMANDATECREDITOR,            -- Creditor ID [RETMSEPARECCRDID]
    COMPANYCODE,                    -- Company Code [BUKRS]
    COUNTRY,                        -- Country/Reg. [LAND1]
    TAXCALCULATIONPROCEDURE,        -- Procedure [KALSM_D]
    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, INTERNALREALESTATENUMBER, RETERMTYPE, RETERMNUMBER, VALIDITYSTARTENDDATEVALUE, DRAFTUUID)
);

Learn More