P_ACMContractHeader

Trading Contract Header Information | view: PCONTRHEAD | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management
Tables used: WBHK
Column Name Description
Column Name Description
💲 Currency of Trading Contract (tkwaers):
netwr_sd 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
erzeit Time at Which Record Was Added
aedat Last Changed On
aezeit Time of Change
bstdk Customer Reference Date
budat Document Date
prsdt_sd Date for Pricing and Exchange Rate
audat Document Date (Date Received/Sent)
angdt_sd Quotation/Inquiry is Valid From
bnddt_sd Date Until Which Bid/Quotation is Binding (Valid-To Date)
mahdt_sd Last Customer Contact Date
cmfre Release date of the document determined by credit management
cmnup Date of Next Credit Check of Document
cmngv Next date
wkurs_dat Exchange Rate Date in Trading Contract
_dataaging Data Filter Value for Data Aging
guebg Valid-From Date (Outline Agreements, Product Proposals)
gueen Valid-To Date (Outline Agreements, Product Proposals)
Column Name Description
ft_header_com Document is Complete Show values
complete Document is Complete Show values
autlf_sd Complete Delivery Defined for Each Sales Order? Show values
vbtyp_sd SD Document Category Show values
quan_complete Trading Contract: Quantities In Document Are Complete Show values
wbpch Trading Contract Last Chngd Flag (Customer, Trader, Suppl.) Show values
tc_released Release Status for Follow-On Document Generation Show values
tccat Trading Contract Category Show values
xegdr Indicator: Triangular Deal Within the EU Show values
use_case Use Case Type Show values
succ_arch Network Archived Show values
pricing_type Definition of Pricing Procedure in Trading Contract Show values
created_from Source Document Type Show values
consol_it_exist Consolidated item exists Show values
set_variant Business Process Variant for Contract Settlement Show values
in_approval TC Approval Started Show values
purpose Purpose of Trading Contract Show values
pf_status Status for Processing of Follow-on document Show values
Column Name Description Domain name
tkonn Trading Contract TKONN
tkrate Exchange Rate for Price Determination KURRF
ernam Name of Person Responsible for Creating the Object USNAM
aenam Name of Person Who Changed Object USNAM
tksachb Trading Contract: Person Responsible UNAME
bstnk Customer Reference BSTNK
tkrate_sd GT Exchange Rate Sales Order Currency / Local Currency KURRF
akprz Depreciation percentage for financial document processing PRZ32
exnum Number of foreign trade data in MM and SD documents EXNUM
submi_sd Collective Number (SD) CHAR10
bstzd_sd Purchase order number supplement BSTZD
ihrez_sd Your Reference TEXT12
bname_sd Name of orderer NAME
telf1_sd Telephone Number TELF1
mahza_sd Number of Contacts from the Customer PACK2
taxk1_sd Alternative Tax Classification TAXKD
taxk2_sd Tax Classification 2 for Customer TAXKD
taxk3_sd Tax Classification 3 for Customer TAXKD
taxk4_sd Tax Classification 4 for Customer TAXKD
taxk5_sd Tax Classification 5 for Customer TAXKD
taxk6_sd Tax Classification 6 for Customer TAXKD
taxk7_sd Tax Classification 7 for Customer TAXKD
taxk8_sd Tax Classification 8 for Customer TAXKD
taxk9_sd Tax Classification 9 for Customer TAXKD
xblnr_sd Reference Document Number XBLNR1
auart Sales Document Type AUART
ctlpc Credit Management: Risk Category CTLPC_CM
kurrf Exchange Rate for Postings to Financial Accounting KURRF
tkonn_ex External Identifier in Trading Contract TKONN_EX
dummy_wbhk_incl_eew_ps Dummy Data Element for Trading Contract Header Extensibility WBHK_INCL_EEW
knumv_sd Number of the Document Condition KNUMV
kalsm_sd Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
last_change_uuid UUID in X form (binary) SYSUUID
kalsm_ch Search Procedure for Batch Determination KALSM
pf_last_action Last Action code for Processing of Follow-on document WB2_TC_PROCESSING_ACTION
pf_last_order Last Executed sequence for Processing of Follow-on document WB2_TC_PROCESSING_ORDER
Master Data Relations Join Conditions
Usage Indicator
  • Client
  • Usage Indicator
  • P_ACMCONTRACTHEADER.MANDT == TVLV.MANDT
  • P_ACMCONTRACTHEADER.ABRVW == TVLV.ABRVW
Check Payment Guarantee Procedure
  • Client
  • Payment Guarantee Procedure
  • P_ACMCONTRACTHEADER.MANDT == T691M.MANDT
  • P_ACMCONTRACTHEADER.ABSSC == T691M.ABSSC
Check Country
  • Client
  • Tax Departure Country/Region
  • P_ACMCONTRACTHEADER.MANDT == T005.MANDT
  • P_ACMCONTRACTHEADER.ANDTX_SD == T005.LAND1
Check Sales Order Reason
  • Order Reason (Reason for the Business Transaction)
  • Client
  • P_ACMCONTRACTHEADER.AUGRU == TVAU.AUGRU
  • P_ACMCONTRACTHEADER.MANDT == TVAU.MANDT
Check Customer Order Type
  • Client
  • Customer Purchase Order Type
  • P_ACMCONTRACTHEADER.MANDT == T176.MANDT
  • P_ACMCONTRACTHEADER.BSARK_SD == T176.BSARK
Check Application Status
  • Client
  • Application Status of Trading Contract
  • P_ACMCONTRACTHEADER.MANDT == TB2BA.MANDT
  • P_ACMCONTRACTHEADER.BTBSTA == TB2BA.BTBSTA
Check Currency
  • Client
  • Currency key of credit control area
  • P_ACMCONTRACTHEADER.MANDT == TCURC.MANDT
  • P_ACMCONTRACTHEADER.CMWAE == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • P_ACMCONTRACTHEADER.MANDT == T001.MANDT
  • P_ACMCONTRACTHEADER.COMPANY_CODE == T001.BUKRS
Check Billing Block
  • Billing Block in SD Document
  • Client
  • P_ACMCONTRACTHEADER.FAKSK_SD == TVFS.FAKSP
  • P_ACMCONTRACTHEADER.MANDT == TVFS.MANDT
Check
  • Customer Credit Group
  • Client
  • Credit control area
  • P_ACMCONTRACTHEADER.GRUPP == T691B.GRUPP
  • P_ACMCONTRACTHEADER.MANDT == T691B.MANDT
  • P_ACMCONTRACTHEADER.KKBER == T691B.KKBER
Check Credit Control Area
  • Client
  • Credit control area
  • P_ACMCONTRACTHEADER.MANDT == T014.MANDT
  • P_ACMCONTRACTHEADER.KKBER == T014.KKBER
Check Customer
  • Client
  • Customer's Account Number with Credit Limit Reference
  • P_ACMCONTRACTHEADER.MANDT == KNA1.MANDT
  • P_ACMCONTRACTHEADER.KNKLI == KNA1.KUNNR
Check Controlling Area
  • Controlling Area
  • Client
  • P_ACMCONTRACTHEADER.KOKRS == TKA01.KOKRS
  • P_ACMCONTRACTHEADER.MANDT == TKA01.MANDT
Check Customer Number
  • Sold-to Party
  • Client
  • P_ACMCONTRACTHEADER.KUNNR == KNA1.KUNNR
  • P_ACMCONTRACTHEADER.MANDT == KNA1.MANDT
Check Exchange Rate Types
  • Exchange Rate Type
  • Client
  • P_ACMCONTRACTHEADER.KURST == TCURV.KURST
  • P_ACMCONTRACTHEADER.MANDT == TCURV.MANDT
Check Exchange Rate Types
  • Client
  • Exchange Rate Type
  • P_ACMCONTRACTHEADER.MANDT == TCURV.MANDT
  • P_ACMCONTRACTHEADER.KURST_SD == TCURV.KURST
Check Customer Group 1
  • Customer Group 1
  • Client
  • P_ACMCONTRACTHEADER.KVGR1_SD == TVV1.KVGR1
  • P_ACMCONTRACTHEADER.MANDT == TVV1.MANDT
Check Customer Group 2
  • Customer Group 2
  • Client
  • P_ACMCONTRACTHEADER.KVGR2_SD == TVV2.KVGR2
  • P_ACMCONTRACTHEADER.MANDT == TVV2.MANDT
Check Customer Group 3
  • Client
  • Customer Group 3
  • P_ACMCONTRACTHEADER.MANDT == TVV3.MANDT
  • P_ACMCONTRACTHEADER.KVGR3_SD == TVV3.KVGR3
Check Customer Group 4
  • Customer Group 4
  • Client
  • P_ACMCONTRACTHEADER.KVGR4_SD == TVV4.KVGR4
  • P_ACMCONTRACTHEADER.MANDT == TVV4.MANDT
Check Customer Group 5
  • Client
  • Customer Group 5
  • P_ACMCONTRACTHEADER.MANDT == TVV5.MANDT
  • P_ACMCONTRACTHEADER.KVGR5_SD == TVV5.KVGR5
Tax Departure Country/Region
  • Client
  • Tax Departure Country/Region
  • P_ACMCONTRACTHEADER.MANDT == T005.MANDT
  • P_ACMCONTRACTHEADER.LANDTX == T005.LAND1
