I_GLAcctDraft

DDL: I_GLACCTDRAFT SQL: IGLACOADI Type: view BASIC
20 Fields 1 Data Sources

Draft info for account in ChtAccts

I_GLAcctDraft is a Basic CDS View (Dimension) that provides data about "Draft info for account in ChtAccts" in SAP S/4HANA. It reads from 1 data source (ska1_draft_20) and exposes 20 fields with key field GLAcctInChartOfAcctsDraftUUID.

Data Sources (1)

SourceAliasJoin Type
ska1_draft_20 draft from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IGLACOADI view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Draft info for account in ChtAccts view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey GLAcctInChartOfAcctsDraftUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY GLAcctInChartOfAcctsDraftUUID ska1_draft_20 draftuuid UUID
ActiveChartOfAccounts ska1_draft_20 chartofaccounts Node Class
ActiveGLAccount ska1_draft_20 glaccount General Ledger
IsBalanceSheetAccount ska1_draft_20 isbalancesheetaccount Is Balance Sheet Account
GLAccountGroup ska1_draft_20 glaccountgroup Account Group
CorporateGroupAccount ska1_draft_20 corporategroupaccount Group Account Number
ProfitLossAccountType ska1_draft_20 profitlossaccounttype Profit Loss Account Type
SampleGLAccount ska1_draft_20 sampleglaccount Sample Account
AccountIsMarkedForDeletion ska1_draft_20 accountismarkedfordeletion Deletion Flag
AccountIsBlockedForCreation ska1_draft_20 accountisblockedforcreation Creation Block
AccountIsBlockedForPosting ska1_draft_20 accountisblockedforposting Posting Block
AccountIsBlockedForPlanning ska1_draft_20 accountisblockedforplanning Planning Block
PartnerCompany ska1_draft_20 partnercompany Trading Partner
FunctionalArea ska1_draft_20 functionalarea Sendr Fctl Area
CreationDate ska1_draft_20 creationdate Time Stamp
CreatedByUser ska1_draft_20 createdbyuser User Name
GLAccountType ska1_draft_20 glaccounttype G/L Account Type
DraftReferenceChartOfAccounts ska1_draft_20 draftreferencechartofaccounts Chart of Accts
DraftReferenceGLAccount ska1_draft_20 draftreferenceglaccount G/L Account
HasActiveEntity ska1_draft_20 hasactiveentity TRUE

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_GLAcctDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IGLACOADI

CREATE VIEW I_GLAcctDraft AS
SELECT
  draft.draftuuid AS GLAcctInChartOfAcctsDraftUUID,
  draft.chartofaccounts AS ActiveChartOfAccounts,
  draft.glaccount AS ActiveGLAccount,
  draft.isbalancesheetaccount AS IsBalanceSheetAccount,
  draft.glaccountgroup AS GLAccountGroup,
  draft.corporategroupaccount AS CorporateGroupAccount,
  draft.profitlossaccounttype AS ProfitLossAccountType,
  draft.sampleglaccount AS SampleGLAccount,
  draft.accountismarkedfordeletion AS AccountIsMarkedForDeletion,
  draft.accountisblockedforcreation AS AccountIsBlockedForCreation,
  draft.accountisblockedforposting AS AccountIsBlockedForPosting,
  draft.accountisblockedforplanning AS AccountIsBlockedForPlanning,
  draft.partnercompany AS PartnerCompany,
  draft.functionalarea AS FunctionalArea,
  draft.creationdate AS CreationDate,
  draft.createdbyuser AS CreatedByUser,
  draft.glaccounttype AS GLAccountType,
  draft.draftreferencechartofaccounts AS DraftReferenceChartOfAccounts,
  draft.draftreferenceglaccount AS DraftReferenceGLAccount,
  draft.hasactiveentity AS HasActiveEntity
FROM ska1_draft_20 AS draft
;

Learn More