VC_INTEGRATION_VBAK

Extraction for VBAK | view: VCIVBAK | TRAN | Extraction: Full or Incremental | Component: Configuration and Pricing Services
Tables used: VBAK
Column Name Description
VBELN Sales Document
Column Name Description
💲 SD Document Currency (WAERK):
NETWR Net Value of the Sales Order in Document Currency
💲 Currency key of credit control area (CMWAE):
AMTBL Released credit value of the document
Column Name Description
Column Name Description
ERDAT Date on which the record was created
ERZET Entry time
ANGDT Quotation/Inquiry is Valid From
BNDDT Date Until Which Bid/Quotation is Binding (Valid-To Date)
AUDAT Document Date (Date Received/Sent)
GWLDT Guarantee date
GUEBG Valid-From Date (Outline Agreements, Product Proposals)
GUEEN Valid-To Date (Outline Agreements, Product Proposals)
VDATU Requested Delivery Date
BSTDK Customer Reference Date
MAHDT Last Customer Contact Date
AEDAT Last Changed On
CMFRE Release date of the document determined by credit management
CMNUP Date of Next Credit Check of Document
CMNGV Next date
ABHOD Pick-Up Date
ABHOV Pick-Up Time
ABHOB Pick-Up Time
VZEIT Proposed schedule line time (local with ref. to sales org.)
DAT_FZAU Cml delivery order qty date
FMBDAT Material Staging/Availability Date
_DATAAGING Data Filter Value for Data Aging
ZABDATH Annexing base date
PSM_BUDAT Posting Date in the Document
FSH_CANDATE Cancellation Date
Column Name Description
VBTYP SD Document Category Show values
TRVOG Transaction Group Show values
VPRGR Proposed date type Show values
AUTLF Complete Delivery Defined for Each Sales Order? Show values
VBKLT SD document indicator Show values
AWAHR Sales probability Show values
ABDIS MRP for delivery schedule types Show values
VGTYP Document Category of Preceding SD Document Show values
ABRUF_PART Check partner authorizations Show values
XEGDR Indicator: Triangular Deal Within the EU Show values
ENQUEUE_GRP Block master contr. until all lower level contracts updated Show values
CONT_DG Indicator: Document contains dangerous goods Show values
APM_APPROVAL_STATUS Document Approval Status Show values
ABSTK Rejection Status (All Items) Show values
BESTK Delivery Confirmation Status (All Items) Show values
CMPSC Status of Credit Check Against Maximum Document Value Show values
CMPSD Status of Credit Check Against Terms of Payment Show values
CMPSI Status of Credit Check Against Financial Document Show values
CMPSJ Status of Credit Check Against Export Credit Insurance Show values
CMPSK Status of Credit Check Against Payment Card Authorization Show values
CMPS_CM Status of Credit Check SAP Credit Management Show values
CMPS_TE Status of Technical Error SAP Credit Management Show values
CMGST Overall Status of Credit Checks Show values
COSTA Purchasing Confirmation Status Show values
DCSTK Delay Status (All Items) Show values
FKSAK Order-Related Billing Status (All Items) Show values
FMSTK Status Funds Management Show values
FSSTK Billing Block Status (All Items) Show values
GBSTK Overall Processing Status (Header/All Items) Show values
LFGSK Overall Delivery Status (All Items) Show values
LFSTK Delivery Status (All Items) Show values
LSSTK Overall Delivery Block Status (All Items) Show values
RFGSK Overall Reference Status (All Items) Show values
RFSTK Reference Status (All Items) Show values
SPSTG Overall Block Status (Header) Show values
TRSTA Transportation Planning Status (Header) Show values
UVALL Incompletion Status (Header) Show values
UVALS Incompletion Status (All Items) Show values
UVFAK Billing Incompletion Status (Header) Show values
UVFAS Billing Incompletion Status (All Items) Show values
UVPRS Pricing Incompletion Status (All Items) Show values
UVVLK Delivery Incompletion Status (Header) Show values
UVVLS Delivery Incompletion Status (All Items) Show values
UVK01 Customer reserves 1: Header status Show values
UVK02 Customer reserves 2: Header status Show values
UVK03 Customer reserves 3: Header status Show values
UVK04 Custmer reserves 4: Header status Show values
UVK05 Customer reserves 5: Header status Show values
UVS01 Customer reserves 1: Sum of all items Show values
UVS02 Customer reserves 2: Sum of all items Show values
UVS03 Customer reserves 3: Sum of all items Show values
UVS04 Customer reserves 4: Sum of all items Show values
UVS05 Customer reserves 5: Sum of all items Show values
WBSTK Goods Movement Status (All Items) Show values
TOTAL_EMCST Embargo Status (All Items) Show values
TOTAL_SLCST Screening Status (All Items) Show values
TOTAL_LCCST Legal Control Status Show values
TOTAL_PCSTA Product Marketability Status (All Items) Show values
TOTAL_DGSTA Dangerous Goods Status (All Items) Show values
TOTAL_SDSSTA Safety Data Sheet Status (All Items) Show values
DP_CLEAR_STA_HDR Down Payment Status Show values
AD01FAREG Rule for Billing Show values
FSH_CQ_CHECK Requirement Relevance for Contract Show values
FSH_OS_STG_CHANGE Order Scheduling Strategy Fields Changed Manually Show values
J_3GKBAUL ETM-Relevant Indicator Show values
MILL_APPL_ID Application ID Category for Configuration Show values
MULTI Multiple Campaigns/Trade Promotions Active Indicator Show values
SPPAYM Payment Form for Special Payment Method Show values
Column Name Description Domain name
SUBMI Collective Number (SD) CHAR10
KNUMV Number of the Document Condition KNUMV
VBKLA Original system with release and transaction control CHAR9
KTEXT Search term for product proposal TEXT40
BSTNK Customer Reference BSTNK
BSTZD Purchase order number supplement BSTZD
IHREZ Your Reference TEXT12
MAHZA Number of Contacts from the Customer PACK2
KOSTL Cost Center KOSTL
STAFO Update Group for statistics update STAFO
GRUPP Customer Credit Group GRUPP_CM
VGBEL Document number of the reference document VBELN
TAXK1 Alternative Tax Classification TAXKD
TAXK2 Tax Classification 2 for Customer TAXKD
TAXK3 Tax Classification 3 for Customer TAXKD
TAXK4 Tax Classification 4 for Customer TAXKD
TAXK5 Tax Classification 5 for Customer TAXKD
TAXK6 Tax Classification 6 for Customer TAXKD
TAXK7 Tax Classification 7 for Customer TAXKD
TAXK8 Tax Classification 8 for Customer TAXKD
TAXK9 Tax Classification 9 for Customer TAXKD
XBLNR Reference Document Number XBLNR1
ZUONR Assignment Number ZUONR
AGRZR Accrual period for order-related billing docs.to be accrued NUM2
VBELN_GRP Master Contract Number VBELN
VSNMR_V Sales document version number VSNMR
HANDLE International unique key for VBAK-VBELN SYSUUID_22
CRM_GUID Character field, length 70 CHAR70
UPD_TMSTMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
MSR_ID Process Identification Number MSR_PROCESS_ID
TM_CTRL_KEY Control Key for Document Transfer to TM
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR
HANDOVERLOC Location for a physical handover of goods HANDOVER_LOC
EXT_BUS_SYST_ID External Business System ID SLD_BSKEY
EXT_REF_DOC_ID External Document ID CHAR40
EXT_REV_TMSTMP Timestamp for Revision of External Calls TZNTSTMPL
MANEK Manual Completion of Contract MANEK
APCGK_EXTENDH Extended key for annexing package NUMC10
AD01BASDOC Initial document VBELN
LASTVCHR Last voucher number AD04VCHNR
FSH_VRSN_STATUS Snapshot Status FSH_SNST_STATUS
FSH_TRANSACTION Transaction Number FSH_TRANSACTION
FSH_VAS_CG Value-Added Services Customer Group FSH_VAS_CG
LOGSYSB Logical system with which document was created LOGSYS
KALCD Procedure for Campaign Determination KALSM
WTYSC_CLM_HDR Claim header WTYSC_CLM_HDR
Master Data Relations Join Conditions
Usage Indicator
  • Client
  • Usage Indicator
  • VC_INTEGRATION_VBAK.MANDT == TVLV.MANDT
  • VC_INTEGRATION_VBAK.ABRVW == TVLV.ABRVW
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • VC_INTEGRATION_VBAK.APM_APPROVAL_REASON == SDAPMAPRR.APM_APPROVAL_REASON
  • VC_INTEGRATION_VBAK.MANDT == SDAPMAPRR.CLIENT
