A_CADocumentGLItem

DDL: A_CADOCUMENTGLITEM Type: view_entity CONSUMPTION

Document General Ledger Item

A_CADocumentGLItem is a Consumption CDS View that provides data about "Document General Ledger Item" in SAP S/4HANA. It reads from 1 data source (R_CADocumentGLItemTP) and exposes 76 fields with key fields CADocumentNumber, CAGLItemNumber.

1 data source(s) 76 fields

Data Sources (1)

SourceAliasJoin Type
R_CADocumentGLItemTP R_CADocumentGLItemTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document General Ledger Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
OData.entityType.name CADocGLItem_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
KEY CAGLItemNumber CAGLItemNumber
CompanyCode CompanyCode
BusinessArea BusinessArea
BusinessPlace BusinessPlace
Segment Segment
ProfitCenter ProfitCenter
PartnerCompany PartnerCompany
GLAccount GLAccount
ValueDate ValueDate
CAExchangeRate CAExchangeRate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation
TransactionCurrency TransactionCurrency
Currency Currency
CAAmountInLocalCurrency CAAmountInLocalCurrency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
CAAmountInSecondCurrency CAAmountInSecondCurrency
CAAmountInThirdCurrency CAAmountInThirdCurrency
CAAccountAssignmentCategory CAAccountAssignmentCategory
CAAccountAssignment CAAccountAssignment
CostCenter CostCenter
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
CAReconciliationKey CAReconciliationKey
CAInternalPostingReasonCode CAInternalPostingReasonCode
CANegativePostingControlCode CANegativePostingControlCode
CAGLPostingCurrency CAGLPostingCurrency
LedgerGroup LedgerGroup
ProfitabilitySegment_2 ProfitabilitySegment_2
ProfitabilitySegmentChanges ProfitabilitySegmentChanges
PlanningLevel PlanningLevel
CARepetitionGroup CARepetitionGroup
CATransactionKeyAccountDetn CATransactionKeyAccountDetn
ConditionType ConditionType
CAIsSeparateLineItemInGL CAIsSeparateLineItemInGL
BaseUnit BaseUnit
TaxCode TaxCode
CASupplementaryTaxCode CASupplementaryTaxCode
CAWithholdingTaxSupplement CAWithholdingTaxSupplement
CAOtherTaxCode CAOtherTaxCode
CAGroupingCodeForTaxItems CAGroupingCodeForTaxItems
TaxJurisdiction TaxJurisdiction
CAEnteredTaxJurisdictionCode CAEnteredTaxJurisdictionCode
CATaxJurisdictionLevelCounter CATaxJurisdictionLevelCounter
CATaxExceptionID CATaxExceptionID
CATaxDate CATaxDate
CATaxBaseAmountInLocalCurrency CATaxBaseAmountInLocalCurrency
CATaxBaseAmount CATaxBaseAmount
CANonDeductibleTxAmtInDocCrcy CANonDeductibleTxAmtInDocCrcy
CANonDeductibleTxAmtInLoclCrcy CANonDeductibleTxAmtInLoclCrcy
CAContainsNonDeductibleInptTax CAContainsNonDeductibleInptTax
CATaxRate CATaxRate
GrossIncomeTaxActivityCode GrossIncomeTaxActivityCode
EmploymentTaxDistributionType EmploymentTaxDistributionType
CATaxPortionInLocalCurrency CATaxPortionInLocalCurrency
CATaxPortionInTransCurrency CATaxPortionInTransCurrency
CATaxIsCalculatedExternally CATaxIsCalculatedExternally
CAAltvExchangeRateSetCode CAAltvExchangeRateSetCode
CAIsCashFlowItem CAIsCashFlowItem
CACashFlowAccount CACashFlowAccount
CACashFlowCompanyCode CACashFlowCompanyCode
HouseBank HouseBank
HouseBankAccount HouseBankAccount
QuantitySignCode QuantitySignCode
BankStatementShortID BankStatementShortID
BankStatementItem BankStatementItem
CashManagementLinkType CashManagementLinkType
CashManagementLink CashManagementLink
CAItmIsCreatedByPostgInterface CAItmIsCreatedByPostgInterface
CAProfitAnalysisUpdtIsDirect CAProfitAnalysisUpdtIsDirect
CAInvcgGroupingKey CAInvcgGroupingKey
CACtrlFieldForAcctAssgmtDistr CACtrlFieldForAcctAssgmtDistr
CAUpdateMethodForFundsMgmt CAUpdateMethodForFundsMgmt
OriginalFinancialMgmtArea OriginalFinancialMgmtArea
OriglYearForFinMgmtAcctAssgmt OriglYearForFinMgmtAcctAssgmt
EarmarkedFundsDocument EarmarkedFundsDocument 
@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Document General Ledger Item'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { usageType: { dataClass: #TRANSACTIONAL,
                             serviceQuality: #C,
                             sizeCategory: #XXL } }

