P_SemTagAndSubLedgerItem

G/L Account Line Item Union by SemTag and SLALITTYPE | view: PSEMTAGSLITP | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, PROJ, HRRP_FSV_DIR, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
SemanticTag Semantic Tag of a Hierarchy Node
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
BilledRevenueAmtInCoCodeCrcy Billed Revenue Amount in Company Code Currency
SalesDeductionAmtInCoCodeCrcy Sales Deduction Amount in Company Code Currency
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment Amount in Company Code Currency
RecognizedRevnAmtInCCCrcy Recognized Revenue Amount in Company Code Currency
VarblCOGSAmtInCCCrcy COGS - Variable Amount in Company Code Currency
ContrbnMargin1AmtInCoCodeCrcy COGS - Contribution Margin 1 Amount in Company Code Currency
FxdCOGSAmtInCCCrcy COGS - Fixed Amount in Company Code Currency
PriceDifferenceAmtInCCCrcy COGS - Price Differences Amount in Company Code Currency
ContrbnMargin2AmtInCoCodeCrcy COGS - Contribution Margin 2 Amount in Company Code Currency
AdminOverheadAmtInCoCodeCrcy COGS - Administration Overhead Amt in Company Code Currency
SalesOverheadAmtInCoCodeCrcy COGS - Sales Overhead Amount in Company Code Currency
MarketingOvhdAmtInCoCodeCrcy COGS - Marketing Overhead Amount in Company Code Currency
RnDOverheadAmtInCCCrcy COGS - Research and Dev Overhead Amount in Company Code Crcy
ContrbnMargin3AmtInCoCodeCrcy COGS - Contribution Margin 3 Amount in Company Code Currency
InptPriceVarcAmtInCoCodeCrcy Input Price Variance Amount in Company Code Currency
InptQtyVarcAmtInCoCodeCrcy Input Quantity Variance Amount in Company Code Currency
RsceUsgeVarcAmtInCoCodeCrcy Resource Usage Variance Amount in Company Code Currency
LotSizeVarcAmtInCoCodeCrcy Lot Size Variance Amount in Company Code Currency
InputRmngVarcAmtInCoCodeCrcy Input Remaining Variance Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
BilledRevenueAmtInGlobCrcy Actual Revenue
SalesDeductionAmountInGlobCrcy Sales Deduction
RevenueAdjustAmtInGlobCrcy Revenue Adjustment
RecognizedRevnAmtInGlobCrcy Recognized Revenue
VarblCOGSAmtInGlobCrcy Cost of Goods Sold - Variable
ContrbnMargin1AmtInGlobCrcy Contribution Margin I
FxdCOGSAmtInGlobCrcy Cost of Goods Sold - Fixed
PriceDifferenceAmtInGlobCrcy Price Differences
ContrbnMargin2AmtInGlobCrcy Contribution Margin II
AdminOverheadAmtInGlobCrcy Administration Overhead
SalesOverheadAmtInGlobCrcy Sales Overhead
MarketingOverheadAmtInGlobCrcy Marketing Overhead
RnDOverheadAmtInGlobCrcy Research and Development Overhead
ContrbnMargin3AmtInGlobCrcy Contribution Margin III
InptPriceVarcAmtInGlobCrcy Input Price Variance Amount in Global Currency
InptQtyVarcAmtInGlobCrcy Input Quantity Variance Amount in Global Currency
RsceUsgeVarcAmtInGlobCrcy Resource Usage Variance Amount in Global Currency
LotSizeVarcAmtInGlobCrcy Lot Size Variance Amount in Global Currency
InputRmngVarcAmtInGlobCrcy Input Remaining Variance Amount in Global Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
BilledValnQtyInCostSourceUnit Billed Quantity
Column Name Description
Column Name Description
LineIsSemTagCalculated Indicator: Calculated by Semantic Tag Show values
Column Name Description Domain name
SalesOrderItem Sales Order Item POSNR
SalesDocumentItem Sales Document Item POSNR
ConditionContract Condition Contract WCB_COCO_NUM
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
OrderType Order Type AUFART
Project Project FIS_PROJECT_NO_CONV
WBSElement WBS Element FIS_WBS_NO_CONV
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.BASEUNIT == T006.MSEHI
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T006.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.BILLTOPARTY == KNA1.KUNNR
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == KNA1.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Company Code
  • Company Code
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.COMPANYCODE == T001.BUKRS
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TKA01.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.CONTROLLINGAREA == TKA01.KOKRS
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T006.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Customer Number
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.CUSTOMER == KNA1.KUNNR
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T151.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T005.MANDT
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T016.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TVTW.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TCURC.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.FUNCTIONALAREA == TFKB.FKBER
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TFKB.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_SEMTAGANDSUBLEDGERITEM.COMPANYCODE == SKB1.BUKRS
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == SKB1.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TCURC.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Order ID
  • Order ID
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.ORDERID == AUFK.AUFNR
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TSPA.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T001W.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.PLANT == T001W.WERKS
Profit Center
  • ?
  • Client
  • Profit Center
  • Controlling Area
  • P_SEMTAGANDSUBLEDGERITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == CEPC.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.PROFITCENTER == CEPC.PRCTR
  • P_SEMTAGANDSUBLEDGERITEM.CONTROLLINGAREA == CEPC.KOKRS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == AUFK.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.PROJECTNETWORK == AUFK.AUFNR
Sales District
  • Client
  • Sales District
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T171.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Sales Organization
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.SALESORGANIZATION == TVKO.VKORG
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == FAGL_SEGM.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Client
  • Ship-to Party
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == KNA1.MANDT
  • P_SEMTAGANDSUBLEDGERITEM.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Product Sold
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.SOLDPRODUCT == MARA.MATNR
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_SEMTAGANDSUBLEDGERITEM.SOLDPRODUCTGROUP == T023.MATKL
  • P_SEMTAGANDSUBLEDGERITEM.MANDT == T023.MANDT
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Subledger-Specific Line Item Type P_SEMTAGANDSUBLEDGERITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE