P_TradingContractHeader

Interface Layer for Trading Ctr Header | view: PTRDGCTRHDR | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: /ACCGO/T_CAKHDR, WBGT, /ACCGO/T_CAKHDR, WBHK, TVTW, TVTWT, TVKOV, TB2BAT, TVTA, TSPAT, TVKO, TVKOT, TB2BE, TB2BET, ADCP, ADRC, ADRP, USR02, USR21, /ACCGO/T_CAK_TYP, USCOMPANY
Column Name Description
tkonn Trading Contract
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
ACMTrdgContrIsStatusClosed Contract Closure with CDOTE Indicator Show values
TradingContractCreditSales Credit Sale Indicator Show values
ACMSignedStatus Signed Status Show values
Column Name Description Domain name
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
resp_trader_id Amending Trader ID /ACCGO/D_TRADER_ID
orig_resp_trader_id Responsible Trader ID /ACCGO/D_TRADER_ID
TradingContractTradeOffice Trade Office BU_PARTNER
bezei Trading Contract: Name of Application Status TEXT40
tctyp_descr Name of Trading Contract Type TEXT40
CreatedBy Full Name of Person TEXT80
DistributionChannelDescr Distribution Channel Description TEXT20
SalesDivisionDescr Name TEXT20
SalesOrgDescr Name TEXT20
PersonResponsible Full Name of Person TEXT80
ChangedBy Full Name of Person TEXT80
Side null
Master Data Relations Join Conditions
Usage Indicator
  • Client
  • Usage Indicator
  • P_TRADINGCONTRACTHEADER.MANDT == TVLV.MANDT
  • P_TRADINGCONTRACTHEADER.ABRVW == TVLV.ABRVW
Check Payment Guarantee Procedure
  • Payment Guarantee Procedure
  • Client
  • P_TRADINGCONTRACTHEADER.ABSSC == T691M.ABSSC
  • P_TRADINGCONTRACTHEADER.MANDT == T691M.MANDT
Check Country
  • Tax Departure Country/Region
  • Client
  • P_TRADINGCONTRACTHEADER.ANDTX_SD == T005.LAND1
  • P_TRADINGCONTRACTHEADER.MANDT == T005.MANDT
Check Sales Order Reason
  • Order Reason (Reason for the Business Transaction)
  • Client
  • P_TRADINGCONTRACTHEADER.AUGRU == TVAU.AUGRU
  • P_TRADINGCONTRACTHEADER.MANDT == TVAU.MANDT
Check Customer Order Type
  • Customer Purchase Order Type
  • Client
  • P_TRADINGCONTRACTHEADER.BSARK_SD == T176.BSARK
  • P_TRADINGCONTRACTHEADER.MANDT == T176.MANDT
Check Application Status
  • Application Status of Trading Contract
  • Client
  • P_TRADINGCONTRACTHEADER.BTBSTA == TB2BA.BTBSTA
  • P_TRADINGCONTRACTHEADER.MANDT == TB2BA.MANDT
Check Currency
  • Currency key of credit control area
  • Client
  • P_TRADINGCONTRACTHEADER.CMWAE == TCURC.WAERS
  • P_TRADINGCONTRACTHEADER.MANDT == TCURC.MANDT
Company Code
  • Company Code
  • Client
  • P_TRADINGCONTRACTHEADER.COMPANY_CODE == T001.BUKRS
  • P_TRADINGCONTRACTHEADER.MANDT == T001.MANDT
Check Billing Block
  • Billing Block in SD Document
  • Client
  • P_TRADINGCONTRACTHEADER.FAKSK_SD == TVFS.FAKSP
  • P_TRADINGCONTRACTHEADER.MANDT == TVFS.MANDT
Check
  • Customer Credit Group
  • Credit control area
  • Client
  • P_TRADINGCONTRACTHEADER.GRUPP == T691B.GRUPP
  • P_TRADINGCONTRACTHEADER.KKBER == T691B.KKBER
  • P_TRADINGCONTRACTHEADER.MANDT == T691B.MANDT
Check Credit Control Area
  • Credit control area
  • Client
  • P_TRADINGCONTRACTHEADER.KKBER == T014.KKBER
  • P_TRADINGCONTRACTHEADER.MANDT == T014.MANDT
Check Customer
  • Customer's Account Number with Credit Limit Reference
  • Client
  • P_TRADINGCONTRACTHEADER.KNKLI == KNA1.KUNNR
  • P_TRADINGCONTRACTHEADER.MANDT == KNA1.MANDT
Check Controlling Area
  • Controlling Area
  • Client
  • P_TRADINGCONTRACTHEADER.KOKRS == TKA01.KOKRS
  • P_TRADINGCONTRACTHEADER.MANDT == TKA01.MANDT
Check Customer Number
  • Sold-to Party
  • Client
  • P_TRADINGCONTRACTHEADER.KUNNR == KNA1.KUNNR
  • P_TRADINGCONTRACTHEADER.MANDT == KNA1.MANDT
Check Exchange Rate Types
  • Client
  • Exchange Rate Type
  • P_TRADINGCONTRACTHEADER.MANDT == TCURV.MANDT
  • P_TRADINGCONTRACTHEADER.KURST == TCURV.KURST
Check Exchange Rate Types
  • Client
  • Exchange Rate Type
  • P_TRADINGCONTRACTHEADER.MANDT == TCURV.MANDT
  • P_TRADINGCONTRACTHEADER.KURST_SD == TCURV.KURST
Check Customer Group 1
  • Customer Group 1
  • Client
  • P_TRADINGCONTRACTHEADER.KVGR1_SD == TVV1.KVGR1
  • P_TRADINGCONTRACTHEADER.MANDT == TVV1.MANDT
Check Customer Group 2
  • Customer Group 2
  • Client
  • P_TRADINGCONTRACTHEADER.KVGR2_SD == TVV2.KVGR2
  • P_TRADINGCONTRACTHEADER.MANDT == TVV2.MANDT
Check Customer Group 3
  • Customer Group 3
  • Client
  • P_TRADINGCONTRACTHEADER.KVGR3_SD == TVV3.KVGR3
  • P_TRADINGCONTRACTHEADER.MANDT == TVV3.MANDT
Check Customer Group 4
  • Customer Group 4
  • Client
  • P_TRADINGCONTRACTHEADER.KVGR4_SD == TVV4.KVGR4
  • P_TRADINGCONTRACTHEADER.MANDT == TVV4.MANDT
Check Customer Group 5
  • Customer Group 5
  • Client
  • P_TRADINGCONTRACTHEADER.KVGR5_SD == TVV5.KVGR5
  • P_TRADINGCONTRACTHEADER.MANDT == TVV5.MANDT
Tax Departure Country/Region
  • Client
  • Tax Departure Country/Region
  • P_TRADINGCONTRACTHEADER.MANDT == T005.MANDT
  • P_TRADINGCONTRACTHEADER.LANDTX == T005.LAND1
Check Letter of Credit Number
  • Financial doc. processing: Internal financial doc. number
  • Client
  • P_TRADINGCONTRACTHEADER.LCNUM == AKKP.LCNUM
  • P_TRADINGCONTRACTHEADER.MANDT == AKKP.MANDT
Check Blocking Reason for Vendor Billing Document
  • Client
  • Blocking Reason Document Header
  • P_TRADINGCONTRACTHEADER.MANDT == TMFS.MANDT
  • P_TRADINGCONTRACTHEADER.LFSPG == TMFS.LFSPG
Check Delivery Block
  • Delivery Block (Document Header)
  • Client
  • P_TRADINGCONTRACTHEADER.LIFSK_SD == TVLS.LIFSP
  • P_TRADINGCONTRACTHEADER.MANDT == TVLS.MANDT
