P_ACMTrdgContractBusinessData

Basic View on Trading Contract Business Data | view: PTRDGCONTRBUS1 | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management

Tables used: WBHD

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities
📅 Dates (17)
☰ Categorical (9)
Other (34)
🔗 Relations (25)

Column Name	Description
TKONN FK	Trading Contract
TPOSN	Item Number of Trading Contract
TPOSN_SUB	Sub-Item Number of Trading Contract

Column Name	Description
💲 Currency Key (WAERS_PURCH):
DPAMT	Down Payment Amount in Document Currency

Column Name	Description

Column Name	Description
EBDAT	Purchasing Document Date
EINDT	Delivery Date of purchasing item in trading contract
VALDT	Fixed Value Date
PRSDT_MM	Date for Pricing and Exchange Rate
PRSDT_SD	Date for Pricing and Exchange Rate
ERDAT	Date on which the record was created
ERZET	Entry time
IHRAN	Quotation Submission Date
EDATU_VBAK	Delivery Date for Item Sales
VALDTD	Fixed Value Date
KDATB_MM	Start of Validity Period
KDATE_MM	End of Validity Period
_DATAAGING	Data Filter Value for Data Aging
BSTDK	Customer Reference Date
BSTDK_E	Ship-to Party's Customer Reference Date
DPDAT	Due Date for Down Payment
J_1AIDATEP	Indexing base date

Column Name	Description
LPEIN_INT	Date type (day, week, month, interval)	Show values
PRGRS_VBAK	Proposed date type	Show values
KZABS_MM	Order Acknowledgment Requirement	Show values
KZAZU	Order Combination Indicator	Show values
HKLA	Delivery Address Origin	Show values
KUFIX	Indicator for Fixed Exchange Rate	Show values
BSTYP	Purchasing Document Category	Show values
PODKZ	Relevant for POD processing	Show values
SEPA_REL_SD	Sales: SEPA Relevance	Show values

Column Name	Description	Domain name
IHREZ	Your Reference	TEXT12
TKRATE_MM	Exchange Rate Order Currency / Local Currency	KURRF
ZTERM	Terms of Payment Key Purchasing	ZTERM
TERMDES_MM	Description of Terms of Payment	BEZEI80
ERNAM	Name of Person Responsible for Creating the Object	USNAM
WERK_MM	Plant	WERKS
INCO2_MM	Incoterms Part 2 Purchasing	INCO2
INCO2_SD	Incoterms Part 2 Sales	INCO2
ZTERM_SALES	Terms Of Payment Key Sales	ZTERM
TERMDES_SD	Description of Terms of Payment	BEZEI80
ANGNR_MM	Quotation Number	ANGNR
VERKF_MM	Responsible Salesperson at Supplier's Office	TEXT30
TELF1_MM	Supplier's Telephone Number	TEXT16
UNSEZ_MM	Our Reference	TEXT12
LABNR	Order Acknowledgment Number	TEXT20
LCNUM	Financial doc. processing: Internal financial doc. number	LCNUM
AKPRZ	Depreciation percentage for financial document processing	PRZ32
POSPLIT	Manual Purchase Order Split	POSPLIT
BSART	Order Type (Purchasing)	BSART
INCO2_L_SD	Incoterms Location 1	INCO_L
INCO3_L_SD	Incoterms Location 2	INCO_L
INCO2_L_MM	Incoterms Location 1	INCO_L
INCO3_L_MM	Incoterms Location 2	INCO_L
DUMMY_WBHD_INCL_EEW_PS	Dummy Data Element for Trdg. Contr. Bus. Data Extensibility	WBHD_INCL_EEW
BSTKD_E	Ship-to Party's Customer Reference	BSTKD
POSEX_E	Item Number of the Underlying Purchase Order	POSEX
BSTKD	Customer Reference	BSTKD
KALSM_MM	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	KALSM
KNUMV_MM	Number of the Document Condition	KNUMV
KURSK_SD	Exchange Rate for Price Determination	KURRF
RETPC	Retention in Percent	PRZ32
DPTYP	Down Payment Indicator	ME_DPTYPE_DOMAIN
DPPCT	Down Payment Percentage	PRZ32
MNDID	Unique Reference to Mandate for each Payee	ID035

