R_CADocumentGLItemTP_2

DDL: R_CADOCUMENTGLITEMTP_2 Type: view_entity TRANSACTIONAL Package: RAP_FICA_CADOC

Document General Ledger Item - TP

R_CADocumentGLItemTP_2 is a Transactional CDS View that provides data about "Document General Ledger Item - TP" in SAP S/4HANA. It reads from 1 data source (I_CADocumentGLItemEnhanced) and exposes 113 fields with key fields CADocumentNumber, CAGLItemNumber. It has 1 association to related views. Part of development package RAP_FICA_CADOC.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentGLItemEnhanced I_CADocumentGLItemEnhanced from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CADocumentGLItem _Extension $projection.CADocumentNumber = _Extension.CADocumentNumber and $projection.CAGLItemNumber = _Extension.CAGLItemNumber

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Document General Ledger Item - TP view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name ContrAcctgDocumentGenLdgrItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (113)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
KEY CAGLItemNumber CAGLItemNumber
CompanyCode CompanyCode
BusinessArea BusinessArea
BusinessPlace BusinessPlace
Segment Segment
ProfitCenter ProfitCenter
PartnerCompany PartnerCompany
GLAccount GLAccount
WBSElementInternalID WBSElementInternalID
ValueDate ValueDate
CAExchangeRate CAExchangeRate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation
TransactionCurrency TransactionCurrency
Currency Currency
AdditionalCurrency1 AdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
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
QuantityInBaseUnit QuantityInBaseUnit
BaseUnit BaseUnit
CAGroupingKeyDocumentItems CAGroupingKeyDocumentItems
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
TaxCountry TaxCountry
TransToTaxCntryCrcyCnvrsnFctr TransToTaxCntryCrcyCnvrsnFctr
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
ChartOfAccounts ChartOfAccounts
Country Country
TaxCalculationProcedure TaxCalculationProcedure
_CADocument _CADocument
_BaseUnit _BaseUnit
_BusinessArea _BusinessArea
_CAAccountAssignmentCategory _CAAccountAssignmentCategory
_CAAcctAssgmtDistrCode _CAAcctAssgmtDistrCode
_CAAcctDetnTransKey _CAAcctDetnTransKey
_CAAltvExchangeRateSetCode _CAAltvExchangeRateSetCode
_CAEuroConversionStatus _CAEuroConversionStatus
_CAIntPostingReasonCode _CAIntPostingReasonCode
_CANegativePostingCtrlCode _CANegativePostingCtrlCode
_CANonDcblInputTaxCode _CANonDcblInputTaxCode
_CAOtherTaxCode _CAOtherTaxCode
_CashFlowAccount _CashFlowAccount
_CashFlowCompanyCode _CashFlowCompanyCode
_CAWithholdingTaxSupplement _CAWithholdingTaxSupplement
_ChartOfAccounts _ChartOfAccounts
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_Country _Country
_GLAccount _GLAccount
_GLPostingCurrency _GLPostingCurrency
_ProfitCenter _ProfitCenter
_PartnerCompany _PartnerCompany
_Segment _Segment
_TaxCountry _TaxCountry
_TransactionCurrency _TransactionCurrency
_WBSElementBasicData _WBSElementBasicData
@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_2
  as select from I_CADocumentGLItemEnhanced
  
  association to parent R_CADocumentTP_2 as _CADocument on _CADocument.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,
      WBSElementInternalID,
      ValueDate,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      TransactionCurrency,
      Currency,
      AdditionalCurrency1,
      AdditionalCurrency2,      
      CAAmountInLocalCurrency,
      CAAmountInTransactionCurrency,
      CAAmountInSecondCurrency,
      CAAmountInThirdCurrency,
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      CostCenter,
      SalesOrder,
      SalesOrderItem,
      CAReconciliationKey,
      CAInternalPostingReasonCode,
      CANegativePostingControlCode,
      CAGLPostingCurrency,
      LedgerGroup,
      ProfitabilitySegment_2,
      ProfitabilitySegmentChanges,
      PlanningLevel,
      CARepetitionGroup,
      CATransactionKeyAccountDetn,
      ConditionType,
      CAIsSeparateLineItemInGL,
      QuantityInBaseUnit,
      BaseUnit,
      CAGroupingKeyDocumentItems,
      TaxCode,
      CASupplementaryTaxCode,
      CAWithholdingTaxSupplement,
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      TaxJurisdiction,
      CAEnteredTaxJurisdictionCode,
      CATaxJurisdictionLevelCounter,
      CATaxExceptionID,
      CATaxDate,
      CATaxBaseAmountInLocalCurrency,
      CATaxBaseAmount,
      CANonDeductibleTxAmtInDocCrcy,
      CANonDeductibleTxAmtInLoclCrcy,
      CAContainsNonDeductibleInptTax,
      CATaxRate,
      GrossIncomeTaxActivityCode,
      EmploymentTaxDistributionType,
      CATaxPortionInLocalCurrency,
      CATaxPortionInTransCurrency,
      CATaxIsCalculatedExternally,
      CAAltvExchangeRateSetCode,
      TaxCountry,
      TransToTaxCntryCrcyCnvrsnFctr,
      CAIsCashFlowItem,
      CACashFlowAccount,
      CACashFlowCompanyCode,
      HouseBank,
      HouseBankAccount,
      QuantitySignCode,
      BankStatementShortID,
      BankStatementItem,
      CashManagementLinkType,
      CashManagementLink,
      CAItmIsCreatedByPostgInterface,
      CAStatusOfEuroConversion,
      CAProfitAnalysisUpdtIsDirect,
      CAInvcgGroupingKey,
      CACtrlFieldForAcctAssgmtDistr,
      CAUpdateMethodForFundsMgmt,
      OriginalFinancialMgmtArea,
      OriglYearForFinMgmtAcctAssgmt,
      EarmarkedFundsDocument,
      ChartOfAccounts,
      Country,
      TaxCalculationProcedure,
      
      /* Associations */
      //own associations

      _CADocument,
      //associations from I_CADocumentGLItem

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