FAC_DART_Z3_AR_LINEITEM_BASE

DDL: FAC_DART_Z3_AR_LINEITEM_BASE SQL: FAC_DZARLNITMB Type: view

Account Receivable - Line Items Base

FAC_DART_Z3_AR_LINEITEM_BASE is a CDS View that provides data about "Account Receivable - Line Items Base" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 346 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_GLAccountText _GLAcctInChartOfAccountsText $projection.ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts and $projection.GLAccount = _GLAcctInChartOfAccountsText.GLAccount
[0..1] I_CustomerCompany _CustomerCompany _CustomerCompany.CompanyCode = $projection.CompanyCode and _CustomerCompany.Customer = $projection.Customer
[0..*] I_GLAccountText _ReconciliationAccountText $projection.reconciliationaccount = _ReconciliationAccountText.GLAccount and $projection.ChartOfAccounts = _ReconciliationAccountText.ChartOfAccounts

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZARLNITMB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Account Receivable - Line Items Base view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (346)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
SystemClient System Client
GLAccount GLAccount
Customer Customer
PostingDate PostingDate
FiscalPeriod FiscalPeriod
ReconciliationAccount _CustomerCompany ReconciliationAccount Reconciliation Account
ClearingAccountingDocument ClearingAccountingDocument
CompanyCodeCurrency CompanyCodeCurrency
ChartOfAccounts ChartOfAccounts
AccountingDocumentType AccountingDocumentType
OriginalReferenceDocument OriginalReferenceDocument
DocumentItemText DocumentItemText
DownPaymentIsNetProcedure DownPaymentIsNetProcedure
AddressAndBankIsSetManually AddressAndBankIsSetManually
PaytSlipWthRefSubscriber PaytSlipWthRefSubscriber
PaytSlipWthRefReference PaytSlipWthRefReference
PaytSlipWthRefCheckDigit PaytSlipWthRefCheckDigit
OperationalGLAccount OperationalGLAccount
DebitCreditCode DebitCreditCode
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
ClearingDate ClearingDate
AccountingDocumentCategory AccountingDocumentCategory
_CustomerText _CustomerText
_GLAcctInChartOfAccountsText _GLAcctInChartOfAccountsText
TransactionCurrency TransactionCurrency
_AccountingDocumentCategoryT _AccountingDocumentCategoryT
_AccountingDocumentCategory _AccountingDocumentCategory
_AccountingDocumentType _AccountingDocumentType
_ChartOfAccounts _ChartOfAccounts
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_Customer _Customer
_DebitCreditCode _DebitCreditCode
_FiscalPeriod _FiscalPeriod
_FiscalYear _FiscalYear
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_JournalEntry _JournalEntry
_TransactionCurrency _TransactionCurrency
AccountingDocumentItemType AccountingDocumentItemType
ClearingCreationDate ClearingCreationDate
AccountingDocumentCreationDate _JournalEntry AccountingDocumentCreationDate
DocumentReferenceID _JournalEntry DocumentReferenceID
NetAmountIsPosted _JournalEntry NetAmountIsPosted
PostingKey PostingKey
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
SpecialGLTransactionType SpecialGLTransactionType
BusinessArea BusinessArea
PartnerBusinessArea PartnerBusinessArea
TaxCode TaxCode
TaxCountry TaxCountry
WithholdingTaxCode WithholdingTaxCode
TaxType TaxType
TaxItemGroup TaxItemGroup
TransactionTypeDetermination TransactionTypeDetermination
ValueDate ValueDate
AssignmentReference AssignmentReference
PartnerCompany PartnerCompany
FinancialTransactionType FinancialTransactionType
CorporateGroupAccount CorporateGroupAccount
PlanningLevel PlanningLevel
ControllingArea ControllingArea
CostCenter CostCenter
Project Project
OrderID OrderID
BillingDocument BillingDocument
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
ScheduleLine ScheduleLine
ServiceDocumentType ServiceDocumentType
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
AssetTransactionType AssetTransactionType
AssetValueDate AssetValueDate
AssetClass AssetClass
PersonnelNumber PersonnelNumber
IsSalesRelated IsSalesRelated
LineItemDisplayIsEnabled LineItemDisplayIsEnabled
IsOpenItemManaged IsOpenItemManaged
IsNotCashDiscountLiable IsNotCashDiscountLiable
IsAutomaticallyCreated IsAutomaticallyCreated
IsUsedInPaymentTransaction IsUsedInPaymentTransaction
Supplier Supplier
BranchAccount BranchAccount
IsBalanceSheetAccount IsBalanceSheetAccount
ProfitLossAccountType ProfitLossAccountType
SpecialGLAccountAssignment SpecialGLAccountAssignment
DueCalculationBaseDate DueCalculationBaseDate
PaymentTerms PaymentTerms
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
NetPaymentDays NetPaymentDays
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
PaymentMethod PaymentMethod
PaymentBlockingReason PaymentBlockingReason
FixedCashDiscount FixedCashDiscount
HouseBank HouseBank
BPBankAccountInternalID BPBankAccountInternalID
TaxDistributionCode1 TaxDistributionCode1
TaxDistributionCode2 TaxDistributionCode2
TaxDistributionCode3 TaxDistributionCode3
TaxBrkdwnAmount2InCoCodeCrcy TaxBrkdwnAmount2InCoCodeCrcy
TaxBrkdwnAmount1InCoCodeCrcy TaxBrkdwnAmount1InCoCodeCrcy
TaxBrkdwnAmount3InCoCodeCrcy TaxBrkdwnAmount3InCoCodeCrcy
TaxBrkdwnAmount3InTransCrcy TaxBrkdwnAmount3InTransCrcy
TaxBrkdwnAmount1InTransCrcy TaxBrkdwnAmount1InTransCrcy
TaxBrkdwnAmount2InTransCrcy TaxBrkdwnAmount2InTransCrcy
InvoiceReference InvoiceReference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear
InvoiceItemReference InvoiceItemReference
FollowOnDocumentType FollowOnDocumentType
StateCentralBankPaymentReason StateCentralBankPaymentReason
SupplyingCountry SupplyingCountry
InvoiceList InvoiceList
BillOfExchangeUsage BillOfExchangeUsage
DunningKey DunningKey
DunningBlockingReason DunningBlockingReason
LastDunningDate LastDunningDate
DunningLevel DunningLevel
DunningArea DunningArea
WithholdingTaxCertificate WithholdingTaxCertificate
Material Material
Product Product
Plant Plant
PurchasingDocument PurchasingDocument
PurchasingDocumentItem PurchasingDocumentItem
AccountAssignmentNumber AccountAssignmentNumber
IsCompletelyDelivered IsCompletelyDelivered
MaterialPriceControl MaterialPriceControl
ValuationArea ValuationArea
InventoryValuationType InventoryValuationType
VATRegistration VATRegistration
DelivOfGoodsDestCountry DelivOfGoodsDestCountry
PaymentDifferenceReason PaymentDifferenceReason
ProfitCenter ProfitCenter
JointVenture JointVenture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode
JointVentureEquityGroup JointVentureEquityGroup
TreasuryContractType TreasuryContractType
AssetContract AssetContract
CashFlowType CashFlowType
TaxJurisdiction TaxJurisdiction
RealEstateObject RealEstateObject
SettlementReferenceDate SettlementReferenceDate
CommitmentItem CommitmentItem
CostObject CostObject
ProjectNetwork ProjectNetwork
OrderInternalBillOfOperations OrderInternalBillOfOperations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
WBSElementInternalID WBSElementInternalID
ProfitabilitySegment ProfitabilitySegment_2
JointVentureEquityType JointVentureEquityType
IsEUTriangularDeal IsEUTriangularDeal
CostOriginGroup CostOriginGroup
CompanyCodeCurrencyDetnMethod CompanyCodeCurrencyDetnMethod
ClearingIsReversed ClearingIsReversed
PaymentMethodSupplement PaymentMethodSupplement
AlternativeGLAccount AlternativeGLAccount
FundsCenter FundsCenter
Fund Fund
PartnerProfitCenter PartnerProfitCenter
Reference1IDByBusinessPartner Reference1IDByBusinessPartner
Reference2IDByBusinessPartner Reference2IDByBusinessPartner
IsNegativePosting IsNegativePosting
PaymentCardItem PaymentCardItem
PaymentCardPaymentSettlement PaymentCardPaymentSettlement
CreditControlArea CreditControlArea
AlternativePayeePayer AlternativePayeePayer
Reference3IDByBusinessPartner Reference3IDByBusinessPartner
DataExchangeInstruction1 DataExchangeInstruction1
DataExchangeInstruction2 DataExchangeInstruction2
DataExchangeInstruction3 DataExchangeInstruction3
DataExchangeInstruction4 DataExchangeInstruction4
Region Region
HasPaymentOrder HasPaymentOrder
PaymentReference PaymentReference
TaxDeterminationDate TaxDeterminationDate
ClearingItem ClearingItem
BusinessPlace BusinessPlace
TaxSection TaxSection
CostCtrActivityType CostCtrActivityType
AccountsReceivableIsPledged AccountsReceivableIsPledged
BusinessProcess BusinessProcess
GrantID GrantID
FunctionalArea FunctionalArea
CustomerIsInExecution CustomerIsInExecution
FundedProgram FundedProgram
ClearingDocFiscalYear ClearingDocFiscalYear
LedgerGLLineItem LedgerGLLineItem
Segment Segment
PartnerSegment PartnerSegment
PartnerFunctionalArea PartnerFunctionalArea
HouseBankAccount HouseBankAccount
CostElement CostElement
PaymentServiceProvider PaymentServiceProvider
PaymentRefByPaytSrvcProvider PaymentRefByPaytSrvcProvider
SEPAMandate SEPAMandate
ReferenceDocumentType ReferenceDocumentType
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem
AccountingDocumentItemRef AccountingDocumentItemRef
DocumentDate DocumentDate
NetDueDate NetDueDate
CashDiscount1DueDate CashDiscount1DueDate
CashDiscount2DueDate CashDiscount2DueDate
OffsettingAccount OffsettingAccount
OffsettingAccountType OffsettingAccountType
OffsettingChartOfAccounts OffsettingChartOfAccounts
PartnerFund PartnerFund
PartnerGrant PartnerGrant
BudgetPeriod BudgetPeriod
PartnerBudgetPeriod PartnerBudgetPeriod
BranchCode BranchCode
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy
ValuationDiffAmtInCoCodeCrcy ValuationDiffAmtInCoCodeCrcy
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy
OriginalTaxBaseAmount OriginalTaxBaseAmount
TaxAmount TaxAmount
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy
WithholdingTaxBaseAmount WithholdingTaxBaseAmount
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy
CashDiscountBaseAmount CashDiscountBaseAmount
CashDiscountAmount CashDiscountAmount
NetPaymentAmount NetPaymentAmount
WithholdingTaxAmount WithholdingTaxAmount
WithholdingTaxExemptionAmt WithholdingTaxExemptionAmt
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency
BalanceTransactionCurrency BalanceTransactionCurrency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy
AdditionalCurrency1 AdditionalCurrency1
ValuationDiffAmtInAddlCrcy1 ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2
ValuationDiffAmtInAddlCrcy2 ValuationDiffAmtInAddlCrcy2
PaymentCurrency PaymentCurrency
AmountInPaymentCurrency AmountInPaymentCurrency
CreditControlAreaCurrency CreditControlAreaCurrency
HedgedAmount HedgedAmount
BaseUnit BaseUnit
Quantity Quantity
GoodsMovementEntryUnit GoodsMovementEntryUnit
QuantityInEntryUnit QuantityInEntryUnit
PurchasingDocumentPriceUnit PurchasingDocumentPriceUnit
PurchaseOrderQty PurchaseOrderQty
MaterialPriceUnitQty MaterialPriceUnitQty
NumberOfItems NumberOfItems
_AccountingDocumentTypeText _AccountingDocumentTypeText
_AdditionalCurrency1 _AdditionalCurrency1
_AdditionalCurrency2 _AdditionalCurrency2
_AssetTransactionType _AssetTransactionType
_BalanceTransactionCurrency _BalanceTransactionCurrency
_BaseUnit _BaseUnit
_BudgetPeriod _BudgetPeriod
_BudgetPeriodText _BudgetPeriodText
_BusinessArea _BusinessArea
_BusinessAreaText _BusinessAreaText
_BusinessProcess _BusinessProcess
_BusinessProcessText _BusinessProcessText
_ChartOfAccountsText _ChartOfAccountsText
_ControllingArea _ControllingArea
_ControllingAreaText _ControllingAreaText
_CostCenter _CostCenter
_CostCenterText _CostCenterText
_CostCtrActivityType _CostCtrActivityType
_CostOriginGroup _CostOriginGroup
_CreditControlAreaCurrency _CreditControlAreaCurrency
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Employment _Employment
_FinancialAccountType _FinancialAccountType
_FinancialAccountTypeText _FinancialAccountTypeText
_FinancialTransactionType _FinancialTransactionType
_FixedAsset _FixedAsset
_FixedAssetText _FixedAssetText
_FunctionalArea _FunctionalArea
_FunctionalAreaText _FunctionalAreaText
_GLAccountInCompanyCode _GLAccountInCompanyCode
_GoodsMovementEntryUnit _GoodsMovementEntryUnit
_HouseBank _HouseBank
_HouseBankAccount _HouseBankAccount
_HouseBankAccountText _HouseBankAccountText
_InternalOrder _InternalOrder
_InventoryValuationType _InventoryValuationType
_MasterFixedAsset _MasterFixedAsset
_MasterFixedAssetText _MasterFixedAssetText
_Material _Material
_MaterialText _MaterialText
_OffsettingAccount _OffsettingAccount
_OffsettingAccountType _OffsettingAccountType
_OffsettingAccountTypeText _OffsettingAccountTypeText
_OffsettingAccountWithBP _OffsettingAccountWithBP
_OffsettingChartOfAccounts _OffsettingChartOfAccounts
_OffsettingChartOfAccountsText _OffsettingChartOfAccountsText
_Order _Order
_PartnerBusinessArea _PartnerBusinessArea
_PartnerBusinessAreaText _PartnerBusinessAreaText
_PartnerCompany _PartnerCompany
_PartnerCompanyText _PartnerCompanyText
_PartnerFunctionalArea _PartnerFunctionalArea
_PartnerProfitCenter _PartnerProfitCenter
_PartnerSegment _PartnerSegment
_PartnerSegmentText _PartnerSegmentText
_PaymentCurrency _PaymentCurrency
_PaymentDifferenceReason _PaymentDifferenceReason
_Plant _Plant
_PostingKey _PostingKey
_Product _Product
_ProductText _ProductText
_ProfitCenter _ProfitCenter
_ProfitCenterText _ProfitCenterText
_ProjectNetwork _ProjectNetwork
_ProjectNetworkText _ProjectNetworkText
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_PurchasingDocumentPriceUnit _PurchasingDocumentPriceUnit
_ReferenceDocumentType _ReferenceDocumentType
_SalesDoc _SalesDoc
_SalesDocItem _SalesDocItem
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_Segment _Segment
_SegmentText _SegmentText
_SpecialGLCode _SpecialGLCode
_Supplier _Supplier
_SupplierBankDetails _SupplierBankDetails
_SupplierText _SupplierText
_SupplyingCountry _SupplyingCountry
_TaxCode _TaxCode
_TaxType _TaxType
_ValuationArea _ValuationArea
_WBSElementInternalID _WBSElementInternalID
_WBSElementInternalIDText _WBSElementInternalIDText
_ServiceDocumentType _ServiceDocumentType
_ServiceDocument _ServiceDocument
_ServiceDocumentItem _ServiceDocumentItem
_ReconciliationAccountText _ReconciliationAccountText
@AbapCatalog.sqlViewName: 'FAC_DZARLNITMB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Account Receivable - Line Items Base'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view FAC_DART_Z3_AR_LINEITEM_BASE
  as select from I_OperationalAcctgDocItem
  association [0..*] to I_GLAccountText   as _GLAcctInChartOfAccountsText on  $projection.ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts
                                                                          and $projection.GLAccount       = _GLAcctInChartOfAccountsText.GLAccount
  association [0..1] to I_CustomerCompany as _CustomerCompany             on  _CustomerCompany.CompanyCode = $projection.CompanyCode
                                                                          and _CustomerCompany.Customer    = $projection.Customer
  association [0..*] to I_GLAccountText   as _ReconciliationAccountText   on  $projection.reconciliationaccount = _ReconciliationAccountText.GLAccount
                                                                          and $projection.ChartOfAccounts       = _ReconciliationAccountText.ChartOfAccounts
{

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key AccountingDocument,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key FiscalYear,
  key AccountingDocumentItem,

      @EndUserText.label: 'System Client'
      $session.client as SystemClient,

      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      GLAccount,
      //      _GLAcctInChartOfAccountsText[1: Language = $session.system_language].GLAccountName,


      @ObjectModel.foreignKey.association: '_Customer'
      Customer,
      //      _CustomerText.CustomerName,


      PostingDate,
      @ObjectModel.foreignKey.association: '_FiscalPeriod'
      FiscalPeriod,

      //      _AccountingDocumentTypeText[1: Language = $session.system_language].AccountingDocumentTypeName,



      //Reconcilation Account

      @EndUserText.label: 'Reconciliation Account'
      _CustomerCompany.ReconciliationAccount,

      ClearingAccountingDocument,

      @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
      @Semantics.currencyCode:true
      CompanyCodeCurrency,


      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      ChartOfAccounts,

      @ObjectModel.foreignKey.association: '_AccountingDocumentType'
      AccountingDocumentType,
      OriginalReferenceDocument,

      //      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

      //      case DebitCreditCode

      //       when 'S'

      //         then AmountInCompanyCodeCurrency

      //         else (-1) * AmountInCompanyCodeCurrency

      //       end                                    as  BalanceAmountInCoCodeCrcy,


      DocumentItemText,
      DownPaymentIsNetProcedure,
      AddressAndBankIsSetManually,
      PaytSlipWthRefSubscriber,
      PaytSlipWthRefReference,
      PaytSlipWthRefCheckDigit,
      OperationalGLAccount,

      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      DebitCreditCode,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      AmountInCompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      AmountInTransactionCurrency,

      ClearingDate,

      @ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
      AccountingDocumentCategory,

      _CustomerText,
      _GLAcctInChartOfAccountsText,


      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      @Semantics.currencyCode:true
      TransactionCurrency,

      _AccountingDocumentCategoryT,
      _AccountingDocumentCategory,
      _AccountingDocumentType,
      _ChartOfAccounts,
      _CompanyCode,
      _CompanyCodeCurrency,
      _Customer,
      _DebitCreditCode,
      _FiscalPeriod,
      _FiscalYear,
      _GLAccountInChartOfAccounts,
      _JournalEntry,
      _TransactionCurrency,


      AccountingDocumentItemType,
      ClearingCreationDate,

      _JournalEntry.AccountingDocumentCreationDate,
      _JournalEntry.DocumentReferenceID,
      _JournalEntry.NetAmountIsPosted,

      @ObjectModel.foreignKey.association: '_PostingKey'
      PostingKey,
      @ObjectModel.foreignKey.association: '_FinancialAccountType'
      FinancialAccountType,
      @ObjectModel.foreignKey.association: '_SpecialGLCode'
      SpecialGLCode,
      SpecialGLTransactionType,
      //zumsk,

      @ObjectModel.foreignKey.association: '_BusinessArea'
      BusinessArea,
      @ObjectModel.foreignKey.association: '_PartnerBusinessArea'
      PartnerBusinessArea,
      //      @ObjectModel.foreignKey.association: '_TaxCode'

      TaxCode,
      TaxCountry,
      WithholdingTaxCode,
      //shzuz,

      //stekz,

      @ObjectModel.foreignKey.association: '_TaxType'
      TaxType,
      TaxItemGroup,
      TransactionTypeDetermination,
      ValueDate,
      AssignmentReference,
      //zinkz,

      @ObjectModel.foreignKey.association: '_PartnerCompany'
      PartnerCompany,
      @ObjectModel.foreignKey.association: '_FinancialTransactionType'
      FinancialTransactionType,
      CorporateGroupAccount,
      PlanningLevel,
      //fdgrp,

      //fdtag,

      //fkont,

      @ObjectModel.foreignKey.association: '_ControllingArea'
      ControllingArea,
      @ObjectModel.foreignKey.association: '_CostCenter'
      CostCenter,
      Project, // DO NOT USE ; this is the old unused Project

      @ObjectModel.foreignKey.association: '_Order'
      OrderID,
      BillingDocument,
      @ObjectModel.foreignKey.association: '_SalesDoc'
      SalesDocument,
      @ObjectModel.foreignKey.association: '_SalesDocItem'
      SalesDocumentItem,
      ScheduleLine,

      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentTypeVH',
                           element: 'ServiceDocumentType' }
              }]
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
      ServiceDocumentType,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentVH',
                           element: 'ServiceDocument' }
              }]
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_ServiceDocument'
      ServiceDocument,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentItemVH',
                           element: 'ServiceDocumentItem' }
              }]
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_ServiceDocumentItem'
      ServiceDocumentItem,

      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentTypeVH',
                           element: 'PartnerServiceDocumentType' }
              }]

      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
      FixedAsset,
      @ObjectModel.foreignKey.association: '_AssetTransactionType'
      AssetTransactionType,
      AssetValueDate,
      AssetClass,
      @ObjectModel.foreignKey.association: '_Employment'
      PersonnelNumber,
      IsSalesRelated,
      //xhres,

      LineItemDisplayIsEnabled,
      IsOpenItemManaged,
      IsNotCashDiscountLiable,
      IsAutomaticallyCreated,
      IsUsedInPaymentTransaction,
      @ObjectModel.foreignKey.association: '_Supplier'
      Supplier,
      BranchAccount,
      IsBalanceSheetAccount,
      ProfitLossAccountType,
      SpecialGLAccountAssignment,
      DueCalculationBaseDate,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      PaymentMethod,
      PaymentBlockingReason,
      FixedCashDiscount,
      @ObjectModel.foreignKey.association: '_HouseBank'
      HouseBank,
      @ObjectModel.foreignKey.association: '_SupplierBankDetails'
      BPBankAccountInternalID,
      TaxDistributionCode1,
      TaxDistributionCode2,
      TaxDistributionCode3,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } 
      TaxBrkdwnAmount2InCoCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } 
      TaxBrkdwnAmount1InCoCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } 
      TaxBrkdwnAmount3InCoCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} } 
      TaxBrkdwnAmount3InTransCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} } 
      TaxBrkdwnAmount1InTransCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} } 
      TaxBrkdwnAmount2InTransCrcy,
      InvoiceReference,
      InvoiceReferenceFiscalYear,
      InvoiceItemReference,
      FollowOnDocumentType,
      StateCentralBankPaymentReason,
      @ObjectModel.foreignKey.association: '_SupplyingCountry'
      SupplyingCountry,
      InvoiceList,
      BillOfExchangeUsage,
      DunningKey,
      DunningBlockingReason,
      LastDunningDate,
      DunningLevel,
      DunningArea,

      WithholdingTaxCertificate,
      @ObjectModel.foreignKey.association: '_Material'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'Product'
      Material, // do not use any longer, use Product

      @ObjectModel.foreignKey.association: '_Product'
      Product,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_PurchasingDocument'
      PurchasingDocument,
      @ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
      PurchasingDocumentItem,
      AccountAssignmentNumber,
      IsCompletelyDelivered,
      MaterialPriceControl,
      @ObjectModel.foreignKey.association: '_ValuationArea'
      ValuationArea,
      @ObjectModel.foreignKey.association: '_InventoryValuationType'
      InventoryValuationType,

      VATRegistration,
      DelivOfGoodsDestCountry,
      //eglld,

      @ObjectModel.foreignKey.association: '_PaymentDifferenceReason'
      PaymentDifferenceReason,
      //ryacq,

      //rpacq,

      @ObjectModel.foreignKey.association: '_ProfitCenter'
      ProfitCenter,
      //xhkom,

      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityGroup,
      //vptnr,

      TreasuryContractType,
      AssetContract,
      CashFlowType,
      //depot,

      TaxJurisdiction,
      RealEstateObject,
      SettlementReferenceDate,
      //popts,

      CommitmentItem,
      CostObject,
      @ObjectModel.foreignKey.association: '_ProjectNetwork'
      ProjectNetwork,
      OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
      @ObjectModel.foreignKey.association: '_WBSElementInternalID'
      WBSElementInternalID,
      ProfitabilitySegment_2 as ProfitabilitySegment,

      JointVentureEquityType,
      IsEUTriangularDeal,

      CostOriginGroup,
      CompanyCodeCurrencyDetnMethod,
      //glupm,

      ClearingIsReversed,

      PaymentMethodSupplement,

      AlternativeGLAccount,
      FundsCenter,
      Fund,
      //stbuk,

      @ObjectModel.foreignKey.association: '_PartnerProfitCenter'
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,
      //      EarmarkedFundsDocument,

      //      EarmarkedFundsDocumentItem,


      IsNegativePosting,
      PaymentCardItem,
      PaymentCardPaymentSettlement,
      CreditControlArea,
      AlternativePayeePayer,
      //empfb,

      Reference3IDByBusinessPartner,
      DataExchangeInstruction1,
      DataExchangeInstruction2,
      DataExchangeInstruction3,
      DataExchangeInstruction4,

      Region,
      HasPaymentOrder,
      PaymentReference,

      TaxDeterminationDate,
      ClearingItem,

      BusinessPlace,
      TaxSection,
      @ObjectModel.foreignKey.association: '_CostCtrActivityType'
      CostCtrActivityType,
      AccountsReceivableIsPledged,
      @ObjectModel.foreignKey.association: '_BusinessProcess'
      BusinessProcess,
      //pendays,

      //penrc,

      GrantID,
      @ObjectModel.foreignKey.association: '_FunctionalArea'
      FunctionalArea,
      CustomerIsInExecution,
      //srtype,

      //intreno,

      FundedProgram,
      ClearingDocFiscalYear,

      //ppa_ex_ind,

      LedgerGLLineItem,
      @ObjectModel.foreignKey.association: '_Segment'
      Segment,
      @ObjectModel.foreignKey.association: '_PartnerSegment'
      PartnerSegment,
      @ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
      PartnerFunctionalArea,
      @ObjectModel.foreignKey.association: '_HouseBankAccount'
      HouseBankAccount,
      CostElement,
      //xlgclr,

      //taxps as TaxDocumentItemNumber,

      PaymentServiceProvider,
      PaymentRefByPaytSrvcProvider,
      SEPAMandate,
      //xfrge_bseg,

      @ObjectModel.foreignKey.association: '_ReferenceDocumentType'
      ReferenceDocumentType,
      ReferenceDocumentLogicalSystem,
      AccountingDocumentItemRef,
      //buzei_sender,


      DocumentDate,
      NetDueDate,
      CashDiscount1DueDate,
      CashDiscount2DueDate,
      //fqftype,

      //lqitem,

      @ObjectModel.foreignKey.association: '_OffsettingAccountWithBP'
      OffsettingAccount,
      @ObjectModel.foreignKey.association: '_OffsettingAccountType'
      OffsettingAccountType,
      @ObjectModel.foreignKey.association: '_OffsettingChartOfAccounts'
      OffsettingChartOfAccounts,
      //ghkon,

      PartnerFund,
      PartnerGrant,
      @ObjectModel.foreignKey.association: '_BudgetPeriod'
      BudgetPeriod,
      PartnerBudgetPeriod,
      BranchCode,
      //perop_beg,

      //perop_end,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      TaxAmountInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      TaxBaseAmountInCoCodeCrcy,

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } hwzuz_shl,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      ValuationDiffAmtInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      CashDiscountAmtInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      InvoiceAmtInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      OriginalTaxBaseAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      TaxAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      TaxBaseAmountInTransCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxBaseAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      PlannedAmtInTransactionCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      CashDiscountBaseAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      CashDiscountAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      NetPaymentAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxExemptionAmt,

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } navfw_shl,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      InvoiceAmountInFrgnCurrency,

      @ObjectModel.foreignKey.association: '_BalanceTransactionCurrency'
      @Semantics.currencyCode:true
      BalanceTransactionCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      AmountInBalanceTransacCrcy,


      @ObjectModel.foreignKey.association: '_AdditionalCurrency1'
      @Semantics.currencyCode:true
      AdditionalCurrency1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      ValuationDiffAmtInAddlCrcy1,

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } rdif2_shl,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      AmountInAdditionalCurrency1,

      @ObjectModel.foreignKey.association: '_AdditionalCurrency2'
      @Semantics.currencyCode:true
      AdditionalCurrency2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      AmountInAdditionalCurrency2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      ValuationDiffAmtInAddlCrcy2,

      @ObjectModel.foreignKey.association: '_PaymentCurrency'
      @Semantics.currencyCode:true
      PaymentCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'PaymentCurrency'} }
      AmountInPaymentCurrency,

      @ObjectModel.foreignKey.association: '_CreditControlAreaCurrency'
      @Semantics.currencyCode:true
      CreditControlAreaCurrency,
      //@Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} } klibt_shl,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} }
      HedgedAmount,

      @ObjectModel.foreignKey.association: '_BaseUnit'
      @Semantics.unitOfMeasure:true
      BaseUnit,

      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Quantity,

      @ObjectModel.foreignKey.association: '_GoodsMovementEntryUnit'
      @Semantics.unitOfMeasure:true
      GoodsMovementEntryUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} }
      QuantityInEntryUnit,

      @ObjectModel.foreignKey.association: '_PurchasingDocumentPriceUnit'
      @Semantics.unitOfMeasure:true
      PurchasingDocumentPriceUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} }
      PurchaseOrderQty,

      MaterialPriceUnitQty,

      @DefaultAggregation: #SUM
      NumberOfItems,

      _AccountingDocumentTypeText,
      _AdditionalCurrency1,
      _AdditionalCurrency2,
      _AssetTransactionType,
      _BalanceTransactionCurrency,
      _BaseUnit,
      _BudgetPeriod,
      _BudgetPeriodText,
      _BusinessArea,
      _BusinessAreaText,
      _BusinessProcess,
      _BusinessProcessText,
      _ChartOfAccountsText,
      _ControllingArea,
      _ControllingAreaText,
      _CostCenter,
      _CostCenterText,
      _CostCtrActivityType,
      _CostOriginGroup,
      _CreditControlAreaCurrency,
      _CurrentCostCenter,
      _CurrentProfitCenter,
      _Employment,
      _FinancialAccountType,
      _FinancialAccountTypeText,
      _FinancialTransactionType,
      _FixedAsset,
      _FixedAssetText,
      _FunctionalArea,
      _FunctionalAreaText,
      _GLAccountInCompanyCode,
      _GoodsMovementEntryUnit,
      _HouseBank,
      _HouseBankAccount,
      _HouseBankAccountText,
      _InternalOrder,
      _InventoryValuationType,
      _MasterFixedAsset,
      _MasterFixedAssetText,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: '_Product'
      _Material,
      _MaterialText,
      _OffsettingAccount,
      _OffsettingAccountType,
      _OffsettingAccountTypeText,
      _OffsettingAccountWithBP,
      _OffsettingChartOfAccounts,
      _OffsettingChartOfAccountsText,
      _Order,
      _PartnerBusinessArea,
      _PartnerBusinessAreaText,
      _PartnerCompany,
      _PartnerCompanyText,
      _PartnerFunctionalArea,
      _PartnerProfitCenter,
      _PartnerSegment,
      _PartnerSegmentText,
      _PaymentCurrency,
      _PaymentDifferenceReason,
      _Plant,
      _PostingKey,
      _Product,
      _ProductText,
      _ProfitCenter,
      _ProfitCenterText,
      _ProjectNetwork,
      _ProjectNetworkText,
      _PurchasingDocument,
      _PurchasingDocumentItem,
      _PurchasingDocumentPriceUnit,
      _ReferenceDocumentType,
      _SalesDoc,
      _SalesDocItem,
      _SalesDocument,
      _SalesDocumentItem,
      _Segment,
      _SegmentText,
      _SpecialGLCode,
      _Supplier,
      _SupplierBankDetails,
      _SupplierText,
      _SupplyingCountry,
      _TaxCode,
      _TaxType,
      _ValuationArea,
      _WBSElementInternalID,
      _WBSElementInternalIDText,
      _ServiceDocumentType,
      _ServiceDocument,
      _ServiceDocumentItem,
      _ReconciliationAccountText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERCOMPANY",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTCATEGORY",
