I_GTEEMCMTMTACTLDOCITEMBASIC
Grantee Management Commitment/Actual Document Items Basic
I_GTEEMCMTMTACTLDOCITEMBASIC is a CDS View in S/4HANA. Grantee Management Commitment/Actual Document Items Basic. It contains 82 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_GteeMCmtmtActlDocItem | view | from | COMPOSITE | Grantee Management Commitment/Actual Document Items |
Fields (82)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | GranteeMgmtLongSequenceNumber | GranteeMgmtLongSequenceNumber | 1 |
| _BillingStatus | _BillingStatus | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessTransactionType | _BusinessTransactionType | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _CompanyCodeFiscalYearVariant | _CompanyCodeFiscalYearVariant | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _FinMgmtArea | _FinMgmtArea | 1 | |
| _FinMgmtAreaFiscalYearVariant | _FinMgmtAreaFiscalYearVariant | 1 | |
| _FiscalCalendarDate | _FiscalCalendarDate | 1 | |
| _FiscalYearForCompanyCode | _FiscalYearForCompanyCode | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _Fund | _Fund | 1 | |
| _FundedProgram | _FundedProgram | 1 | |
| _GLAccount | _GLAccount | 1 | |
| _Grant | _Grant | 1 | |
| _GrantFiscalYearVariant | _GrantFiscalYearVariant | 1 | |
| _Ledger | _Ledger | 1 | |
| _LogicalSystem | _LogicalSystem | 1 | |
| _ReferenceDocLogicalSystem | _ReferenceDocLogicalSystem | 1 | |
| _ReferenceDocumentType | _ReferenceDocumentType | 1 | |
| _SponsoredClass | _SponsoredClass | 1 | |
| _SponsoredProgram | _SponsoredProgram | 1 | |
| _ValueType | _ValueType | 1 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 1 | |
| AmountInGrantCurrency | AmountInGrantCurrency | 1 | |
| AmountInOriginalCurrency | AmountInOriginalCurrency | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessTransactionType | BusinessTransactionType | 1 | |
| CommitmentItem | CommitmentItem | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCenter | CostCenter | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 1 | |
| FinancialManagementArea | FinancialManagementArea | 1 | |
| FinMgmtAreaFiscalYearVariant | FinMgmtAreaFiscalYearVariant | 1 | |
| FixedAsset | FixedAsset | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| FundedProgram | FundedProgram | 1 | |
| FundsCenter | FundsCenter | 1 | |
| GLAccount | GLAccount | 1 | |
| GrantCurrency | GrantCurrency | 1 | |
| GranteeFiscalYear | GranteeFiscalYear | 1 | |
| GranteeFiscalYearVariant | GranteeFiscalYearVariant | 1 | |
| GranteeMgmtBdgtWorkFlowSts | GranteeMgmtBdgtWorkFlowSts | 1 | |
| GranteeMgmtBillingStatus | GranteeMgmtBillingStatus | 1 | |
| GranteeMgmtItemIsCompleted | GranteeMgmtItemIsCompleted | 1 | |
| GranteeMgmtItemIsDeleted | GranteeMgmtItemIsDeleted | 1 | |
| GranteeMgmtValueType | GranteeMgmtValueType | 1 | |
| GrantFiscalYear | GrantFiscalYear | 1 | |
| GrantFiscalYearPeriod | GrantFiscalYearPeriod | 1 | |
| GrantFiscalYearVariant | GrantFiscalYearVariant | 1 | |
| GrantID | GrantID | 1 | |
| GteeMBudgetValidityNumber | GteeMBudgetValidityNumber | 1 | |
| IsStatisticalItem | IsStatisticalItem | 1 | |
| Ledger | Ledger | 1 | |
| LogicalSystem | LogicalSystem | 1 | |
| MasterFixedAsset | MasterFixedAsset | 1 | |
| Material | Material | 1 | |
| OrderID | OrderID | 1 | |
| OriginalCurrency | OriginalCurrency | 1 | |
| PostingDate | PostingDate | 1 | |
| PredecessorReferenceDocCntxt | PredecessorReferenceDocCntxt | 1 | |
| PredecessorReferenceDocItem | PredecessorReferenceDocItem | 1 | |
| PredecessorReferenceDocType | PredecessorReferenceDocType | 1 | |
| PredecessorReferenceDocument | PredecessorReferenceDocument | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| RefDocAccountAssignment | RefDocAccountAssignment | 1 | |
| ReferenceDocument | ReferenceDocument | 1 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 1 | |
| ReferenceDocumentFiscalYear | ReferenceDocumentFiscalYear | 1 | |
| ReferenceDocumentItem | ReferenceDocumentItem | 1 | |
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | 1 | |
| ReferenceDocumentScheduleLine | ReferenceDocumentScheduleLine | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| SponsoredClass | SponsoredClass | 1 | |
| SponsoredProgram | SponsoredProgram | 1 | |
| WBSElementInternalID | WBSElementInternalID | 1 |
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.
-- Grantee Management Commitment/Actual Document Items Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GTEEMCMTMTACTLDOCITEMBASIC (
GRANTEEMGMTLONGSEQUENCENUMBER,
_BILLINGSTATUS,
_BUSINESSAREA,
_BUSINESSTRANSACTIONTYPE,
_COMPANYCODE,
_COMPANYCODEFISCALYEARVARIANT,
_CONTROLLINGAREA,
_FINMGMTAREA,
_FINMGMTAREAFISCALYEARVARIANT,
_FISCALCALENDARDATE,
_FISCALYEARFORCOMPANYCODE,
_FUNCTIONALAREA,
_FUND,
_FUNDEDPROGRAM,
_GLACCOUNT,
_GRANT,
_GRANTFISCALYEARVARIANT,
_LEDGER,
_LOGICALSYSTEM,
_REFERENCEDOCLOGICALSYSTEM,
_REFERENCEDOCUMENTTYPE,
_SPONSOREDCLASS,
_SPONSOREDPROGRAM,
_VALUETYPE,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINGRANTCURRENCY,
AMOUNTINORIGINALCURRENCY,
BUSINESSAREA,
BUSINESSTRANSACTIONTYPE,
COMMITMENTITEM,
COMPANYCODE,
COMPANYCODECURRENCY,
CONTROLLINGAREA,
COSTCENTER,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
FINANCIALMANAGEMENTAREA,
FINMGMTAREAFISCALYEARVARIANT,
FIXEDASSET,
FUNCTIONALAREA,
FUND,
FUNDEDPROGRAM,
FUNDSCENTER,
GLACCOUNT,
GRANTCURRENCY,
GRANTEEFISCALYEAR,
GRANTEEFISCALYEARVARIANT,
GRANTEEMGMTBDGTWORKFLOWSTS,
GRANTEEMGMTBILLINGSTATUS,
GRANTEEMGMTITEMISCOMPLETED,
GRANTEEMGMTITEMISDELETED,
GRANTEEMGMTVALUETYPE,
GRANTFISCALYEAR,
GRANTFISCALYEARPERIOD,
GRANTFISCALYEARVARIANT,
GRANTID,
GTEEMBUDGETVALIDITYNUMBER,
ISSTATISTICALITEM,
LEDGER,
LOGICALSYSTEM,
MASTERFIXEDASSET,
MATERIAL,
ORDERID,
ORIGINALCURRENCY,
POSTINGDATE,
PREDECESSORREFERENCEDOCCNTXT,
PREDECESSORREFERENCEDOCITEM,
PREDECESSORREFERENCEDOCTYPE,
PREDECESSORREFERENCEDOCUMENT,
PROFITCENTER,
REFDOCACCOUNTASSIGNMENT,
REFERENCEDOCUMENT,
REFERENCEDOCUMENTCONTEXT,
REFERENCEDOCUMENTFISCALYEAR,
REFERENCEDOCUMENTITEM,
REFERENCEDOCUMENTLOGICALSYSTEM,
REFERENCEDOCUMENTSCHEDULELINE,
REFERENCEDOCUMENTTYPE,
SPONSOREDCLASS,
SPONSOREDPROGRAM,
WBSELEMENTINTERNALID,
PRIMARY KEY (GRANTEEMGMTLONGSEQUENCENUMBER)
);
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