ID of Reason for Rejection of Approval Request
  • ID of Reason for Rejection of Approval Request
  • Client
  • VC_INTEGRATION_VBAK.APM_REJECTION_REASON == SDAPMREJR.APM_REJECTION_REASON
  • VC_INTEGRATION_VBAK.MANDT == SDAPMREJR.CLIENT
Order type in order header
  • Sales Document Type
  • Client
  • VC_INTEGRATION_VBAK.AUART == TVAK.AUART
  • VC_INTEGRATION_VBAK.MANDT == TVAK.MANDT
Order Number
  • Client
  • Order Number
  • VC_INTEGRATION_VBAK.MANDT == AUFK.MANDT
  • VC_INTEGRATION_VBAK.AUFNR == AUFK.AUFNR
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • VC_INTEGRATION_VBAK.AUGRU == TVAU.AUGRU
  • VC_INTEGRATION_VBAK.MANDT == TVAU.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • VC_INTEGRATION_VBAK.BSARK == T176.BSARK
  • VC_INTEGRATION_VBAK.MANDT == T176.MANDT
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • VC_INTEGRATION_VBAK.MANDT == T001.MANDT
  • VC_INTEGRATION_VBAK.BUKRS_VF == T001.BUKRS
Currency key of credit control area
  • Currency key of credit control area
  • Client
  • VC_INTEGRATION_VBAK.CMWAE == TCURC.WAERS
  • VC_INTEGRATION_VBAK.MANDT == TCURC.MANDT
Credit Management: Risk Category
  • Credit Management: Risk Category
  • Credit control area
  • Client
  • VC_INTEGRATION_VBAK.CTLPC == T691A.CTLPC
  • VC_INTEGRATION_VBAK.KKBER == T691A.KKBER
  • VC_INTEGRATION_VBAK.MANDT == T691A.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • VC_INTEGRATION_VBAK.FAKSK == TVFS.FAKSP
  • VC_INTEGRATION_VBAK.MANDT == TVFS.MANDT
Proposed billing type for an order-related billing document
  • Proposed billing type for an order-related billing document
  • Client
  • VC_INTEGRATION_VBAK.FKARA == TVFK.FKART
  • VC_INTEGRATION_VBAK.MANDT == TVFK.MANDT
Customer Group 10
  • Customer Group 10
  • Client
  • Sales Organization
  • VC_INTEGRATION_VBAK.FSH_KVGR10 == FSH_TVV10.KVGR10
  • VC_INTEGRATION_VBAK.MANDT == FSH_TVV10.MANDT
  • VC_INTEGRATION_VBAK.VKORG == FSH_TVV10.VKORG
Customer Group 6
  • Customer Group 6
  • Client
  • Sales Organization
  • VC_INTEGRATION_VBAK.FSH_KVGR6 == FSH_TVV6.KVGR6
  • VC_INTEGRATION_VBAK.MANDT == FSH_TVV6.MANDT
  • VC_INTEGRATION_VBAK.VKORG == FSH_TVV6.VKORG
Customer Group 7
  • Customer Group 7
  • Client
  • Sales Organization
  • VC_INTEGRATION_VBAK.FSH_KVGR7 == FSH_TVV7.KVGR7
  • VC_INTEGRATION_VBAK.MANDT == FSH_TVV7.MANDT
  • VC_INTEGRATION_VBAK.VKORG == FSH_TVV7.VKORG
Customer Group 8
  • Client
  • Customer Group 8
  • Sales Organization
  • VC_INTEGRATION_VBAK.MANDT == FSH_TVV8.MANDT
  • VC_INTEGRATION_VBAK.FSH_KVGR8 == FSH_TVV8.KVGR8
  • VC_INTEGRATION_VBAK.VKORG == FSH_TVV8.VKORG
