C_OperatingGLAcctInCoCodeTP
Mass Creation of GL accounts
C_OperatingGLAcctInCoCodeTP is a Consumption CDS View that provides data about "Mass Creation of GL accounts" in SAP S/4HANA. It reads from 1 data source (R_OperatingGLAcctInCoCodeTP) and exposes 67 fields with key fields GLAccount, CompanyCode, ChartOfAccounts. It is exposed through 3 OData services (ASQL_F0731B, ASQL_F8417, UI_OPERATINGGLACCOUNT). Part of development package RAP_FI_GL_COCODE.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_OperatingGLAcctInCoCodeTP | R_OperatingGLAcctInCoCodeTP | projection |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Mass Creation of GL accounts | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Search.searchable | true | view | |
| Metadata.allowExtensions | true | view |
OData Services (3)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| ASQL_F0731B | ASQL_F0731B | C2 | NOT_RELEASED | |
| ASQL_F8417 | ASQL_F8417 | C2 | NOT_RELEASED | |
| UI_OPERATINGGLACCOUNT | UI_OPERATINGGLACCOUNT | V4 | C1 | NOT_RELEASED |
Fields (67)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | GLAccount | GLAccount | General Ledger | |
| KEY | CompanyCode | CompanyCode | Receiver Company Code | |
| KEY | ChartOfAccounts | ChartOfAccounts | Node Class | |
| ChartOfAccountsName | ||||
| GLAccountName | ||||
| CompanyCodeName | CompanyCodeName | Company Name | ||
| LastInterestCalcRunDate | LastInterestCalcRunDate | Date of Last Interest Calculation | ||
| CreationDate | CreationDate | Created On | ||
| virtualUICT_CreationDateabap_boolean | ||||
| CreatedByUser | CreatedByUser | Created By | ||
| _CreatedBy | _CreatedBy | |||
| CreatedByUserFullName | _CreatedBy | FullName | Name | |
| virtualUICT_CreatedByUserabap_boolean | ||||
| LastChangeDateTime | LastChangeDateTime | Last Changed | ||
| PlanningLevelDescription | ||||
| PlanningLevel | PlanningLevel | Planning Level | ||
| virtualUICT_PlanningLevelabap_boolean | ||||
| HouseBank | HouseBank | House Bank | ||
| virtualUICT_HouseBankabap_boolean | ||||
| HouseBankAccountDescription | ||||
| HouseBankAccount | HouseBankAccount | House Bank Account | ||
| virtualUICT_HouseBankAccountabap_boolean | ||||
| ExchRateDifferencesAccountDetn | ExchRateDifferencesAccountDetn | Exchange Rate Difference Key | ||
| ReconciliationAccountTypeName | ||||
| ReconciliationAccountType | ReconciliationAccountType | Reconciliation Account Type | ||
| TaxCategoryName | ||||
| TaxCategory | TaxCategory | Tax Code | ||
| virtualUICT_TaxCategoryabap_boolean | ||||
| InterestCalculationCodeName | ||||
| InterestCalculationCode | InterestCalculationCode | Interest Indic. | ||
| CurrencyName | ||||
| GLAccountCurrency | GLAccountCurrency | Currency | ||
| ReconciliationAcctIsChangeable | ReconciliationAcctIsChangeable | Reconciliation Acct Ready for Input | ||
| IsAutomaticallyPosted | IsAutomaticallyPosted | Only Automatic Postings | ||
| SupplementIsAllowed | SupplementIsAllowed | Supplement | ||
| IsOpenItemManaged | IsOpenItemManaged | Open Item Management | ||
| InterestCalculationDate | InterestCalculationDate | Last Key Date | ||
| IntrstCalcFrequencyMonthsName | ||||
| IntrstCalcFrequencyInMonths | IntrstCalcFrequencyInMonths | Int.Calc.Freq. | ||
| AcctgDocItmDspSequenceRuleName | _SortKeyText | AcctgDocItmDspSequenceRuleName | ||
| AcctgDocItmDisplaySequenceRule | AcctgDocItmDisplaySequenceRule | Sort key | ||
| AlternativeGLAccountName | ||||
| AlternativeGLAccount | AlternativeGLAccount | Group Account | ||
| JointVentureRecoveryCode | JointVentureRecoveryCode | Recovery Ind. | ||
| TaxCodeIsRequired | TaxCodeIsRequired | Posting without Tax Allowed | ||
| BalanceHasLocalCurrency | BalanceHasLocalCurrency | Balances in Local Currency Only | ||
| ValuationGroup | ValuationGroup | Valuation Group | ||
| virtualUICT_ValuationGroupabap_boolean | ||||
| APARToleranceGroup | APARToleranceGroup | Tolerance Group | ||
| AccountIsBlockedForPosting | AccountIsBlockedForPosting | Posting Block | ||
| AccountIsMarkedForDeletion | AccountIsMarkedForDeletion | Deletion Flag | ||
| ClearingIsLedgerGroupSpecific | ClearingIsLedgerGroupSpecific | Open Item Management by Ledger Group | ||
| IsCashFlowAccount | IsCashFlowAccount | Relevant to Cash Flow | ||
| FieldStatusGroupName | ||||
| FieldStatusGroup | FieldStatusGroup | Field Status Grp | ||
| virtualUICT_FieldStatusGroupabap_boolean | ||||
| FieldStatusVariant | FieldStatusVariant | Fld stat.var. | ||
| IsExtendedOpenItemManaged | IsExtendedOpenItemManaged | Extended Open Item Management | ||
| CountryChartOfAccounts | CountryChartOfAccounts | Chart of Accts | ||
| GLAcctCOAImplementStatusName | ||||
| GLAcctCoCodeImplementStatus | GLAcctCoCodeImplementStatus | Implementation Status in Company Code | ||
| GLAccountCoCodIsDeliveredBySAP | _GLAcctInCoCodeStatus | GLAccountCoCodIsDeliveredBySAP | Delivered by SAP | |
| virtualUICT_FacetBankingabap_boolean | ||||
| virtualUICT_FacetInterestabap_boolean | ||||
| _Text | _Text | |||
| _FieldStatusGroup | _FieldStatusGroup | |||
| _GLAcctInCoCodeStatus | _GLAcctInCoCodeStatus |
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 C_OperatingGLAcctInCoCodeTP.
-- 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.
CREATE VIEW C_OperatingGLAcctInCoCodeTP AS
SELECT
GLAccount,
CompanyCode,
ChartOfAccounts,
_GLAcctInCOA._ChartOfAccountsText[1: Language = $session.system_language].ChartOfAccountsName AS ChartOfAccountsName,
_Text[1: Language = $session.system_language].GLAccountName AS GLAccountName,
CompanyCodeName,
LastInterestCalcRunDate,
CreationDate,
virtual UICT_CreationDate : abap_boolean AS virtualUICT_CreationDateabap_boolean,
CreatedByUser,
_CreatedBy.FullName AS CreatedByUserFullName,
virtual UICT_CreatedByUser : abap_boolean AS virtualUICT_CreatedByUserabap_boolean,
LastChangeDateTime,
_PlanningLevel._Text[1: Language = $session.system_language].PlanningLevelDescription AS PlanningLevelDescription,
PlanningLevel,
virtual UICT_PlanningLevel : abap_boolean AS virtualUICT_PlanningLevelabap_boolean,
HouseBank,
virtual UICT_HouseBank : abap_boolean AS virtualUICT_HouseBankabap_boolean,
_HouseBankAccount._Text[1: Language = $session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
HouseBankAccount,
virtual UICT_HouseBankAccount : abap_boolean AS virtualUICT_HouseBankAccountabap_boolean,
ExchRateDifferencesAccountDetn,
_ReconciliationAcctType._Text[1: Language = $session.system_language].ReconciliationAccountTypeName AS ReconciliationAccountTypeName,
ReconciliationAccountType,
_TaxCategory._Text[1: Language = $session.system_language].TaxCategoryName AS TaxCategoryName,
TaxCategory,
virtual UICT_TaxCategory : abap_boolean AS virtualUICT_TaxCategoryabap_boolean,
_InterestCode._Text[1: Language = $session.system_language].InterestCalculationCodeName AS InterestCalculationCodeName,
InterestCalculationCode,
_CurrencyText[1: Language = $session.system_language].CurrencyName AS CurrencyName,
GLAccountCurrency,
ReconciliationAcctIsChangeable,
IsAutomaticallyPosted,
SupplementIsAllowed,
IsOpenItemManaged,
InterestCalculationDate,
_IntrstFreqText[1: Language = $session.system_language].IntrstCalcFrequencyMonthsName AS IntrstCalcFrequencyMonthsName,
IntrstCalcFrequencyInMonths,
_SortKeyText.AcctgDocItmDspSequenceRuleName AS AcctgDocItmDspSequenceRuleName,
AcctgDocItmDisplaySequenceRule,
_AlternativeGLAccount._Text[1: Language = $session.system_language].GLAccountLongName AS AlternativeGLAccountName,
AlternativeGLAccount,
JointVentureRecoveryCode,
TaxCodeIsRequired,
BalanceHasLocalCurrency,
ValuationGroup,
virtual UICT_ValuationGroup : abap_boolean AS virtualUICT_ValuationGroupabap_boolean,
APARToleranceGroup,
AccountIsBlockedForPosting,
AccountIsMarkedForDeletion,
ClearingIsLedgerGroupSpecific,
IsCashFlowAccount,
_FieldStatusGroup._Text[1: Language = $session.system_language].FieldStatusGroupName AS FieldStatusGroupName,
FieldStatusGroup,
virtual UICT_FieldStatusGroup : abap_boolean AS virtualUICT_FieldStatusGroupabap_boolean,
FieldStatusVariant,
IsExtendedOpenItemManaged,
CountryChartOfAccounts,
_GLAcctImplementStatus._Text[1: Language = $session.system_language].GLAcctCOAImplementStatusName AS GLAcctCOAImplementStatusName,
GLAcctCoCodeImplementStatus,
_GLAcctInCoCodeStatus.GLAccountCoCodIsDeliveredBySAP AS GLAccountCoCodIsDeliveredBySAP,
virtual UICT_FacetBanking : abap_boolean AS virtualUICT_FacetBankingabap_boolean,
virtual UICT_FacetInterest : abap_boolean AS virtualUICT_FacetInterestabap_boolean
FROM R_OperatingGLAcctInCoCodeTP
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA