R_CADOCUMENTGLITEMTP

CDS View

Document General Ledger Item - TP

R_CADOCUMENTGLITEMTP is a CDS View in S/4HANA. Document General Ledger Item - TP. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_CADocumentGLItem view_entity projection CONSUMPTION Document General Ledger Item
C_CADocumentGLItemTP view_entity projection CONSUMPTION Contr Acctg General Ledger Item
C_CADocumentTaxGLItem view_entity from CONSUMPTION Tax Item 
@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Document General Ledger Item - TP'

@ObjectModel: { modelingPattern: #NONE,
                //representativeKey: 'CAGLItemNumber',

                sapObjectNodeType.name: 'ContrAcctgDocumentGenLdgrItem',
                usageType: { dataClass: #TRANSACTIONAL,
                             serviceQuality: #C,
                             sizeCategory: #XXL } }

@VDM: { lifecycle.contract.type: #SAP_INTERNAL_API,
        viewType: #TRANSACTIONAL }

define view entity R_CADocumentGLItemTP
  as select from I_CADocumentGLItem
  
  association to parent R_CADocumentTP as _DocHeader on _DocHeader.CADocumentNumber = $projection.CADocumentNumber
  
  // Key User Extensibility. Is registered in transaction SCFD_REGISTRY. Do not change E_CADocumentGLItem or alias _Extension without adopting CFD regestry entry

  association [1..1] to E_CADocumentGLItem            as _Extension                   on  $projection.CADocumentNumber = _Extension.CADocumentNumber
                                                                                      and $projection.CAGLItemNumber   = _Extension.CAGLItemNumber

{
      //I_CADocumentGLItem

  key CADocumentNumber,
  key CAGLItemNumber,
      CompanyCode,
      BusinessArea,
      BusinessPlace,
      Segment,
      ProfitCenter,
      PartnerCompany,
      GLAccount,
      ValueDate,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      TransactionCurrency,
      Currency,
      CAAmountInLocalCurrency,
      CAAmountInTransactionCurrency,
      CAAmountInSecondCurrency,
      CAAmountInThirdCurrency,
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      CostCenter,
      SalesOrder,
      SalesOrderItem,
      CAReconciliationKey,
      CAInternalPostingReasonCode,
      CANegativePostingControlCode,
      CAGLPostingCurrency,
      LedgerGroup,
      ProfitabilitySegment_2,
      ProfitabilitySegmentChanges,
      PlanningLevel,
      CARepetitionGroup,
      CATransactionKeyAccountDetn,
      ConditionType,
      CAIsSeparateLineItemInGL,
      BaseUnit,
      TaxCode,
      CASupplementaryTaxCode,
      CAWithholdingTaxSupplement,
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      TaxJurisdiction,
      CAEnteredTaxJurisdictionCode,
      CATaxJurisdictionLevelCounter,
      CATaxExceptionID,
      CATaxDate,
      CATaxBaseAmountInLocalCurrency,
      CATaxBaseAmount,
      CANonDeductibleTxAmtInDocCrcy,
      CANonDeductibleTxAmtInLoclCrcy,
      CAContainsNonDeductibleInptTax,
      CATaxRate,
      GrossIncomeTaxActivityCode,
      EmploymentTaxDistributionType,
      CATaxPortionInLocalCurrency,
      CATaxPortionInTransCurrency,
      CATaxIsCalculatedExternally,
      CAAltvExchangeRateSetCode,
      CAIsCashFlowItem,
      CACashFlowAccount,
      CACashFlowCompanyCode,
      HouseBank,
      HouseBankAccount,
      QuantitySignCode,
      BankStatementShortID,
      BankStatementItem,
      CashManagementLinkType,
      CashManagementLink,
      CAItmIsCreatedByPostgInterface,
      CAStatusOfEuroConversion,
      CAProfitAnalysisUpdtIsDirect,
      CAInvcgGroupingKey,
      CACtrlFieldForAcctAssgmtDistr,
      CAUpdateMethodForFundsMgmt,
      OriginalFinancialMgmtArea,
      OriglYearForFinMgmtAcctAssgmt,
      EarmarkedFundsDocument,
      ChartOfAccounts,
      Country,
      TaxCalculationProcedure,
      WBSElementInternalID,
      
      /* Associations */
      //own associations

      _DocHeader,
      //associations from I_CADocumentGLItem

      _CAAccountAssignmentCategory,
      _BusinessArea,
      _CAAcctAssgmtDistrCode,
      _CAAcctDetnTransKey,
      _CAAltvExchangeRateSetCode,
      _CAEuroConversionStatus,
      _CAIntPostingReasonCode,
      _CANegativePostingCtrlCode,
      _CANonDcblInputTaxCode,
      _CashFlowAccount,
      _CAWithholdingTaxSupplement,
      _ChartOfAccounts,
      _CompanyCode,
      _CashFlowCompanyCode,
      _Country,
      _GLAccount,
      _GLPostingCurrency,
      _CAOtherTaxCode,
      _ProfitCenter,
      _PartnerCompany,
      _Segment,
      _WBSElementBasicData
}

Learn More