Customer Group 9
  • Customer Group 9
  • Client
  • Sales Organization
  • VC_INTEGRATION_VBAK.FSH_KVGR9 == FSH_TVV9.KVGR9
  • VC_INTEGRATION_VBAK.MANDT == FSH_TVV9.MANDT
  • VC_INTEGRATION_VBAK.VKORG == FSH_TVV9.VKORG
Release Rule
  • Client
  • Release Rule
Order Scheduling Strategy
  • Order Scheduling Strategy
  • ?
  • Client
  • VC_INTEGRATION_VBAK.FSH_SS == FSH_OSS.FSH_SS
  • VC_INTEGRATION_VBAK.[column in domain "FSH_APPLICATION"] == FSH_OSS.FSH_APPLICATION
  • VC_INTEGRATION_VBAK.MANDT == FSH_OSS.MANDT
Business Area
  • Business Area
  • Client
  • VC_INTEGRATION_VBAK.GSBER == TGSB.GSBER
  • VC_INTEGRATION_VBAK.MANDT == TGSB.MANDT
Business Area from Cost Center
  • Client
  • Business Area from Cost Center
  • VC_INTEGRATION_VBAK.MANDT == TGSB.MANDT
  • VC_INTEGRATION_VBAK.GSKST == TGSB.GSBER
Hierarchy type for pricing
  • Client
  • Hierarchy type for pricing
  • VC_INTEGRATION_VBAK.MANDT == THIT.MANDT
  • VC_INTEGRATION_VBAK.HITYP_PR == THIT.HITYP
Pricing Procedure in Pricing
  • Pricing Procedure in Pricing
  • ?
  • ?
  • Client
  • VC_INTEGRATION_VBAK.KALSM == T683.KALSM
  • VC_INTEGRATION_VBAK.[column in domain "KAPPL"] == T683.KAPPL
  • VC_INTEGRATION_VBAK.[column in domain "KVEWE"] == T683.KVEWE
  • VC_INTEGRATION_VBAK.MANDT == T683.MANDT
Search Procedure for Batch Determination
  • Search Procedure for Batch Determination
  • ?
  • ?
  • Client
  • VC_INTEGRATION_VBAK.KALSM_CH == T683.KALSM
  • VC_INTEGRATION_VBAK.[column in domain "KAPPL"] == T683.KAPPL
  • VC_INTEGRATION_VBAK.[column in domain "KVEWE"] == T683.KVEWE
  • VC_INTEGRATION_VBAK.MANDT == T683.MANDT
Credit control area
  • Credit control area
  • Client
  • VC_INTEGRATION_VBAK.KKBER == T014.KKBER
  • VC_INTEGRATION_VBAK.MANDT == T014.MANDT
Agreement (various conditions grouped together)
  • Client
  • Agreement (various conditions grouped together)
  • VC_INTEGRATION_VBAK.MANDT == KONA.MANDT
  • VC_INTEGRATION_VBAK.KNUMA == KONA.KNUMA
Controlling Area
  • Controlling Area
  • Client
  • VC_INTEGRATION_VBAK.KOKRS == TKA01.KOKRS
  • VC_INTEGRATION_VBAK.MANDT == TKA01.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • VC_INTEGRATION_VBAK.KUNNR == KNA1.KUNNR
  • VC_INTEGRATION_VBAK.MANDT == KNA1.MANDT
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • VC_INTEGRATION_VBAK.MANDT == TCURV.MANDT
  • VC_INTEGRATION_VBAK.KURST == TCURV.KURST
Customer Group 1
  • Customer Group 1
  • Client
  • VC_INTEGRATION_VBAK.KVGR1 == TVV1.KVGR1
  • VC_INTEGRATION_VBAK.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • VC_INTEGRATION_VBAK.MANDT == TVV2.MANDT
  • VC_INTEGRATION_VBAK.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • VC_INTEGRATION_VBAK.KVGR3 == TVV3.KVGR3
  • VC_INTEGRATION_VBAK.MANDT == TVV3.MANDT
