P_GrossMarginUnion

Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy FK Financial Statement Version
SemanticTag FK Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate FK 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
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 Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
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 Amount in Global Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
PlanAmountInTransactionCrcy Amount in Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1 Plan Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2 Plan Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3 Plan Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4 Plan Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5 Plan Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6 Plan Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7 Plan Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8 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 FK 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
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalPeriod Fiscal Period POPER
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
LedgerFiscalYear Ledger Fiscal Year GJAHR
AssignmentReference Assignment Reference ZUONR
ClearingAccountingDocument Clearing Journal Entry BELNR
SourceReferenceDocument Source Document Reference Document Number AWREF
TransactionTypeDetermination Transaction Key CHAR3
PlanningCategory Plan Category FCOM_CATEGORY
IsSimulation null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_GROSSMARGINUNION.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_GROSSMARGINUNION.MANDT == T003.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_GROSSMARGINUNION.BASEUNIT == T006.MSEHI
  • P_GROSSMARGINUNION.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • P_GROSSMARGINUNION.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_GROSSMARGINUNION.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_GROSSMARGINUNION.BILLTOPARTY == KNA1.KUNNR
  • P_GROSSMARGINUNION.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • P_GROSSMARGINUNION.BUSINESSAREA == TGSB.GSBER
  • P_GROSSMARGINUNION.MANDT == TGSB.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_GROSSMARGINUNION.CHARTOFACCOUNTS == T004.KTOPL
  • P_GROSSMARGINUNION.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_GROSSMARGINUNION.COMPANYCODE == T001.BUKRS
  • P_GROSSMARGINUNION.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_GROSSMARGINUNION.COMPANYCODECURRENCY == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_GROSSMARGINUNION.CONTROLLINGAREA == TKA01.KOKRS
  • P_GROSSMARGINUNION.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • Client
  • P_GROSSMARGINUNION.[column in domain "DATBI"] == CSKS.DATBI
  • P_GROSSMARGINUNION.COSTCENTER == CSKS.KOSTL
  • P_GROSSMARGINUNION.CONTROLLINGAREA == CSKS.KOKRS
  • P_GROSSMARGINUNION.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • P_GROSSMARGINUNION.CUSTOMER == KNA1.KUNNR
  • P_GROSSMARGINUNION.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • P_GROSSMARGINUNION.CUSTOMERGROUP == T151.KDGRP
  • P_GROSSMARGINUNION.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_GROSSMARGINUNION.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_GROSSMARGINUNION.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • P_GROSSMARGINUNION.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_GROSSMARGINUNION.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_GROSSMARGINUNION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_GROSSMARGINUNION.MANDT == TVTW.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_GROSSMARGINUNION.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_GROSSMARGINUNION.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_GROSSMARGINUNION.FISCALYEARVARIANT == T009.PERIV
  • P_GROSSMARGINUNION.MANDT == T009.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • P_GROSSMARGINUNION.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_GROSSMARGINUNION.COMPANYCODE == SKB1.BUKRS
  • P_GROSSMARGINUNION.GLACCOUNT == SKB1.SAKNR
  • P_GROSSMARGINUNION.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_GROSSMARGINUNION.GLOBALCURRENCY == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Product Sold Group
  • Product Sold Group
  • Client
  • P_GROSSMARGINUNION.MATERIALGROUP == T023.MATKL
  • P_GROSSMARGINUNION.MANDT == T023.MANDT
Operating Concern
  • Operating Concern
  • Client
  • P_GROSSMARGINUNION.OPERATINGCONCERN == TKEB.ERKRS
  • P_GROSSMARGINUNION.MANDT == TKEB.MANDT
Division
  • Division
  • Client
  • P_GROSSMARGINUNION.ORGANIZATIONDIVISION == TSPA.SPART
  • P_GROSSMARGINUNION.MANDT == TSPA.MANDT
Plant
  • Plant
  • Client
  • P_GROSSMARGINUNION.PLANT == T001W.WERKS
  • P_GROSSMARGINUNION.MANDT == T001W.MANDT
Posting Key
  • Posting Key
  • Client
  • P_GROSSMARGINUNION.POSTINGKEY == TBSL.BSCHL
  • P_GROSSMARGINUNION.MANDT == TBSL.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • P_GROSSMARGINUNION.[column in domain "DATBI"] == CEPC.DATBI
  • P_GROSSMARGINUNION.CONTROLLINGAREA == CEPC.KOKRS
  • P_GROSSMARGINUNION.PROFITCENTER == CEPC.PRCTR
  • P_GROSSMARGINUNION.MANDT == CEPC.MANDT
Reference Document Type P_GROSSMARGINUNION.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Sales District
  • Client
  • P_GROSSMARGINUNION.SALESDISTRICT == T171.BZIRK
  • P_GROSSMARGINUNION.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_GROSSMARGINUNION.SALESORGANIZATION == TVKO.VKORG
  • P_GROSSMARGINUNION.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_GROSSMARGINUNION.SEGMENT == FAGL_SEGM.SEGMENT
  • P_GROSSMARGINUNION.MANDT == FAGL_SEGM.MANDT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Ship-to Party
  • Ship-to Party
  • Client
  • P_GROSSMARGINUNION.SHIPTOPARTY == KNA1.KUNNR
  • P_GROSSMARGINUNION.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • P_GROSSMARGINUNION.SOLDMATERIAL == MARA.MATNR
  • P_GROSSMARGINUNION.MANDT == MARA.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Source Document Type P_GROSSMARGINUNION.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • P_GROSSMARGINUNION.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_GROSSMARGINUNION.SPECIALGLCODE == T074U.UMSKZ
  • P_GROSSMARGINUNION.MANDT == T074U.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_GROSSMARGINUNION.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_GROSSMARGINUNION.MANDT == TCURC.MANDT