"I_ACCOUNTINGDOCUMENTCATEGORYT",
"I_ACCOUNTINGDOCUMENTTYPE",
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_ASSETTRANSACTIONTYPE",
"I_BUDGETPERIOD",
"I_BUDGETPERIODTEXT",
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_BUSINESSPROCESS",
"I_BUSINESSPROCESSTEXT",
"I_CHARTOFACCOUNTS",
"I_CHARTOFACCOUNTSTEXT",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE",
"I_COSTCENTERTEXT",
"I_COSTORIGINGROUP",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_DEBITCREDITCODE",
"I_EMPLOYMENT",
"I_FINANCIALACCOUNTTYPE",
"I_FINANCIALACCOUNTTYPETEXT",
"I_FINANCIALTRANSACTIONTYPE",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARPERIODFORCMPNYCODE",
"I_FIXEDASSET",
"I_FUNCTIONALAREA",
"I_FUNCTIONALAREATEXT",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTINCOMPANYCODE",
"I_GLACCOUNTTEXT",
"I_HOUSEBANK",
"I_HOUSEBANKACCOUNT",
"I_HOUSEBANKACCOUNTTEXT",
"I_INTERNALORDER",
"I_INVENTORYVALUATIONTYPE",
"I_JOURNALENTRY",
"I_MASTERFIXEDASSET",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_OFFSETTINGACCOUNT",
"I_ORDER",
"I_PAYMENTDIFFERENCEREASON",
"I_PLANT",
"I_POSTINGKEY",
"I_PRODUCT",
"I_PRODUCTDESCRIPTION",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"I_PROJECTNETWORK",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM",
"I_PURREQVALUATIONAREA",
"I_REFERENCEDOCUMENTTYPE",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESORDER",
"I_SALESORDERITEM",
"I_SEGMENT",
"I_SEGMENTTEXT",
"I_SERVICEDOCUMENTTYPE",
"I_SPECIALGLCODE",
"I_SRVCDOCBYDOCUMENTTYPE",
"I_SRVCDOCITEMBYDOCUMENTTYPE",
"I_SUPLRBANKDETAILSBYINTID",
"I_SUPPLIER",
"I_TAXCODE",
"I_TAXTYPE",
"I_UNITOFMEASURE",
"I_WBSELEMENTBYINTERNALKEY"
],
"BASE":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/