Customer Group 4
  • Client
  • Customer Group 4
  • VC_INTEGRATION_VBAK.MANDT == TVV4.MANDT
  • VC_INTEGRATION_VBAK.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • VC_INTEGRATION_VBAK.MANDT == TVV5.MANDT
  • VC_INTEGRATION_VBAK.KVGR5 == TVV5.KVGR5
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • VC_INTEGRATION_VBAK.LANDTX == T005.LAND1
  • VC_INTEGRATION_VBAK.MANDT == T005.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • VC_INTEGRATION_VBAK.LIFSK == TVLS.LIFSP
  • VC_INTEGRATION_VBAK.MANDT == TVLS.MANDT
Dangerous Goods Management Profile in SD Documents
  • Client
  • Dangerous Goods Management Profile in SD Documents
  • VC_INTEGRATION_VBAK.MANDT == TDGC5.MANDT
  • VC_INTEGRATION_VBAK.PROLI == TDGC5.PROLI
Credit Representative Group for Credit Management
  • Credit control area
  • Client
  • Credit Representative Group for Credit Management
  • VC_INTEGRATION_VBAK.KKBER == T024B.KKBER
  • VC_INTEGRATION_VBAK.MANDT == T024B.MANDT
  • VC_INTEGRATION_VBAK.SBGRP == T024B.SBGRP
Referencing requirement: Procedure
  • Client
  • Referencing requirement: Procedure
  • VC_INTEGRATION_VBAK.MANDT == TVGRPS.MANDT
  • VC_INTEGRATION_VBAK.SCHEME_GRP == TVGRPS.SCHEME
Division in order header
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • VC_INTEGRATION_VBAK.SPART == TVTA.SPART
  • VC_INTEGRATION_VBAK.MANDT == TVTA.MANDT
  • VC_INTEGRATION_VBAK.VKORG == TVTA.VKORG
  • VC_INTEGRATION_VBAK.VTWEG == TVTA.VTWEG
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • VC_INTEGRATION_VBAK.STCEG_L == T005.LAND1
  • VC_INTEGRATION_VBAK.MANDT == T005.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • VC_INTEGRATION_VBAK.MANDT == TCURC.MANDT
  • VC_INTEGRATION_VBAK.STWAE == TCURC.WAERS
Sales group
  • Sales office
  • Client
  • Sales group
  • VC_INTEGRATION_VBAK.VKBUR == TVBVK.VKBUR
  • VC_INTEGRATION_VBAK.MANDT == TVBVK.MANDT
  • VC_INTEGRATION_VBAK.VKGRP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • VC_INTEGRATION_VBAK.MANDT == TVKO.MANDT
  • VC_INTEGRATION_VBAK.VKORG == TVKO.VKORG
Shipping Conditions
  • Shipping Conditions
  • Client
  • VC_INTEGRATION_VBAK.VSBED == TVSB.VSBED
  • VC_INTEGRATION_VBAK.MANDT == TVSB.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • VC_INTEGRATION_VBAK.MANDT == TVKOV.MANDT
  • VC_INTEGRATION_VBAK.VKORG == TVKOV.VKORG
  • VC_INTEGRATION_VBAK.VTWEG == TVKOV.VTWEG
Currency in order header
  • SD Document Currency
  • Client
  • VC_INTEGRATION_VBAK.WAERK == TCURC.WAERS
  • VC_INTEGRATION_VBAK.MANDT == TCURC.MANDT
Annexing package key
  • Annexing package key
  • Client
  • Extended key for annexing package
  • VC_INTEGRATION_VBAK.ZAPCGKH == /ILE/TV01.APCGK
  • VC_INTEGRATION_VBAK.MANDT == /ILE/TV01.MANDT
  • VC_INTEGRATION_VBAK.APCGK_EXTENDH == /ILE/TV01.APCGK_EXTEND
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales office
  • Client
  • Sales Organization
  • Distribution Channel
  • VC_INTEGRATION_VBAK.SPART == TVKBZ.SPART
  • VC_INTEGRATION_VBAK.VKBUR == TVKBZ.VKBUR
  • VC_INTEGRATION_VBAK.MANDT == TVKBZ.MANDT
  • VC_INTEGRATION_VBAK.VKORG == TVKBZ.VKORG
  • VC_INTEGRATION_VBAK.VTWEG == TVKBZ.VTWEG