R_CADocumentGLItemTP
Document General Ledger Item - TP
R_CADocumentGLItemTP 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_CADocumentGLItem) and exposes 102 fields with key fields CADocumentNumber, CAGLItemNumber.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CADocumentGLItem | I_CADocumentGLItem | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.representativeKey | CADocumentNumber | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Document General Ledger Item - TP | view |
Fields (102)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 | |||
| ChartOfAccounts | ChartOfAccounts | |||
| Country | Country | |||
| TaxCalculationProcedure | TaxCalculationProcedure | |||
| _DocHeader | _DocHeader | |||
| _AcctAssgmtCat | _AcctAssgmtCat | |||
| _BusinessArea | _BusinessArea | |||
| _CAAcctAssgmtDistrCode | _CAAcctAssgmtDistrCode | |||
| _CAAcctDetnTransKey | _CAAcctDetnTransKey | |||
| _CAAltvExchangeRateSetCode | _CAAltvExchangeRateSetCode | |||
| _CAEuroConversionStatus | _CAEuroConversionStatus | |||
| _CAIntPostingReasonCode | _CAIntPostingReasonCode | |||
| _CANegativePostingCtrlCode | _CANegativePostingCtrlCode | |||
| _CANonDcblInputTaxCode | _CANonDcblInputTaxCode | |||
| _CashFlowAccount | _CashFlowAccount | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _CompCode | _CompCode | |||
| _CompCodeCashFlow | _CompCodeCashFlow | |||
| _Country | _Country | |||
| _GLAccount | _GLAccount | |||
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | |||
| _GLPostingCurrency | _GLPostingCurrency | |||
| _OtherTaxCode | _OtherTaxCode | |||
| _ProfitCenter | _ProfitCenter | |||
| _PartnerCompany | _PartnerCompany | |||
| _Segment | _Segment | |||
| _WhldgTaxSuplmnt | _WhldgTaxSuplmnt |
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.representativeKey: 'CADocumentNumber'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Document General Ledger Item - TP'
define view entity R_CADocumentGLItemTP
as select from I_CADocumentGLItem
association to parent R_CADocumentTP as _DocHeader on _DocHeader.CADocumentNumber = $projection.CADocumentNumber
{
//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,
/* Associations */
//own associations
_DocHeader,
//associations from I_CADocumentGLItem
_AcctAssgmtCat,
_BusinessArea,
_CAAcctAssgmtDistrCode,
_CAAcctDetnTransKey,
_CAAltvExchangeRateSetCode,
_CAEuroConversionStatus,
_CAIntPostingReasonCode,
_CANegativePostingCtrlCode,
_CANonDcblInputTaxCode,
_CashFlowAccount,
_ChartOfAccounts,
_CompCode,
_CompCodeCashFlow,
_Country,
_GLAccount,
_GLAccountInCompanyCode,
_GLPostingCurrency,
_OtherTaxCode,
_ProfitCenter,
_PartnerCompany,
_Segment,
_WhldgTaxSuplmnt
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- 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