FAC_DART_Z3_AP_TRIAL_BALANCE

A/P-Trial Balance | view: FAC_DZAPTRIBAL | Extraction: Not supported | Component: DART (Data Retention Tool)
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
StartingBalanceAmtInCoCodeCrcy Starting Balance Amount In Company Code Currency
DebitAmountInCoCodeCrcy Debit Balance in Company Code Currency
CreditAmountInCoCodeCrcy Credit Balance in Company Code Currency
CreditAmountInCoCodeCrcyDis Credit Balance in Company Code Currency
EndingBalanceAmtInCoCodeCrcy Ending Balance in Company Code Currency
IntmdEndingBalAmtInCoCodeCrcy Ending Balance in Company Code Currency
GLAcctDebitAmtInCoCodeCrcy Debit Amount in Company Code Currency
GLAcctCreditAmtInCoCodeCrcy Credit Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
StartingBalanceAmtInGlobalCrcy Starting Balance Amount In Global Currency
DebitAmountInGlobalCrcy Debit Balance in Global Currency
CreditAmountInGlobalCrcy Credit Balance in Global Currency
CreditAmountInGlobalCrcyDis Credit Balance in Global Currency
EndingBalanceAmtInGlobalCrcy Ending Balance in Global Currency
IntmdEndingBalAmtInGlobalCrcy Ending Balance in Global Currency
IntmdDebitAmountInGlobalCrcy Debit Amount in Global Currency
IntmdCreditAmountInGlobalCrcy Credit Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
StartingBalAmtInFreeDfndCrcy1 Starting Balance Amount In Freely Defined Currency 1
DebitAmountInFreeDefinedCrcy1 Debit Balance in Freely Defined Currency 1
CreditAmountInFreeDefinedCrcy1 Credit Balance in Freely Defined Currency 1
CreditAmtInFreeDefinedCrcy1Dis Credit Balance in Freely Defined Currency 1
EndingBalAmtInFreeDfndCrcy1 Ending Balance in Freely Defined Currency 1
IntmdEndingBalInFreeDfndCrcy1 Ending Balance in Free Defined Currency 1
IntmdDebitAmtInFreeDfndCrcy1 Debit Amount in Free Defined Currency 1
IntmdCreditAmtInFreeDfndCrcy1 Credit Amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
StartingBalAmtInFreeDfndCrcy2 Starting Balance Amount In Freely Defined Currency 2
DebitAmountInFreeDefinedCrcy2 Debit Balance in Freely Defined Currency 2
CreditAmountInFreeDefinedCrcy2 Credit Balance in Freely Defined Currency 2
CreditAmtInFreeDefinedCrcy2Dis Credit Balance in Freely Defined Currency 2
EndingBalAmtInFreeDfndCrcy2 Ending Balance in Freely Defined Currency 2
IntmdEndingBalInFreeDfndCrcy2 Ending Balance in Free Defined Currency 2
IntmdDebitAmtInFreeDfndCrcy2 Debit Amount in Free Defined Currency 2
IntmdCreditAmtInFreeDfndCrcy2 Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
StartingBalAmtInFreeDfndCrcy3 Starting Balance Amount In Freely Defined Currency 3
DebitAmountInFreeDefinedCrcy3 Debit Balance in Freely Defined Currency 3
CreditAmountInFreeDefinedCrcy3 Credit Balance in Freely Defined Currency 3
CreditAmtInFreeDefinedCrcy3Dis Credit Balance in Freely Defined Currency 3
EndingBalAmtInFreeDfndCrcy3 Ending Balance in Freely Defined Currency 3
IntmdEndingBalInFreeDfndCrcy3 Ending Balance in Free Defined Currency 3
IntmdDebitAmtInFreeDfndCrcy3 Debit Amount in Free Defined Currency 3
IntmdCreditAmtInFreeDfndCrcy3 Credit Amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
StartingBalAmtInFreeDfndCrcy4 Starting Balance Amount In Freely Defined Currency 4
DebitAmountInFreeDefinedCrcy4 Debit Balance in Freely Defined Currency 4
CreditAmountInFreeDefinedCrcy4 Credit Balance in Freely Defined Currency 4
CreditAmtInFreeDefinedCrcy4Dis Credit Balance in Freely Defined Currency 4
EndingBalAmtInFreeDfndCrcy4 Ending Balance in Freely Defined Currency 4
IntmdEndingBalInFreeDfndCrcy4 Ending Balance in Free Defined Currency 4
IntmdDebitAmtInFreeDfndCrcy4 Debit Amount in Free Defined Currency 4
IntmdCreditAmtInFreeDfndCrcy4 Credit Amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
StartingBalAmtInFreeDfndCrcy5 Starting Balance Amount In Freely Defined Currency 5
DebitAmountInFreeDefinedCrcy5 Debit Balance in Freely Defined Currency 5
CreditAmountInFreeDefinedCrcy5 Credit Balance in Freely Defined Currency 5
CreditAmtInFreeDefinedCrcy5Dis Credit Balance in Freely Defined Currency 5
EndingBalAmtInFreeDfndCrcy5 Ending Balance in Freely Defined Currency 5
IntmdEndingBalInFreeDfndCrcy5 Ending Balance in Free Defined Currency 5
IntmdDebitAmtInFreeDfndCrcy5 Debit Amount in Free Defined Currency 5
IntmdCreditAmtInFreeDfndCrcy5 Credit Amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
StartingBalAmtInFreeDfndCrcy6 Starting Balance Amount In Freely Defined Currency 6
DebitAmountInFreeDefinedCrcy6 Debit Balance in Freely Defined Currency 6
CreditAmountInFreeDefinedCrcy6 Credit Balance in Freely Defined Currency 6
CreditAmtInFreeDefinedCrcy6Dis Credit Balance in Freely Defined Currency 6
EndingBalAmtInFreeDfndCrcy6 Ending Balance in Freely Defined Currency 6
IntmdEndingBalInFreeDfndCrcy6 Ending Balance in Free Defined Currency 6
IntmdDebitAmtInFreeDfndCrcy6 Debit Amount in Free Defined Currency 6
IntmdCreditAmtInFreeDfndCrcy6 Credit Amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
StartingBalAmtInFreeDfndCrcy7 Starting Balance Amount In Freely Defined Currency 7
DebitAmountInFreeDefinedCrcy7 Debit Balance in Freely Defined Currency 7
CreditAmountInFreeDefinedCrcy7 Credit Balance in Freely Defined Currency 7
CreditAmtInFreeDefinedCrcy7Dis Credit Balance in Freely Defined Currency 7
EndingBalAmtInFreeDfndCrcy7 Ending Balance in Freely Defined Currency 7
IntmdEndingBalInFreeDfndCrcy7 Ending Balance in Free Defined Currency 7
IntmdDebitAmtInFreeDfndCrcy7 Debit Amount in Free Defined Currency 7
IntmdCreditAmtInFreeDfndCrcy7 Credit Amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
StartingBalAmtInFreeDfndCrcy8 Starting Balance Amount In Freely Defined Currency 8
DebitAmountInFreeDefinedCrcy8 Debit Balance in Freely Defined Currency 8
CreditAmountInFreeDefinedCrcy8 Credit Balance in Freely Defined Currency 8
CreditAmtInFreeDefinedCrcy8Dis Credit Balance in Freely Defined Currency 8
EndingBalAmtInFreeDfndCrcy8 Ending Balance in Freely Defined Currency 8
IntmdEndingBalInFreeDfndCrcy8 Ending Balance in Free Defined Currency 8
IntmdDebitAmtInFreeDfndCrcy8 Debit Amount in Free Defined Currency 8
IntmdCreditAmtInFreeDfndCrcy8 Credit Amount in Free Defined Currency 8
💲 Balance Transaction Currency (BalanceTransactionCurrency):
StartingBalAmtInBalTransCrcy Starting Balance Amount In Balance Transaction Currency
DebitAmountInBalanceTransCrcy Debit Balance in Balance Transaction Currency
CreditAmountInBalanceTransCrcy Credit Balance in Balance Transaction Currency
CreditAmtInBalanceTransCrcyDis Credit Balance in Balance Transaction Currency
EndingBalanceAmtInBalTransCrcy Ending Balance in Balance Transaction Currency
IntmdEndingBalInBalTransCrcy Ending Balance in Balance Transaction Currency
IntmdDebitAmtInBalTransCrcy Debit Amount in Balance Transaction Currency
IntmdCreditAmtInBalTransCrcy Credit Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
StartingBalanceAmtInTransCrcy Starting Balance Amount In Transaction Currency
DebitAmountInTransCrcy Debit Balance in Transaction Currency
CreditAmountInTransCrcy Credit Balance in Transaction Currency
CreditAmountInTransCrcyDis Credit Balance in Transaction Currency
EndingBalanceAmtInTransCrcy Ending Balance in Transaction Currency
IntmdEndingBalanceInTransCrcy Ending Balance in Transaction Currency
IntmdDebitAmtInTransCrcy Debit Amount in Transaction Currency
IntmdCreditAmountInTransCrcy Credit Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
AssetValueDate Asset Value Date
SettlementReferenceDate Settlement Reference Date
ClearingDate Clearing Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsSettlement Indicator: Item is Settling or Transferring Another Item Show values
IsSettled Indicator: Line Item is Settled or Transferred Show values
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
OriginObjectType Type of Origin Object Show values
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
QuantityIsIncomplete Indicator: Quantity Is Incomplete Show values
OffsettingAccountType Offsetting Account Type Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
ControllingObjectClass Object Class Show values
PartnerControllingObjectClass Partner object class Show values
PartnerOrderCategory Partner Order Category Show values
OrderCategory Order category Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
Column Name Description Domain name
SystemClient 3-Byte field
CompanyCode Company Code BUKRS
Supplier Supplier LIFNR
Customer Customer Number
GLAccount G/L Account SAKNR
FiscalYear Fiscal Year GJAHR
LedgerFiscalYear Ledger Fiscal Year GJAHR
SourceLedger Source Ledger FINS_LEDGER
FinancialTransactionType Financial Transaction Type RMVCT
BusinessTransactionType Business Transaction Type FINS_CUSTBTTYPE
ReferenceDocumentType Reference Document Type AWTYP
LogicalSystem Logical System LOGSYS
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
PredecessorReferenceDocType Predecessor Reference Document Type AWTYP
ProfitCenter Profit Center PRCTR
FunctionalArea Functional Area FKBER
BusinessArea Business Area GSBER
ControllingArea Controlling Area CACCD
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerCostCenter Partner Cost Center KOSTL
PartnerProfitCenter Partner Profit Center PRCTR
PartnerFunctionalArea Partner Functional Area FKBER
PartnerBusinessArea Partner Business Area GSBER
PartnerCompany Company ID of Trading Partner RCOMP
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
FiscalYearVariant Fiscal Year Variant PERIV
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
AccountingDocumentType Journal Entry Type BLART
AssignmentReference Assignment Reference ZUONR
PostingKey Posting Key BSCHL
TransactionTypeDetermination Transaction Key CHAR3
AccountingDocCreatedByUser User that created the journal entry
EliminationProfitCenter Elimination Profit Center PRCTR
ChartOfAccounts Chart of Accounts KTOPL
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
CountryChartOfAccounts Alternative Chart of Accounts for Country/Region KTOPL
PurchasingDocument Purchasing Document EBELN
PurchasingDocumentItem Purchasing Document Item EBELP
AccountAssignmentNumber Account Assignment Number NUM02
Material Product (Deprecated) MATNR
MaterialName Product Description TEXT40
Plant Plant WERKS
PlantName Plant Name TEXT30
SpecialGLCode Special G/L Indicator UMSKZ
TaxCode Tax on Sales/Purchases Code MWSKZ
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
AssetDepreciationArea Asset Depreciation Area (Real or Derived) AFABE
MasterFixedAsset Fixed Asset ANLN1
FixedAsset Asset Subnumber ANLN2
AssetTransactionType Asset Transaction Type BWASL
GroupMasterFixedAsset Group Asset ANLN1
GroupFixedAsset Group Asset Subnumber ANLN2
InventorySpecialStockType Inventory Special Stock Type SOBKZ
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InventorySpclStockWBSElement WBS Element (external) of Valuated Special Inventory PS_POSID
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
InventoryValuationType Inventory Valuation Type BWTAR
ValuationArea Valuation area BWKEY
SenderGLAccount Sender G/L Account CHAR10
SenderAccountAssignment Sender Account Assignment ACCAS
SenderAccountAssignmentType Account Assignment Type in Sender System J_OBART
OffsettingAccount Offsetting Account GKONT
PersonnelNumber Personnel Number PERNR
PartnerCompanyCode Partner Company Code BUKRS
OriginCostCenter Origin Cost Center KOSTL
OriginCostCtrActivityType Origin Cost Center Activity Type LSTAR
AccountAssignment Account Assignment ACCAS
AccountAssignmentType Account Assignment Type J_OBART
ProjectNetwork Network Number for Account Assignment AUFNR
RelatedNetworkActivity Network activity VORNR
BusinessProcess Business Process CO_PRZNR
CostObject Cost Object KSTRG
CustomerServiceNotification Customer Service Notification QMNUM
OperatingConcern Operating concern ERKRS
PartnerAccountAssignment Partner Account Assignment ACCAS
PartnerAccountAssignmentType Partner Account Assignment Type J_OBART
PartnerCostCtrActivityType Partner Cost Center Activity Type LSTAR
PartnerOrder Partner Order AUFNR
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProject Partner Project FIS_PROJECT
PartnerSalesDocument Partner Sales Document VBELN
PartnerSalesDocumentItem Partner Sales Document Item POSNR
PartnerProjectNetwork Partner Project Network AUFNR
PartnerProjectNetworkActivity Partner Project Network Activity VORNR
PartnerBusinessProcess Partner Business Process CO_PRZNR
PartnerCostObject Partner Cost Object KSTRG
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
PartnerServiceDocumentType Partner Service Document Type CRM_PROCESS_TYPE
PartnerServiceDocument Partner Service Document CRM_OBJECT_ID
PartnerServiceDocumentItem Partner Service Document Item
ServiceContract Service Contract ID CRM_OBJECT_ID
ServiceContractType Service Contract Type CRM_PROCESS_TYPE
ServiceContractItem Service Contract Item ID FCO_SRVDOC_ITEM_ID
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SoldMaterial Product Sold (Deprecated) MATNR
MaterialGroup Product Sold Group (Deprecated) MATKL
MaterialGroupName Product Group Description TEXT20
CustomerGroup Customer Group KDGRP
FinancialManagementArea Financial Management Area FIKRS
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
PartnerFund Partner Fund BP_GEBER
PartnerGrant Partner Grant GM_GRANT_NBR
PartnerBudgetPeriod FM: Partner Budget Period FM_BUDGET_PERIOD
JointVenture Joint venture JV_NAME
JointVentureEquityGroup Joint Venture Equity Group JV_EGROUP
JointVentureCostRecoveryCode Joint Venture Cost Recovery Code JV_RECIND
JointVentureEquityType Joint Venture Equity Type JV_ETYPE
CostCenter Cost Center KOSTL
CostCtrActivityType Activity Type LSTAR
OrderID Order ID AUFNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
FiscalPeriodDate Fiscal Period Date FIS_FISCALPERIOD_DATE
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
Master Data Relations Join Conditions
Group Account Number
  • Group Account Number
  • Group Chart of Accts
  • Client
  • FAC_DART_Z3_AP_TRIAL_BALANCE.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • FAC_DART_Z3_AP_TRIAL_BALANCE.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
  • FAC_DART_Z3_AP_TRIAL_BALANCE.MANDT == SKA1.MANDT
Group Chart of Accts
  • Group Chart of Accts
  • Client
  • FAC_DART_Z3_AP_TRIAL_BALANCE.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_AP_TRIAL_BALANCE.MANDT == T004.MANDT
Ledger
  • Client
  • Ledger