VKDFS

SD Index: Billing Initiator | #index | Component: Sales
Column Name Description
MANDT FK Client
FKTYP Billing Category Show values
VKORG FK Sales Organization
FKDAT Billing Date
KUNNR FK Sold-to Party
FKART FK Billing Type
LLAND FK Destination Country/Region
VBELN Sales and Distribution Document Number
Column Name Description
💲 SD Document Currency (WAERK):
NETWR Net Value in Document Currency
Column Name Description
Column Name Description
FKDAT Billing Date
ERDAT Date on which the record was created
ERZET Entry time
Column Name Description
FKTYP Billing Category Show values
VBTYP SD Document Category Show values
PDSTK POD Status on Header Level Show values
DRAFT_TYPE Draft mode Show values
ADDR_TYPE Address type (1=Organization, 2=Person, 3=Contact person) Show values
Column Name Description Domain name
ADRNR Address number of the sold-to party ADRNR
SORTKRI Sort Criterion CHAR20
BDR_REF Source document on which a billing document request is based VBELN
BDR_REF_LOGSYS Logical system containing source document of BDR LOGSYS
DBD_REF Draft Billing Document Reference VBELN
VBART Sales and Distribution Document Type VBART
SOLUTION_ORDER_ID Solution Order CRM_OBJECT_ID
ERNAM Name of Person Responsible for Creating the Object USNAM
DUMMY_SDBILLINDEX_INCL_EEW_PS Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Client
  • Person Number
  • VKDFS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • VKDFS.[column in domain "AD_NATION"] == ADRP.NATION
  • VKDFS.MANDT == ADRP.CLIENT
  • VKDFS.ADRNP == ADRP.PERSNUMBER
Billing Block in SD Document
  • VKDFS.MANDT == TVFS.MANDT
  • VKDFS.FAKSK == TVFS.FAKSP
Billing Type
  • VKDFS.MANDT == TVFK.MANDT
  • VKDFS.FKART == TVFK.FKART
Sold-to Party
  • VKDFS.MANDT == KNA1.MANDT
  • VKDFS.KUNNR == KNA1.KUNNR
Destination Country/Region
  • Destination Country/Region
  • Client
  • VKDFS.LLAND == T005.LAND1
  • VKDFS.MANDT == T005.MANDT
Client VKDFS.MANDT == T000.MANDT
Division
  • VKDFS.MANDT == TSPA.MANDT
  • VKDFS.SPART == TSPA.SPART
Sales Organization
  • VKDFS.MANDT == TVKO.MANDT
  • VKDFS.VKORG == TVKO.VKORG
Shipping Point / Receiving Point
  • VKDFS.MANDT == TVST.MANDT
  • VKDFS.VSTEL == TVST.VSTEL
Distribution Channel
  • Distribution Channel
  • Client
  • VKDFS.VTWEG == TVTW.VTWEG
  • VKDFS.MANDT == TVTW.MANDT
SD Document Currency
  • VKDFS.MANDT == TCURC.MANDT
  • VKDFS.WAERK == TCURC.WAERS