@OData.entityType.name: 'CADocGLItem_Type'

@VDM: { lifecycle.contract.type: #PUBLIC_REMOTE_API,
        viewType: #CONSUMPTION }

define view entity A_CADocumentGLItem
  as projection on R_CADocumentGLItemTP

{
      //I_CADocumentGLItem

  key CADocumentNumber,
  key CAGLItemNumber,
      @ObjectModel.sapObjectNodeTypeReference: 'CompanyCode'
      CompanyCode,
      @ObjectModel.sapObjectNodeTypeReference: 'BusinessArea'
      BusinessArea,
      @ObjectModel.sapObjectNodeTypeReference: 'BusinessPlace'
      BusinessPlace,
      @ObjectModel.sapObjectNodeTypeReference: 'Segment'
      Segment,
      @ObjectModel.sapObjectNodeTypeReference: 'ProfitCenter'
      ProfitCenter,
      PartnerCompany,
      @ObjectModel.sapObjectNodeTypeReference: 'GeneralLedgerAccount'
      GLAccount,
      ValueDate,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      TransactionCurrency,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      Currency,
      @Semantics.amount.currencyCode: 'Currency'
      CAAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'Currency'
      CAAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'Currency'
      CAAmountInThirdCurrency,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgAccountAssignmentCat'
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      CostCenter,
      SalesOrder,
      SalesOrderItem,
      CAReconciliationKey,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgIntPostingReasonCode'
      CAInternalPostingReasonCode,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgNgtvPostingCtrlCode'
      CANegativePostingControlCode,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      CAGLPostingCurrency,
      LedgerGroup,
      ProfitabilitySegment_2,
      ProfitabilitySegmentChanges,
      @ObjectModel.sapObjectNodeTypeReference: 'CashFlowPlanningLevel'
      PlanningLevel,
      CARepetitionGroup,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgAcctDetnTransKey'
      CATransactionKeyAccountDetn,
      ConditionType,
      CAIsSeparateLineItemInGL,
      BaseUnit,
      TaxCode,
      CASupplementaryTaxCode,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgWhldgTaxSupplement'
      CAWithholdingTaxSupplement,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgOtherTaxCode'
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      @ObjectModel.sapObjectNodeTypeReference: 'TaxJurisdiction'
      TaxJurisdiction,
      @ObjectModel.sapObjectNodeTypeReference: 'TaxJurisdiction'
      CAEnteredTaxJurisdictionCode,
      CATaxJurisdictionLevelCounter,
      CATaxExceptionID,
      CATaxDate,
      @Semantics.amount.currencyCode: 'Currency'
      CATaxBaseAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxBaseAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CANonDeductibleTxAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      CANonDeductibleTxAmtInLoclCrcy,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgNonDcblInputTaxCode'
      CAContainsNonDeductibleInptTax,
      CATaxRate,
      GrossIncomeTaxActivityCode,
      EmploymentTaxDistributionType,
      @Semantics.amount.currencyCode: 'Currency'
      CATaxPortionInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxPortionInTransCurrency,
      CATaxIsCalculatedExternally,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgAltvExchRateSetCode'
      CAAltvExchangeRateSetCode,
      CAIsCashFlowItem,
      @ObjectModel.sapObjectNodeTypeReference: 'GeneralLedgerAccount'
      CACashFlowAccount,
      @ObjectModel.sapObjectNodeTypeReference: 'CompanyCode'
      CACashFlowCompanyCode,
      HouseBank,
      HouseBankAccount,
      QuantitySignCode,
      BankStatementShortID,
      BankStatementItem,
      CashManagementLinkType,
      CashManagementLink,
      CAItmIsCreatedByPostgInterface,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgEuroConversionStatus'
      CAStatusOfEuroConversion,
      CAProfitAnalysisUpdtIsDirect,
      CAInvcgGroupingKey,
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgAcctAssgmtDistrCode'
      CACtrlFieldForAcctAssgmtDistr,
      CAUpdateMethodForFundsMgmt,
      OriginalFinancialMgmtArea,
      OriglYearForFinMgmtAcctAssgmt,
      //EarmarkedFunds,

      EarmarkedFundsDocument,

      /* Associations */
      _DocHeader : redirected to parent A_CADocumentHeader
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CADOCUMENTGLITEMTP"
],
"ASSOCIATED":
[
"A_CADOCUMENTHEADER",
"R_CADOCUMENTTP"
],
"BASE":
[
"R_CADOCUMENTGLITEMTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More