Master Data Relations	Join Conditions
Payment Guarantee Procedure Client Payment Guarantee Procedure	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T691M.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.ABSSC == T691M.ABSSC`
Check Client Confirmation Control Key	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T163L.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.BSTAE_MM == T163L.BSTAE`
Check Purchasing Group Purchasing Group Client	`P_ACMTRDGCONTRACTBUSINESSDATA.EKGRP == T024.EKGRP` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T024.MANDT`
Check Purchasing Organization Client Purchasing organization	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T024E.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.EKORG == T024E.EKORG`
Check Vendor Vendor's account number Client	`P_ACMTRDGCONTRACTBUSINESSDATA.ELIFN == LFA1.LIFNR` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == LFA1.MANDT`
Check Shipping Instructions Shipping Instructions Client	`P_ACMTRDGCONTRACTBUSINESSDATA.EVERS_MM == T027A.EVERS` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T027A.MANDT`
Check Incoterms Client Incoterms Part 1 Purchasing	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == TINC.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.INCO1_MM == TINC.INCO1`
Check Incoterms Client Incoterms Part 1 Sales	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == TINC.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.INCO1_SD == TINC.INCO1`
Incoterms Version Incoterms Version Client	`P_ACMTRDGCONTRACTBUSINESSDATA.INCOV_MM == TINCV.INCOV` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == TINCV.MANDT`
Incoterms Version Incoterms Version Client	`P_ACMTRDGCONTRACTBUSINESSDATA.INCOV_SD == TINCV.INCOV` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == TINCV.MANDT`
Distribution Type for Employment Tax ? Client Distribution Type for Employment Tax	`P_ACMTRDGCONTRACTBUSINESSDATA.[column in domain "BUKRS"] == J_1ADTYP.BUKRS` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == J_1ADTYP.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.J_1ADTYP_SD == J_1ADTYP.J_1ADTYP`
Tax type Tax type ? Client	`P_ACMTRDGCONTRACTBUSINESSDATA.J_1AFITP_SD == J_1AFITP.J_1AFITP` `P_ACMTRDGCONTRACTBUSINESSDATA.[column in domain "KOART"] == J_1AFITP.KOART` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == J_1AFITP.MANDT`
Activity Code for Gross Income Tax ? Activity Code for Gross Income Tax Client	`P_ACMTRDGCONTRACTBUSINESSDATA.[column in domain "LAND1"] == J_1AGICD.LAND1` `P_ACMTRDGCONTRACTBUSINESSDATA.J_1AGICD_SD == J_1AGICD.J_1AGICD` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == J_1AGICD.MANDT`
Inflation Index Client Inflation Index	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == J_1AINFT20.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.J_1AINDXP == J_1AINFT20.J_1AINDX`
Region (State, Province, County) ? Region (State, Province, County) Client	`P_ACMTRDGCONTRACTBUSINESSDATA.[column in domain "LAND1"] == T005S.LAND1` `P_ACMTRDGCONTRACTBUSINESSDATA.J_1AREGIO_SD == T005S.BLAND` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T005S.MANDT`
Reason for Zero VAT Reason for Zero VAT Client	`P_ACMTRDGCONTRACTBUSINESSDATA.J_1ARFZ_SD == J_1ARFZ.J_1ARFZ` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == J_1ARFZ.MANDT`
Tax relevant classification Client Tax relevant classification	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == J_1ATXREL.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.J_1ATXREL_SD == J_1ATXREL.J_1ATXREL`
Check Exchange Rate Types Client Exchange Rate Type	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == TCURV.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.KURST_MM == TCURV.KURST`
Check Prior Vendor Goods Supplier Client	`P_ACMTRDGCONTRACTBUSINESSDATA.LLIEF_MM == LFA1.LIFNR` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == LFA1.MANDT`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T001W.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.RESWK == T001W.WERKS`
Shipping Type Client Shipping Type	`P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T173.MANDT` `P_ACMTRDGCONTRACTBUSINESSDATA.VSART == T173.VSART`
Check Currency Currency Key Client	`P_ACMTRDGCONTRACTBUSINESSDATA.WAERS_PURCH == TCURC.WAERS` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == TCURC.MANDT`
Check Payment Method ? Payment Method Client	`P_ACMTRDGCONTRACTBUSINESSDATA.[column in domain "LAND1"] == T042Z.LAND1` `P_ACMTRDGCONTRACTBUSINESSDATA.ZLSCH == T042Z.ZLSCH` `P_ACMTRDGCONTRACTBUSINESSDATA.MANDT == T042Z.MANDT`