Logical System P_TRADINGCONTRACTHEADER.LOGSYS == TBDLS.LOGSYS
Check Processor Group
  • Credit control area
  • Client
  • Credit Representative Group for Credit Management
  • P_TRADINGCONTRACTHEADER.KKBER == T024B.KKBER
  • P_TRADINGCONTRACTHEADER.MANDT == T024B.MANDT
  • P_TRADINGCONTRACTHEADER.SBGRP == T024B.SBGRP
Check Currency
  • SD Document Currency
  • Client
  • P_TRADINGCONTRACTHEADER.SDWRS == TCURC.WAERS
  • P_TRADINGCONTRACTHEADER.MANDT == TCURC.MANDT
Check Division
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • P_TRADINGCONTRACTHEADER.VKORG == TVTA.VKORG
  • P_TRADINGCONTRACTHEADER.VTWEG == TVTA.VTWEG
  • P_TRADINGCONTRACTHEADER.MANDT == TVTA.MANDT
  • P_TRADINGCONTRACTHEADER.SPART == TVTA.SPART
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • P_TRADINGCONTRACTHEADER.MANDT == T005.MANDT
  • P_TRADINGCONTRACTHEADER.STCEG_L == T005.LAND1
Check Country
  • Client
  • Tax Destination Country/Region
  • P_TRADINGCONTRACTHEADER.MANDT == T005.MANDT
  • P_TRADINGCONTRACTHEADER.STCEG_L_SD == T005.LAND1
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_TRADINGCONTRACTHEADER.MANDT == TB2BE.MANDT
  • P_TRADINGCONTRACTHEADER.TCTYP == TB2BE.TCTYP
Trading Execution Workbench Type
  • Trading Execution Workbench Type
  • Client
  • P_TRADINGCONTRACTHEADER.TEW_TYPE == TEWTYPE.TEW_TYPE
  • P_TRADINGCONTRACTHEADER.MANDT == TEWTYPE.MANDT
Check Currency
  • Currency of Trading Contract
  • Client
  • P_TRADINGCONTRACTHEADER.TKWAERS == TCURC.WAERS
  • P_TRADINGCONTRACTHEADER.MANDT == TCURC.MANDT
Check Sales Group
  • Sales office
  • Client
  • Sales group
  • P_TRADINGCONTRACTHEADER.VKBUR == TVBVK.VKBUR
  • P_TRADINGCONTRACTHEADER.MANDT == TVBVK.MANDT
  • P_TRADINGCONTRACTHEADER.VKGRP == TVBVK.VKGRP
Check Sales Organization
  • Sales Organization
  • Client
  • P_TRADINGCONTRACTHEADER.VKORG == TVKO.VKORG
  • P_TRADINGCONTRACTHEADER.MANDT == TVKO.MANDT
Check Shipping Conditions
  • Client
  • Shipping Conditions
  • P_TRADINGCONTRACTHEADER.MANDT == TVSB.MANDT
  • P_TRADINGCONTRACTHEADER.VSBED_SD == TVSB.VSBED
Check Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • P_TRADINGCONTRACTHEADER.VKORG == TVKOV.VKORG
  • P_TRADINGCONTRACTHEADER.VTWEG == TVKOV.VTWEG
  • P_TRADINGCONTRACTHEADER.MANDT == TVKOV.MANDT
Customer Number
  • Client
  • Customer Number
  • P_TRADINGCONTRACTHEADER.MANDT == KNA1.MANDT
  • P_TRADINGCONTRACTHEADER.WE_KUNNR == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Check Sales Group
  • Sales office
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • P_TRADINGCONTRACTHEADER.VKBUR == TVKBZ.VKBUR
  • P_TRADINGCONTRACTHEADER.VKORG == TVKBZ.VKORG
  • P_TRADINGCONTRACTHEADER.VTWEG == TVKBZ.VTWEG
  • P_TRADINGCONTRACTHEADER.MANDT == TVKBZ.MANDT
  • P_TRADINGCONTRACTHEADER.SPART == TVKBZ.SPART