Check Letter of Credit Number
  • Client
  • Financial doc. processing: Internal financial doc. number
  • P_ACMCONTRACTHEADER.MANDT == AKKP.MANDT
  • P_ACMCONTRACTHEADER.LCNUM == AKKP.LCNUM
Check Blocking Reason for Vendor Billing Document
  • Client
  • Blocking Reason Document Header
  • P_ACMCONTRACTHEADER.MANDT == TMFS.MANDT
  • P_ACMCONTRACTHEADER.LFSPG == TMFS.LFSPG
Check Delivery Block
  • Client
  • Delivery Block (Document Header)
  • P_ACMCONTRACTHEADER.MANDT == TVLS.MANDT
  • P_ACMCONTRACTHEADER.LIFSK_SD == TVLS.LIFSP
Logical System P_ACMCONTRACTHEADER.LOGSYS == TBDLS.LOGSYS
Check Processor Group
  • Client
  • Credit control area
  • Credit Representative Group for Credit Management
  • P_ACMCONTRACTHEADER.MANDT == T024B.MANDT
  • P_ACMCONTRACTHEADER.KKBER == T024B.KKBER
  • P_ACMCONTRACTHEADER.SBGRP == T024B.SBGRP
Check Currency
  • Client
  • SD Document Currency
  • P_ACMCONTRACTHEADER.MANDT == TCURC.MANDT
  • P_ACMCONTRACTHEADER.SDWRS == TCURC.WAERS
Check Division
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • P_ACMCONTRACTHEADER.MANDT == TVTA.MANDT
  • P_ACMCONTRACTHEADER.SPART == TVTA.SPART
  • P_ACMCONTRACTHEADER.VTWEG == TVTA.VTWEG
  • P_ACMCONTRACTHEADER.VKORG == TVTA.VKORG
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • P_ACMCONTRACTHEADER.MANDT == T005.MANDT
  • P_ACMCONTRACTHEADER.STCEG_L == T005.LAND1
Check Country
  • Client
  • Tax Destination Country/Region
  • P_ACMCONTRACTHEADER.MANDT == T005.MANDT
  • P_ACMCONTRACTHEADER.STCEG_L_SD == T005.LAND1
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_ACMCONTRACTHEADER.MANDT == TB2BE.MANDT
  • P_ACMCONTRACTHEADER.TCTYP == TB2BE.TCTYP
Trading Execution Workbench Type
  • Client
  • Trading Execution Workbench Type
  • P_ACMCONTRACTHEADER.MANDT == TEWTYPE.MANDT
  • P_ACMCONTRACTHEADER.TEW_TYPE == TEWTYPE.TEW_TYPE
Check Currency
  • Client
  • Currency of Trading Contract
  • P_ACMCONTRACTHEADER.MANDT == TCURC.MANDT
  • P_ACMCONTRACTHEADER.TKWAERS == TCURC.WAERS
Check Sales Group
  • Client
  • Sales office
  • Sales group
  • P_ACMCONTRACTHEADER.MANDT == TVBVK.MANDT
  • P_ACMCONTRACTHEADER.VKBUR == TVBVK.VKBUR
  • P_ACMCONTRACTHEADER.VKGRP == TVBVK.VKGRP
Check Sales Organization
  • Client
  • Sales Organization
  • P_ACMCONTRACTHEADER.MANDT == TVKO.MANDT
  • P_ACMCONTRACTHEADER.VKORG == TVKO.VKORG
Check Shipping Conditions
  • Client
  • Shipping Conditions
  • P_ACMCONTRACTHEADER.MANDT == TVSB.MANDT
  • P_ACMCONTRACTHEADER.VSBED_SD == TVSB.VSBED
Check Distribution Channel
  • Client
  • Distribution Channel
  • Sales Organization
  • P_ACMCONTRACTHEADER.MANDT == TVKOV.MANDT
  • P_ACMCONTRACTHEADER.VTWEG == TVKOV.VTWEG
  • P_ACMCONTRACTHEADER.VKORG == TVKOV.VKORG
Customer Number
  • Client
  • Customer Number
  • P_ACMCONTRACTHEADER.MANDT == KNA1.MANDT
  • P_ACMCONTRACTHEADER.WE_KUNNR == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Check Sales Group
  • Client
  • Sales office
  • Division
  • Distribution Channel
  • Sales Organization
  • P_ACMCONTRACTHEADER.MANDT == TVKBZ.MANDT
  • P_ACMCONTRACTHEADER.VKBUR == TVKBZ.VKBUR
  • P_ACMCONTRACTHEADER.SPART == TVKBZ.SPART
  • P_ACMCONTRACTHEADER.VTWEG == TVKBZ.VTWEG
  • P_ACMCONTRACTHEADER.VKORG == TVKBZ.VKORG