FDS2

CM&F Line Items in SD Documents (fromr Release 4.0) | #transactional | Component: Basic Functions
Column Name Description
MANDT FK Client
AWTYP Reference procedure
AWREF Reference document number
AWORG Reference Organizational Units
AWSYS Logical System
AWPOS Reference line item
VRGNG FK Business Transaction
ORVTP Value type of purchase order/sales order values Show values
BUKRS FK Company Code
GSBER FK Business Area
KUNRG FK Payer
FDGRP FK Planning Group
FDTAG Planning Date
TWAER FK Transaction Currency
Column Name Description
💲 Transaction Currency (TWAER):
WRSHB Amount in Planning Currency
💲 Currency Key (T001.WAERS):
DMSHB Amount in local currency
Column Name Description
📏 Base Unit of Measure for BOM (BASME):
OAUME Open orders quantity in base unit of measure
Column Name Description
FDTAG Planning Date
Column Name Description
ORVTP Value type of purchase order/sales order values Show values
Column Name Description Domain name
PRCTR Profit Center PRCTR
GEBER Fund BP_GEBER
GRANT_NBR Grant GM_GRANT_NBR
Master Data Relations Join Conditions
Base Unit of Measure for BOM
  • FDS2.MANDT == T006.MANDT
  • FDS2.BASME == T006.MSEHI
Company Code
  • FDS2.MANDT == T001.MANDT
  • FDS2.BUKRS == T001.BUKRS
Planning Group
  • FDS2.MANDT == T035.MANDT
  • FDS2.FDGRP == T035.GRUPP
Planning Level
  • FDS2.MANDT == T036.MANDT
  • FDS2.FDLEV == T036.EBENE
Business Area
  • FDS2.MANDT == TGSB.MANDT
  • FDS2.GSBER == TGSB.GSBER
Payer
  • FDS2.MANDT == KNA1.MANDT
  • FDS2.KUNRG == KNA1.KUNNR
Client FDS2.MANDT == T000.MANDT
Transaction Currency
  • FDS2.MANDT == TCURC.MANDT
  • FDS2.TWAER == TCURC.WAERS