P_CN_JOURNALENTRYITEM

DDL: P_CN_JOURNALENTRYITEM SQL: PCNJRNLENTRITM Type: view CONSUMPTION

P_CN_JOURNALENTRYITEM is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_AddlLedgerOplAcctgDocItem, P_CN_JOURNALENTRYHSBK, I_OperationalAcctgDocItem) and exposes 294 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, AccountingDocument.

Data Sources (3)

SourceAliasJoin Type
I_AddlLedgerOplAcctgDocItem bseg from
P_CN_JOURNALENTRYHSBK hsbk inner
I_OperationalAcctgDocItem I_OperationalAcctgDocItem union_all

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCNJRNLENTRITM view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (294)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_AddlLedgerOplAcctgDocItem CompanyCode
KEY AccountingDocument I_AddlLedgerOplAcctgDocItem AccountingDocument
KEY FiscalYear I_AddlLedgerOplAcctgDocItem FiscalYear
KEY AccountingDocumentItem I_AddlLedgerOplAcctgDocItem AccountingDocumentItem
ChartOfAccounts ChartOfAccounts
ClearingDate ClearingDate
ClearingCreationDate ClearingCreationDate
ClearingAccountingDocument ClearingAccountingDocument
PostingKey PostingKey
FinancialAccountType FinancialAccountType
SpecialGLCode
SpecialGLTransactionType
BusinessArea BusinessArea
PartnerBusinessArea PartnerBusinessArea
TaxCode TaxCode
WithholdingTaxCode WithholdingTaxCode
TaxType
TransactionTypeDetermination TransactionTypeDetermination
ValueDate ValueDate
AssignmentReference AssignmentReference
DocumentItemText DocumentItemText
PartnerCompany PartnerCompany
FinancialTransactionType FinancialTransactionType
CorporateGroupAccount CorporateGroupAccount
PlanningLevel
ControllingArea ControllingArea
CostCenter CostCenter
Project Project
OrderID OrderID
BillingDocument
SalesDocument
SalesDocumentItem
ScheduleLine
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
AssetTransactionType AssetTransactionType
AssetValueDate
PersonnelNumber
IsSalesRelated
LineItemDisplayIsEnabled
IsOpenItemManaged IsOpenItemManaged
IsNotCashDiscountLiable
IsAutomaticallyCreated IsAutomaticallyCreated
IsUsedInPaymentTransaction
asOperationalGLAccount
GLAccount GLAccount
Customer
Supplier
BranchAccount
IsBalanceSheetAccount IsBalanceSheetAccount
ProfitLossAccountType ProfitLossAccountType
SpecialGLAccountAssignment
DueCalculationBaseDate DueCalculationBaseDate
PaymentTerms
CashDiscount1Days 0
CashDiscount2Days 00
NetPaymentDays 00
CashDiscount1Percent 000
CashDiscount2Percent 00
PaymentMethod
PaymentBlockingReason
FixedCashDiscount
HouseBank P_CN_JOURNALENTRYHSBK HouseBank
BPBankAccountInternalID
InvoiceReference InvoiceReference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear
InvoiceItemReference InvoiceItemReference
FollowOnDocumentType FollowOnDocumentType
StateCentralBankPaymentReason
SupplyingCountry
InvoiceList
BillOfExchangeUsage BillOfExchangeUsage
Material Material
Plant Plant
PurchasingDocument
PurchasingDocumentItem
AccountAssignmentNumber
ValuationArea ValuationArea
InventoryValuationType InventoryValuationType
VATRegistration
DelivOfGoodsDestCountry
PaymentDifferenceReason
ProfitCenter ProfitCenter
JointVenture JointVenture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode
JointVentureEquityGroup JointVentureEquityGroup
TreasuryContractType TreasuryContractType
AssetContract AssetContract
CashFlowType CashFlowType
RealEstateObject RealEstateObject
SettlementReferenceDate SettlementReferenceDate
CommitmentItem CommitmentItem
CostObject CostObject
ProjectNetwork ProjectNetwork
OrderInternalBillOfOperations OrderInternalBillOfOperations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
WBSElementInternalID WBSElementInternalID
ProfitabilitySegment_2 ProfitabilitySegment_2
ClearingIsReversed ClearingIsReversed
PaymentMethodSupplement PaymentMethodSupplement
AlternativeGLAccount AlternativeGLAccount
FundsCenter FundsCenter
Fund Fund
PartnerProfitCenter PartnerProfitCenter
Reference1IDByBusinessPartner Reference1IDByBusinessPartner
Reference2IDByBusinessPartner Reference2IDByBusinessPartner
PaymentCardItem PaymentCardItem
PaymentCardPaymentSettlement PaymentCardPaymentSettlement
Reference3IDByBusinessPartner Reference3IDByBusinessPartner
ClearingItem ClearingItem
BusinessPlace BusinessPlace
TaxSection TaxSection
CostCtrActivityType CostCtrActivityType
BusinessProcess BusinessProcess
GrantID GrantID
FundedProgram FundedProgram
ClearingDocFiscalYear ClearingDocFiscalYear
Segment Segment
PartnerSegment PartnerSegment
PartnerFunctionalArea PartnerFunctionalArea
HouseBankAccount P_CN_JOURNALENTRYHSBK HouseBankAccount
CostElement CostElement
PostingDate P_CN_JOURNALENTRYHSBK PostingDate
NetDueDate NetDueDate
OffsettingAccount OffsettingAccount
OffsettingAccountType OffsettingAccountType
PartnerFund PartnerFund
PartnerGrant PartnerGrant
BudgetPeriod BudgetPeriod
PartnerBudgetPeriod PartnerBudgetPeriod
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy
ValuationDiffAmtInCoCodeCrcy ValuationDiffAmtInCoCodeCrcy
TransactionCurrency TransactionCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
TaxAmount TaxAmount
BalanceTransactionCurrency BalanceTransactionCurrency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy
AdditionalCurrency1 AdditionalCurrency1
ValuationDiffAmtInAddlCrcy1 ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2
ValuationDiffAmtInAddlCrcy2 ValuationDiffAmtInAddlCrcy2
BaseUnit BaseUnit
Quantity Quantity
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem
ChartOfAccounts ChartOfAccounts
ClearingDate ClearingDate
ClearingCreationDate ClearingCreationDate
ClearingAccountingDocument ClearingAccountingDocument
PostingKey PostingKey
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
SpecialGLTransactionType SpecialGLTransactionType
BusinessArea BusinessArea
PartnerBusinessArea PartnerBusinessArea
TaxCode TaxCode
WithholdingTaxCode WithholdingTaxCode
TaxType TaxType
TransactionTypeDetermination TransactionTypeDetermination
ValueDate ValueDate
AssignmentReference AssignmentReference
DocumentItemText DocumentItemText
PartnerCompany PartnerCompany
FinancialTransactionType FinancialTransactionType
CorporateGroupAccount CorporateGroupAccount
PlanningLevel PlanningLevel
ControllingArea ControllingArea
CostCenter CostCenter
Project Project
OrderID OrderID
BillingDocument BillingDocument
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
ScheduleLine ScheduleLine
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
AssetTransactionType AssetTransactionType
AssetValueDate AssetValueDate
PersonnelNumber PersonnelNumber
IsSalesRelated IsSalesRelated
LineItemDisplayIsEnabled LineItemDisplayIsEnabled
IsOpenItemManaged IsOpenItemManaged
IsNotCashDiscountLiable IsNotCashDiscountLiable
IsAutomaticallyCreated IsAutomaticallyCreated
IsUsedInPaymentTransaction IsUsedInPaymentTransaction
OperationalGLAccount OperationalGLAccount
GLAccount GLAccount
Customer Customer
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
InvoiceReference InvoiceReference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear
InvoiceItemReference InvoiceItemReference
FollowOnDocumentType FollowOnDocumentType
StateCentralBankPaymentReason StateCentralBankPaymentReason
SupplyingCountry SupplyingCountry
InvoiceList InvoiceList
BillOfExchangeUsage BillOfExchangeUsage
Material Material
Plant Plant
PurchasingDocument PurchasingDocument
PurchasingDocumentItem PurchasingDocumentItem
AccountAssignmentNumber AccountAssignmentNumber
ValuationArea ValuationArea
InventoryValuationType InventoryValuationType
VATRegistration VATRegistration
DelivOfGoodsDestCountry DelivOfGoodsDestCountry
PaymentDifferenceReason PaymentDifferenceReason
ProfitCenter ProfitCenter
JointVenture JointVenture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode
JointVentureEquityGroup JointVentureEquityGroup
TreasuryContractType TreasuryContractType
AssetContract AssetContract
CashFlowType CashFlowType
RealEstateObject RealEstateObject
SettlementReferenceDate SettlementReferenceDate
CommitmentItem CommitmentItem
CostObject CostObject
ProjectNetwork ProjectNetwork
OrderInternalBillOfOperations OrderInternalBillOfOperations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
WBSElementInternalID WBSElementInternalID
ProfitabilitySegment_2 ProfitabilitySegment_2
ClearingIsReversed ClearingIsReversed
PaymentMethodSupplement PaymentMethodSupplement
AlternativeGLAccount AlternativeGLAccount
FundsCenter FundsCenter
Fund Fund
PartnerProfitCenter PartnerProfitCenter
Reference1IDByBusinessPartner Reference1IDByBusinessPartner
Reference2IDByBusinessPartner Reference2IDByBusinessPartner
PaymentCardItem PaymentCardItem
PaymentCardPaymentSettlement PaymentCardPaymentSettlement
Reference3IDByBusinessPartner Reference3IDByBusinessPartner
ClearingItem ClearingItem
BusinessPlace BusinessPlace
TaxSection TaxSection
CostCtrActivityType CostCtrActivityType
BusinessProcess BusinessProcess
GrantID GrantID
FundedProgram FundedProgram
ClearingDocFiscalYear ClearingDocFiscalYear
Segment Segment
PartnerSegment PartnerSegment
PartnerFunctionalArea PartnerFunctionalArea
HouseBankAccount HouseBankAccount
CostElement CostElement
PostingDate PostingDate
NetDueDate NetDueDate
OffsettingAccount OffsettingAccount
OffsettingAccountType OffsettingAccountType
PartnerFund PartnerFund
PartnerGrant PartnerGrant
BudgetPeriod BudgetPeriod
PartnerBudgetPeriod PartnerBudgetPeriod
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy
ValuationDiffAmtInCoCodeCrcy ValuationDiffAmtInCoCodeCrcy
TransactionCurrency TransactionCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
TaxAmount TaxAmount
BalanceTransactionCurrency BalanceTransactionCurrency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy
AdditionalCurrency1 AdditionalCurrency1
ValuationDiffAmtInAddlCrcy1 ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2
ValuationDiffAmtInAddlCrcy2 ValuationDiffAmtInAddlCrcy2
BaseUnit BaseUnit
Quantity Quantity
NumberOfItems NumberOfItems
@AbapCatalog.sqlViewName: 'PCNJRNLENTRITM'
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_CN_JOURNALENTRYITEM 
       as select from I_AddlLedgerOplAcctgDocItem as bseg inner join P_CN_JOURNALENTRYHSBK as hsbk
       on hsbk.CompanyCode = bseg.CompanyCode and hsbk.AccountingDocument = bseg.AccountingDocument and hsbk.FiscalYear = bseg.FiscalYear
       and hsbk.AccountingDocumentItem = bseg.AccountingDocumentItem
{
             
  key  bseg.CompanyCode,   
  key  bseg.AccountingDocument,
  key  bseg.FiscalYear,
  key  bseg.AccountingDocumentItem,

       ChartOfAccounts,
       ClearingDate,
       ClearingCreationDate,
    
       ClearingAccountingDocument,
  
       PostingKey,
    
       FinancialAccountType,
       ' ' as SpecialGLCode,
       ' ' as SpecialGLTransactionType,
       case 
         when AmountInTransactionCurrency < 0 and DebitCreditCode = 'S'      then 'H'
         when AmountInTransactionCurrency > 0 and DebitCreditCode = 'H'      then 'S'
         else DebitCreditCode
       end as DebitCreditCode,   
       case
        when   AmountInTransactionCurrency < 0 then AmountInTransactionCurrency * -1
        else   AmountInTransactionCurrency
       end as AmountInTransCrcyWithNoSign,
       BusinessArea,
       PartnerBusinessArea,
       TaxCode,
       WithholdingTaxCode,
       ' ' as  TaxType,
       TransactionTypeDetermination,
       ValueDate,
       AssignmentReference,
       DocumentItemText,
       PartnerCompany,
       FinancialTransactionType,
       CorporateGroupAccount,
       '  ' as PlanningLevel,
       ControllingArea,
       CostCenter,
       Project,
       OrderID,
       '          ' as BillingDocument,
       '          ' as SalesDocument,
       '000000' as  SalesDocumentItem,
       '0000' as ScheduleLine,
       MasterFixedAsset,
       FixedAsset,
       AssetTransactionType,
       '00000000' as AssetValueDate,
       '00000000' as PersonnelNumber,
       '' as  IsSalesRelated,
       '' as  LineItemDisplayIsEnabled,
       IsOpenItemManaged,
       ''     as  IsNotCashDiscountLiable,
       IsAutomaticallyCreated,
       '' as  IsUsedInPaymentTransaction,
       '          'as  OperationalGLAccount,
       GLAccount,
       '          '           as  Customer,
       '          ' as Supplier,
       '          ' as  BranchAccount,
       IsBalanceSheetAccount,
       ProfitLossAccountType,
       '                  ' as  SpecialGLAccountAssignment,
       DueCalculationBaseDate,
       '    ' as  PaymentTerms,
       0 as CashDiscount1Days,
       0.00 as CashDiscount2Days,
       0.00 as NetPaymentDays,
       0.000 as CashDiscount1Percent,
       0.00 as CashDiscount2Percent,
       ' ' as  PaymentMethod,
       ' ' as PaymentBlockingReason,
       ' ' as FixedCashDiscount,
       hsbk.HouseBank,
       '    ' as  BPBankAccountInternalID,
        
       InvoiceReference,
       InvoiceReferenceFiscalYear,
       InvoiceItemReference,
       FollowOnDocumentType,
       '   ' as StateCentralBankPaymentReason,
       '   ' as SupplyingCountry,
       '00000000' as InvoiceList,
       BillOfExchangeUsage,

       Material,

       Plant,
       '          ' as PurchasingDocument,
       '00000' as  PurchasingDocumentItem,
       '00' as AccountAssignmentNumber,
       
       ValuationArea,

       InventoryValuationType,
       '                    ' as VATRegistration,
       '   ' as DelivOfGoodsDestCountry,
        '   ' as PaymentDifferenceReason,
      ProfitCenter,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityGroup,
      TreasuryContractType,
      AssetContract,
      CashFlowType,
      RealEstateObject,
      SettlementReferenceDate,
      CommitmentItem,
      CostObject,
    
      ProjectNetwork,
      OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
 
      WBSElementInternalID,
      ProfitabilitySegment_2,
      ClearingIsReversed,
      PaymentMethodSupplement,
      AlternativeGLAccount,
      FundsCenter,
      Fund,
 
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,
      //EarmarkedFunds,

      //EarmarkedFundsItem, note '2788265' Global field name change. 

      PaymentCardItem,
      PaymentCardPaymentSettlement,
      Reference3IDByBusinessPartner,
      ClearingItem,
      BusinessPlace,
      TaxSection,

      CostCtrActivityType,

      BusinessProcess,
      GrantID,
      FundedProgram,
      ClearingDocFiscalYear,
    
      Segment,
    
      PartnerSegment,
     
      PartnerFunctionalArea,
      hsbk.HouseBankAccount,
      CostElement,
      
      hsbk.PostingDate,
      NetDueDate,
     
      OffsettingAccount,
   
      OffsettingAccountType,
      PartnerFund,
      PartnerGrant,
    
      BudgetPeriod,
      PartnerBudgetPeriod,

    
      @Semantics.currencyCode:true
      CompanyCodeCurrency,

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

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

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

    
      @Semantics.currencyCode:true
      TransactionCurrency,

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


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


   
      @Semantics.currencyCode:true
      BalanceTransactionCurrency,

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



      @Semantics.currencyCode:true
      AdditionalCurrency1,

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


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

 
   
      @Semantics.currencyCode:true
      AdditionalCurrency2,

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

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


    
      @Semantics.unitOfMeasure:true
      BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Quantity,
      @DefaultAggregation: #SUM
      NumberOfItems
         
} // perform joins that are only relevant for BSEG and not for BSEG_ADD here. The common joins

  // will be performed in another CDS view on to of this one. Motivation: Avoid useless joins

  // for BSEG_ADD-lines 

  union all select from  I_OperationalAcctgDocItem
  
  {

    
  key CompanyCode,

  key AccountingDocument,
   
  key FiscalYear,

  key lpad(AccountingDocumentItem, 6, '0') as AccountingDocumentItem,

      ChartOfAccounts,
      //buzid,

      ClearingDate,
      ClearingCreationDate,

      ClearingAccountingDocument,

      PostingKey,
  
      FinancialAccountType,

      SpecialGLCode,
      SpecialGLTransactionType,
      //zumsk,

  
      case 
        when AmountInTransactionCurrency < 0 and DebitCreditCode = 'S'      then 'H'
        when AmountInTransactionCurrency > 0 and DebitCreditCode = 'H'      then 'S'
        else DebitCreditCode
      end as DebitCreditCode,
      case
        when AmountInTransactionCurrency < 0 then AmountInTransactionCurrency * -1
        else AmountInTransactionCurrency
      end as  AmountInTransCrcyWithNoSign,
      BusinessArea,

      PartnerBusinessArea,
//      @ObjectModel.foreignKey.association: '_TaxCode'

      TaxCode,
      WithholdingTaxCode,
      //shzuz,

      //stekz,


      TaxType,
      //txgrp,

      TransactionTypeDetermination,
      //kursr,

      ValueDate,
      AssignmentReference,
      DocumentItemText,
      //zinkz,

  
      PartnerCompany,

      FinancialTransactionType,
      CorporateGroupAccount,
      //vorgn,

      PlanningLevel,
      //fdgrp,

      //fdtag,

      //fkont,


      ControllingArea,
 
      CostCenter,
      Project,

      OrderID,
      BillingDocument,
 
      SalesDocument,

      SalesDocumentItem,
      ScheduleLine,
  
      MasterFixedAsset,
   
      FixedAsset,

      AssetTransactionType,
      AssetValueDate,
     
      PersonnelNumber,
      IsSalesRelated,
      //xhres,

      LineItemDisplayIsEnabled,
      IsOpenItemManaged,
      //xcpdd,

      //xskst,

      //xsauf,

      //xspro,

      //xserg,

      //xfakt,

      //xuman,

      //xanet,

      IsNotCashDiscountLiable,
      //xinve,

      //xpanz,

      IsAutomaticallyCreated,
      //xncop,

      IsUsedInPaymentTransaction,
      OperationalGLAccount,
    
      GLAccount,

      Customer,

      Supplier,
      BranchAccount,
      IsBalanceSheetAccount,
      ProfitLossAccountType,
      SpecialGLAccountAssignment,
      DueCalculationBaseDate,
      PaymentTerms,
     CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      PaymentMethod,
      PaymentBlockingReason,
      FixedCashDiscount,
     
     HouseBank,
      
       BPBankAccountInternalID,
      //TaxDistributionCode1,

      // TaxDistributionCode2,

      // TaxDistributionCode3,

      InvoiceReference,
       InvoiceReferenceFiscalYear,
      InvoiceItemReference,
      FollowOnDocumentType,
      //zollt,

      //zolld,

      StateCentralBankPaymentReason,
     
      SupplyingCountry,
      //diekz,

      InvoiceList,
      //abper as SettlementFiscalYearPeriod,

      //vrskz,

      //vrsdt,

      //disbn,

      //disbj,

      //disbz,

      BillOfExchangeUsage,
      //anfbn,

      //anfbj,

      //anfbu,

      //anfae,

      //blnkz,

      //blnpz,

     // DunningKey,

     // DunningBlockingReason,

   //  LastDunningDate,

     // DunningLevel,

     // DunningArea,

      //esrnr,

      //esrre,

      //esrpz,

     // WithholdingTaxCertificate,

      
     Material,
     
     Plant,
     
      PurchasingDocument,
     
      PurchasingDocumentItem,
     AccountAssignmentNumber,
     // IsCompletelyDelivered,

      // MaterialPriceControl,

      
       ValuationArea,
      
      InventoryValuationType,
      //bustw,

      //psalt,

      //tbtkz,

      //spgrp,

      //spgrm,

      //spgrt,

      //spgrg,

      //spgrv,

      //spgrq,

      VATRegistration,
      DelivOfGoodsDestCountry,
      //eglld,

      
     PaymentDifferenceReason,
      //ryacq,

      //rpacq,

      
      ProfitCenter,
      //xhkom,

     JointVenture,
     JointVentureCostRecoveryCode,
     JointVentureEquityGroup,
      //vptnr,

       TreasuryContractType,
      AssetContract,
       CashFlowType,
      //depot,

    // TaxJurisdiction,

      RealEstateObject,
      SettlementReferenceDate,
      //popts,

      CommitmentItem,
      CostObject,
         
      ProjectNetwork,
     OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
      
      WBSElementInternalID,
       ProfitabilitySegment_2,
      //pasubnr,

      //spgrs,

      //spgrc,

      //btype,

    // JointVentureEquityType,

     // IsEUTriangularDeal,

      //lnran,

//      @ObjectModel.foreignKey.association: '_CostOriginGroup'

     // CostOriginGroup,

     // CompanyCodeCurrencyDetnMethod,

      //glupm,

       ClearingIsReversed,
      PaymentMethodSupplement,
//      @ObjectModel.foreignKey.association: '_AlternativeGLAccount'

      AlternativeGLAccount,
//      @ObjectModel.foreignKey.association: '_FundsCenter'

      FundsCenter,
//      @ObjectModel.foreignKey.association: '_Fund'

      Fund,
      //stbuk,

     
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,
      //EarmarkedFunds,

      // EarmarkedFundsItem, note '2788265' Global field name change. 

      //fkber,

      //obzei,

     // IsNegativePosting,

      PaymentCardItem,
      PaymentCardPaymentSettlement,
     //CreditControlArea,

      //empfb,

      Reference3IDByBusinessPartner,
     // DataExchangeInstruction1,

     // DataExchangeInstruction2,

     // DataExchangeInstruction3,

    //  DataExchangeInstruction4,

      //gricd,

     // Region,

      //gityp as EmploymentTaxDistrType,

      // HasPaymentOrder,

    // PaymentReference,

      //idxsp,

      //linfv,

      //kontt,

      //kontl,

      //uebgdat,

     // TaxDeterminationDate,

      ClearingItem,
      BusinessPlace,
      TaxSection,
      
       CostCtrActivityType,
      //AccountsReceivableIsPledged,

      
      BusinessProcess,
      //pendays,

      //penrc,

      GrantID,
     
      //FunctionalArea,

      //CustomerIsInExecution,

      //srtype,

      //intreno,

      FundedProgram,
      ClearingDocFiscalYear,
      //ppa_ex_ind,

     // LedgerGLLineItem,

      
      Segment,
     
       PartnerSegment,
     
     PartnerFunctionalArea,
     
      HouseBankAccount,
      CostElement,
      //xlgclr,

      //taxps as TaxDocumentItemNumber,

      //pays_prov,

      //pays_tran,

     // SEPAMandate,

      //xfrge_bseg,

      
    //  ReferenceDocumentType,

    //  OriginalReferenceDocument,

     // ReferenceDocumentLogicalSystem,

     // AccountingDocumentItemRef,

      //buzei_sender,

      
      //FiscalPeriod,

      
      //AccountingDocumentCategory,


      PostingDate,
     //DocumentDate,

      
      //AccountingDocumentType,

     NetDueDate,
      //CashDiscount1DueDate,

     // CashDiscount2DueDate,

      //fqftype,

      //lqitem,

      
      OffsettingAccount,
      
      OffsettingAccountType,
      //ghkon,

//      @ObjectModel.foreignKey.association: '_PartnerFund'

      PartnerFund,
      PartnerGrant,
      
      BudgetPeriod,
     PartnerBudgetPeriod,
      //j_1tpbupl,

      //perop_beg,

      //perop_end,

      //fastpay,

      //ignr_ivref,

      //fmfgus_key,

      //fmxdocnr,

      //fmxyear,

      //fmxdocln,

      //fmxzekkn,

      //prodper,


    
      @Semantics.currencyCode:true
      CompanyCodeCurrency,

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

      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      @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'} } dmbt1_shl,


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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

      //InvoiceAmtInCoCodeCrcy,


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } rdiff_shl as CurrDiff,


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


    
      @Semantics.currencyCode:true
      TransactionCurrency,

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

     // @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'} } fwzuz_shl,


     // @DefaultAggregation: #SUM

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

      //WithholdingTaxBaseAmount,


      //@DefaultAggregation: #SUM

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


      //@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'} } wrbt1_shl,


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


   //   @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,


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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



      @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,

      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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


      //@DefaultAggregation: #SUM

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



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

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

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } dmb31_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } dmb32_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } dmb33_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } mwst3_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } navh3_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } sknt3_shl,


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

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } rdif3_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } txbh3_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } ppdif3_shl,


      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } penlc3_shl,



   
    //  @Semantics.currencyCode:true

    //  PaymentCurrency,

     // @DefaultAggregation: #SUM

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

    //   AmountInPaymentCurrency,

      //@Semantics.currencyCode:true

     // CreditControlAreaCurrency,

      //@Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} } klibt_shl,


     // @DefaultAggregation: #SUM

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

    // HedgedAmount,


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

    
      //@Semantics.unitOfMeasure:true

    // GoodsMovementEntryUnit,

      //@DefaultAggregation: #SUM

     // @Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} }

      //QuantityInEntryUnit,



     // @Semantics.unitOfMeasure:true

    // PurchasingDocumentPriceUnit,

     // @DefaultAggregation: #SUM

     // @Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} }

    // PurchaseOrderQty,


     //MaterialPriceUnitQty,


      @DefaultAggregation: #SUM
      NumberOfItems
      }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDLLEDGEROPLACCTGDOCITEM",
"I_OPERATIONALACCTGDOCITEM",
"P_CN_JOURNALENTRYHSBK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/