VITMOA
Term: Organizational Assignment
VITMOA is an SAP database table in S/4HANA. Term: Organizational Assignment. It contains 17 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FINOC_CHECK_REC_01_PRCTRS | view_entity | left_outer | Org. Change: PRCTRS of RE Contracts | |
| I_REContrOrglAssgmtTerm | view_entity | from | BASIC | Real Estate Organizational Assgmt Term |
| I_REOrganizationalAssgmtTerm | view_entity | from | BASIC | Real Estate Organizational Assgmt Term |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | intreno | RECAINTRENO | RE Key | |||
| KEY | termtype | RETMTERMTYPE | Term Category | |||
| KEY | termno | RETMTERMNO | Number | |||
| KEY | validfrom | RETMTERMVALIDFROM | Valid From | |||
| validto | RETMTERMVALIDTO | Valid To | ||||
| gsber | GSBER | Business Area | ||||
| prctr | PRCTR | Profit Center | ||||
| addobjnr | RERAADDOBJNR | Addit.Obj.No. | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| fund | RERAFUND | Fund | ||||
| fundscenter | RERAFUNDSCENTER | Funds Center | ||||
| commitmentitem | RERACOMMITMENTITEM | Commitment Item | ||||
| functionalarea | RERAFUNCTIONALAREA | Functional Area | ||||
| grantnumber | RERAGRANTNUMBER | Grant | ||||
| measure | RERAMEASURE | Funded Program | ||||
| budgetperiod | RERABUDGETPERIOD | Budget Period |
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.
-- Term: Organizational Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VITMOA (
MANDT, -- Client [MANDT]
INTRENO, -- RE Key [RECAINTRENO]
TERMTYPE, -- Term Category [RETMTERMTYPE]
TERMNO, -- Number [RETMTERMNO]
VALIDFROM, -- Valid From [RETMTERMVALIDFROM]
VALIDTO, -- Valid To [RETMTERMVALIDTO]
GSBER, -- Business Area [GSBER]
PRCTR, -- Profit Center [PRCTR]
ADDOBJNR, -- Addit.Obj.No. [RERAADDOBJNR]
TXJCD, -- Tax Jur. [TXJCD]
FUND, -- Fund [RERAFUND]
FUNDSCENTER, -- Funds Center [RERAFUNDSCENTER]
COMMITMENTITEM, -- Commitment Item [RERACOMMITMENTITEM]
FUNCTIONALAREA, -- Functional Area [RERAFUNCTIONALAREA]
GRANTNUMBER, -- Grant [RERAGRANTNUMBER]
MEASURE, -- Funded Program [RERAMEASURE]
BUDGETPERIOD, -- Budget Period [RERABUDGETPERIOD]
PRIMARY KEY (MANDT, INTRENO, TERMTYPE, TERMNO, VALIDFROM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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