I_GrossMargin

Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger Source Ledger
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy Financial Statement Version
SemanticTag Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
FinancialPlanningReqTransSqnc Request Transaction Sequence Number
FinancialPlanningDataPacket Data packet number
FinancialPlanningEntryItem Data record number
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
InvertedAmtInCoCodeCurrency Amount in Company Code Currency
ActlRecognizedRevnAmtInCCCrcy Actual Recognized Revenue Amount in Company Code Currency
ActualCostAmtInCCCrcy Actual Cost Amount in Company Code Currency
ActlRecognizedMargAmtInCCCrcy Actual Recognized Margin Amount in Company Code Currency
ActlSlsDeductionAmtInCCCrcy Actual Reserve for Anticipated Sales Deductions Amt InCCCrcy
ActlBilledRevenueAmtInCCCrcy Actual Billed Revenue Amount In Company Code Currency
PrdtdRecognizedRevnAmtInCCCrcy Actual Recognized Revenue Amount in Company Code Currency
PrdtdCostAmtInCompanyCodeCrcy Actual Cost Amount in Company Code Currency
PrdtdRecognizedMargAmtInCCCrcy Actual Recognized Margin Amount in Company Code Currency
PrdtdSlsDeductionAmtInCCCrcy Actual Reserve for Anticipated Sales Deductions Amt InCCCrcy
PrdtdBilledRevenueAmtInCCCrcy Actual Billed Revenue Amount In Company Code Currency
RecognizedRevnAmtInCCCrcy Recognized Revenue
CostAmountInCompanyCodeCrcy Cost Amount in Company Code Currency
RecognizedMarginAmtInCCCrcy Recognized Margin
SalesDeductionAmtInCoCodeCrcy Sales Deduction
BilledRevenueAmtInCoCodeCrcy Actual Revenue
PlnRecognizedRevnAmtInCCCrcy Plan Recognized Revenue Amount in Company Code Currency
PlnCostAmtInCompanyCodeCrcy Plan Cost Amount in Company Code Currency
PlnRecognizedMargAmtInCCCrcy Plan Recognized Margin Amount in Company Code Currency
PlnSlsDeductionAmtInCCCrcy Plan Reserve for Anticipated Sales Deductions Amt InCCCrcy
PlnBilledRevenueAmtInCCCrcy Plan Billed Revenue Amount In Company Code Currency
PlanAmountInCompanyCodeCrcy Plan Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
InvertedAmountInGlobalCurrency Amount in Global Currency
AmountInGlobalCurrency Amount in Global Currency
ActlRecgdRevenueAmtInGlobCrcy Actual Recognized Revenue Amount In Global Currency
ActlCostOfGdsSoldAmtInGlobCrcy Actual Cost Of Goods Sold Amount In Global Currency
ActlRecgdMargAmtInGlobCrcy Recognized Margin
ActlSlsDeductionAmtInGlobCrcy Actual Sales Deduction Amount In Global Currency
ActlBilledRevenueAmtInGlobCrcy Actual Billed Revenue Amt In Global Currency
PrdtdRecgdRevenueAmtInGlobCrcy Actual Recognized Revenue Amount In Global Currency
PrdtdCostAmtInGlobCrcy Actual Cost Of Goods Sold Amount In Global Currency
PrdtdRecgdMargAmtInGlobCrcy Recognized Margin
PrdtdSlsDeductionAmtInGlobCrcy Actual Sales Deduction Amount In Global Currency
PrdtdBilledRevnAmtInGlobCrcy Actual Billed Revenue Amt In Global Currency
RecognizedRevnAmtInGlobCrcy Recognized Revenue
CostOfGoodsSoldAmtInGlobCrcy Cost of Goods Sold - Total
RecognizedMarginAmount Recognized Margin
SalesDeductionAmountInGlobCrcy Sales Deduction
BilledRevenueAmtInGlobCrcy Actual Revenue
PlnRecgdRevenueAmtInGlobCrcy Planned Recognized Revenue Amount In Global Currency
PlnCostOfGdsSoldAmtInGlobCrcy Planned Cost of Goods Sold Amount In Global Currency
PlnRecognizedMargAmtInGlobCrcy Plan Recognized Margin Amount in Company Code Currency
PlnSlsDeductionAmtInGlobCrcy Plan Sales Deduction Amount In Global Currency
PlnBilledRevenueAmtInGlobCrcy Plan Billed Revenue Amount In Global Currency
PlanAmountInGlobalCurrency Plan Amount in Global Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
InvertedAmtInTransCrcy Amount in Transaction Currency
PlanAmountInTransactionCrcy Plan Amount in Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
InvertedAmtInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1 Plan Amount in Freely Defined Currency 1
InvertedPlanAmtInFreeDfndCrcy1 Plan Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
InvertedAmtInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2 Plan Amount in Freely Defined Currency 2
InvertedPlanAmtInFreeDfndCrcy2 Plan Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
InvertedAmtInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3 Plan Amount in Freely Defined Currency 3
InvertedPlanAmtInFreeDfndCrcy3 Plan Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
InvertedAmtInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4 Plan Amount in Freely Defined Currency 4
InvertedPlanAmtInFreeDfndCrcy4 Plan Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
InvertedAmtInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5 Plan Amount in Freely Defined Currency 5
InvertedPlanAmtInFreeDfndCrcy5 Plan Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
InvertedAmtInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6 Plan Amount in Freely Defined Currency 6
InvertedPlanAmtInFreeDfndCrcy6 Plan Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
InvertedAmtInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7 Plan Amount in Freely Defined Currency 7
InvertedPlanAmtInFreeDfndCrcy7 Plan Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
InvertedAmtInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8 Plan Amount in Freely Defined Currency 8
InvertedPlanAmtInFreeDfndCrcy8 Plan Amount in Freely Defined Currency 8
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
DocumentDate Journal Entry Date
PostingDate Posting Date
CreationDate Creation Date
ClearingDate Clearing Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
JrnlEntryItemObsoleteReason Reason Item is Obsolete Show values
Column Name Description Domain name
SalesOrganization Sales Organization VKORG
CustomerGroup Customer Group KDGRP
Customer Customer Number KUNNR
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalPeriod Fiscal Period POPER
MaterialGroup Product Sold Group MATKL
ProfitCenter Profit Center PRCTR
ControllingArea Controlling Area CACCD
SalesDistrict Sales District BZIRK
Segment Segment for Segmental Reporting FB_SEGMENT
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
DistributionChannel Distribution Channel VTWEG
SoldMaterial Product Sold MATNR
BusinessTransactionType Business Transaction Type FINS_CUSTBTTYPE
BusinessArea Business Area GSBER
CostCenter Cost Center KOSTL
CustomerSupplierCountry Customer or Supplier Country/Region LAND1
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
GLAccount G/L Account SAKNR
ChartOfAccounts Chart of Accounts KTOPL
LedgerFiscalYear Ledger Fiscal Year GJAHR
FinancialTransactionType Financial Transaction Type RMVCT
AssignmentReference Assignment Reference ZUONR
PostingKey Posting Key BSCHL
AccountingDocCreatedByUser User that created the journal entry
Plant Plant WERKS
SpecialGLCode Special G/L Indicator UMSKZ
ClearingAccountingDocument Clearing Journal Entry BELNR
BillingDocumentType Billing Type FKART
OrganizationDivision Division SPART
CustomerSupplierIndustry Customer Supplier Industry BRSCH
BillToParty Bill-to Party KUNNR
ShipToParty Ship-to Party KUNNR
SourceReferenceDocumentType Source Document Type AWTYP
SourceReferenceDocument Source Document Reference Document Number AWREF
OperatingConcern Operating Concern ERKRS
TransactionTypeDetermination Transaction Key CHAR3
AccountingDocumentType Journal Entry Type BLART
ReferenceDocumentType Reference Document Type AWTYP
FiscalYearVariant Fiscal Year Variant PERIV
PlanningCategory Plan Category FCOM_CATEGORY
IsSimulation null
Master Data Relations Join Conditions
Division in order header
  • ?
  • Client
  • Division
  • ?
  • I_GROSSMARGIN.[column in domain "VTWEG"] == TVTA.VTWEG
  • I_GROSSMARGIN.MANDT == TVTA.MANDT
  • I_GROSSMARGIN.DIVISION == TVTA.SPART
  • I_GROSSMARGIN.[column in domain "VKORG"] == TVTA.VKORG
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order type in order header
  • Sales Document Type
  • Client
  • I_GROSSMARGIN.ORDERTYPE == TVAK.AUART
  • I_GROSSMARGIN.MANDT == TVAK.MANDT