P_TracvAccitem

CDS view for Treasury: Database view TRACV_ACCITEM | view: PTRACVACCITEM | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: TRACT_DOCUMENT, TRACT_POSCONTEXT, T003T, ADCP, ADRC, TGSBT, BUT000, T005T, T856T, T880, T008T, T042H, TBSL, TBSLT, T074T, TRDTS_BT_CAT_T, TRACC_AA_REF_T, TRAC_ACCSYMB_T, TRDC_DFLOWTYPE_T, BUT020, T042ZT, TRACT_ACCITEM, TRGC_VAL_AREA
Column Name Description
DocumentUUID FK Object Identity in Database Format
AccountingDocumentItemRef Accounting Document Line Item Number
Column Name Description
💲 Position Currency (PositionCurrency):
AmountInPositionCurrency Amount in Position Currency
💲 Local Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount (Local Currency)
Column Name Description
Column Name Description
PaymentDate Payment Date
PostingDate Posting Date in the Document
ReverseDocumentPostingDate Reverse Document Posting Date
DocumentDate Document Date in Document
Column Name Description
IsUsedInPaymentTransaction Payment Transaction Show values
TreasuryPostingCategory Posting Category Show values
TreasuryPaymentFlowDirection Direction of Flow Show values
TreasuryBusinessTransStatus Posting Status Show values
AccountingLedgerSelection Accounting Ledger Selection Show values
TreasuryAcctgPostingCategory Update to Financial Accounting Category Show values
TreasuryAcctgCreatedInRelease Indicator: Generate TRAC Document in Release Show values
ContextStatus Obsolete: Status of Position Context Show values
Column Name Description Domain name
TreasuryUpdateTypeName Name of the Update Type FTR_GEN_DESCRIPTION
TreasuryGLAccountAssignmentRef Account Assignment Reference of Position Management TPM_AA_REF
TreasuryGLAccountAssignRefName Name of the Account Assignment Reference FTR_GEN_DESCRIPTION
TreasuryGLAccountSymbolName Name of the Account Symbol FTR_GEN_DESCRIPTION
TreasuryPostingCategoryName Name of the Posting Category DDTEXT
PostingKey Posting Key BSCHL
PostingKeyName Posting Key Name TEXT20
GLAccount G/L Account Number SAKNR
TreasuryTransactionFlow Number of a Distributor Flow TPM_TRDFLOWNR
AccountingDocument Document Number of an Accounting Document BELNR
ReverseDocument Reverse Document BELNR
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
LogicalTransaction Logical Transaction LOGVO
JournalEntryType Document Type BLART
AccountingDocumentTypeName Document Type Name TEXT20
Customer Customer Number KUNNR
PaymentTerms Terms of payment key ZTERM
PaymentMethod Payment Method ZLSCH
PaymentMethodName Payment Method Name TEXT30
PaymentMethodSupplement Payment method supplement UZAWE
PaymentMethodSupplementName Name of the Payment Method Supplement TEXT30
PaymentBlockingReason Payment Block Key ZAHLS
PaymentBlockingReasonName Name of a Payment Block Reason TEXT20
PayerPayee Payer/Payee BU_PARTNER
PayerPayeeFullName Full Name of the Payer / Payee TEXT80
BPBankAccountInternalID Partner Bank Details BVTYP
HouseBank Short Key for Own House Bank HBKID
HouseBankAccount Short Key for House Bank Account HKTID
StateCentralBankPaymentReason State Central Bank Indicator LZBKZ
SupplyingCountry Supplying Country/Region LAND1
CountryName Country/Region Name TEXT50
AssignmentReference Assignment number ZUONR
JournalEntryItemText Journal Entry Item Text TEXT50
BusinessArea Business Area GSBER
BusinessAreaName Business Area Description TEXT30
CostCenter Cost Center KOSTL
FinancialTransactionType Transaction Type (FI) RMVCT
FinancialTransactionTypeName Name of a Transaction Type (FI) TEXT20
PartnerCompany Company ID RCOMP
CompanyName Company name TEXT30
Counterparty Counterparty number BU_PARTNER
CounterpartyFullName Full Name of the Counterparty TEXT80
Issuer Issuer Identity Key BU_PARTNER
IssuerFullName Full Name of the Issuer TEXT80
SubTraderFlowNumber Number of a Distributor Flow TPM_TRDFLOWNR
SEPAMandate Unique Reference to Mandate for each Payee ID035
SpecialGLCode Special G/L Indicator UMSKZ
SpecialGLCodeName Name of a Special GL Code TEXT30
TreasuryBusinessTransaction Identifier of the Distributor Business Transaction SYSUUID
DistributorDocumentID Distributor Document ID SYSUUID
TreasuryValuationArea Treasury Valuation Area TPM_VAL_AREA
TreasuryValuationAreaName Name of the Valuation Area FTR_GEN_DESCRIPTION
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Organizational Units AWORG
FiscalPeriod Fiscal period MONAT
FiscalYear Fiscal Year GJAHR
ReversalReferenceDocument Reversal: Reference Document No. of Document to Be Reversed AWREF
ReversalReferenceDocumentCntxt Reversal: Reference Organizations of Document to Be Reversed AWORG
ReverseDocumentFiscalPeriod Reverse Document Fiscal Period MONAT
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
TreasuryBusTransStatusName Name of the Posting Status TEXT15
Ledger Ledger RLDNR
AccountingPrinciple Accounting Principle ACCOUNTING_PRINCIPLE
RefBusinessTranID Business Transaction ID of Reference Business Transaction SYSUUID
TreasuryBusTransCategoryName Name of Business Transaction Category TPM_DESCRIPTION
ActivityFinancialTransaction Activity-Triggering Financial Transaction T_RFHA
DocumentHeaderText Document Header Text TEXT25
DocumentReference Reference Document Number XBLNR1
ReversalReason Reason for Reversal or Inverse Posting STGRD
TRReversalReason Reason for Reversal SSTOGRD
BusinessPlace Business Place J_1BBRANCH
TaxSection Section Code SECCO
UserNdataCLS Object Identity in Database Format TPM_DB_OS_GUID
PosContextUUID Object Identity in Database Format TPM_DB_OS_GUID
PosIdentityClS Object Identity in Database Format TPM_DB_OS_GUID
AccountAssignmentRefPrelim Account Assignment Reference (Prelim. Solution, Not CFM 1.0) TPM_ACC_ASS_REF
StorageSection Section Code SECCO
FunctionalArea Functional Area FKBER
Master Data Relations Join Conditions
Business Transaction Category P_TRACVACCITEM.TREASURYBUSINESSTRANSCATEGORY == TRDTS_BT_CAT.BUSTRANSCAT
Account Symbol for Account Assignment Reference
  • Client
  • Account Symbol for Account Assignment Reference
Foreign Key for Update Type
  • Client
  • Update Type