What is C_TrdgContr_F6649 in SAP S/4HANA?

C_TrdgContr_F6649 is a consumption CDS view in SAP S/4HANA. Manage Trading Contracts It contains 136 fields.

Which tables does C_TrdgContr_F6649 read from?

C_TrdgContr_F6649 reads data from: R_TrdgContrTP.

What VDM layer is C_TrdgContr_F6649?

C_TrdgContr_F6649 is classified as a Consumption view optimized for specific business scenarios and reporting.

C_TrdgContr_F6649

DDL: C_TRDGCONTR_F6649 Type: view_entity CONSUMPTION

136 Fields 1 Data Sources 2 Associations

Manage Trading Contracts

C_TrdgContr_F6649 is a Consumption CDS View that provides data about "Manage Trading Contracts" in SAP S/4HANA. It reads from 1 data source (R_TrdgContrTP) and exposes 136 fields with key field TradingContract. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
R_TrdgContrTP	R_TrdgContrTP	projection

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	C_TradingContractQuickView	_TrdgContrQuickView	`$projection.TradingContract = _TrdgContrQuickView.TradingContract`
[0..1]	C_SupplierPurchOrgVH	_SupplierValueHelp	`$projection.Supplier = _SupplierValueHelp.Supplier and $projection.PurchasingOrganization = _SupplierValueHelp.PurchasingOrganization`

Annotations (10)

Name	Value	Level
EndUserText.label	Manage Trading Contracts	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.representativeKey	TradingContract	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
Metadata.allowExtensions	true	view
Search.searchable	true	view

Fields (136)

Key	Field	Source Table	Source Field	Description
KEY	TradingContract		TradingContract
	TradingContractType		TradingContractType
	TrdgContrTypeName
	SoldToParty		SoldToParty	Sold-to Party
	CustomerName	_SoldToParty	CustomerName	Name of Customer
	BPCustomerName	_SoldToParty	BPCustomerName	Name of Customer
	CustomerName_H	_SoldToParty	OrganizationBPName1	Name 1
	TrdgContrCustomerBPName1	_SoldToParty	BusinessPartnerName1	Name
	TradingContractReleaseStatus		TradingContractReleaseStatus
	TrdgContrReleaseStatusName
	TrdgContrApplicationStatus		TrdgContrApplicationStatus
	TrdgContrApplStsName
	TradingContractCurrency		TradingContractCurrency	Document Currency
	TrdgContrHasCnsldtdItem		TrdgContrHasCnsldtdItem
	TrdgContrCnsldtdItemName
	TrdgContrSuccessorArchived		TrdgContrSuccessorArchived
	TrdgContrSuccssrArchivedName
	TrdgContrProcessingStatus		TrdgContrProcessingStatus
	TrdgContrProcgStatusName
	Supplier		Supplier	Supplier
	SupplierName	_Supplier	SupplierName	Supplier Name
	BPSupplierName	_Supplier	BPSupplierName	Supplier Name
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName	_PurchasingOrganization	PurchasingOrganizationName	Purch. Org. Name
	PurchasingGroup		PurchasingGroup	Purchasing Group
	PurchasingGroupName	_PurchasingGroup	PurchasingGroupName	Purchasing Grp. Name
	SalesDocumentType		SalesDocumentType	Sales Doc. Type
	SalesDocumentTypeName
	CreatedByUser		CreatedByUser	User Name
	CreatedByUserName	_CreatedByUser	UserDescription	Full Name
	LastChangedByUser		LastChangedByUser	Last Changed By
	LastChangedByUserName	_LastChangedByUser	UserDescription	Full Name
	TrdgContrRelStsCritlty		TrdgContrRelStsCritlty
	TrdgContrPersonResponsible		TrdgContrPersonResponsible
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Change
	CreationDateTime		CreationDateTime	Timestamp
	LastChangeDate		LastChangeDate	Time Stamp
	LastChangeTime		LastChangeTime	Time changed
	LastChangeDateTime		LastChangeDateTime	Timestamp
	SalesOrganization		SalesOrganization	Sales Organization
	SalesOrganizationName
	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	DistributionChannelName
	OrganizationDivision		OrganizationDivision	Org. Division
	DivisionName
	SalesGroup		SalesGroup	Sales Group
	SalesGroupName
	AdditionalCustomerGroup1		AdditionalCustomerGroup1	Customer Grp 1
	AdditionalCustomerGroup1Name
	AdditionalCustomerGroup2		AdditionalCustomerGroup2	Customer Grp 2
	AdditionalCustomerGroup2Name
	AdditionalCustomerGroup3		AdditionalCustomerGroup3	Customer Grp 3
	AdditionalCustomerGroup3Name
	AdditionalCustomerGroup4		AdditionalCustomerGroup4	Customer Grp 4
	AdditionalCustomerGroup4Name
	AdditionalCustomerGroup5		AdditionalCustomerGroup5	Customer Grp 5
	AdditionalCustomerGroup5Name
	SalesDocumentDate		SalesDocumentDate	Document Date
	SalesOrderReason		SalesOrderReason
	SDDocumentReasonText
	SDDocumentCollectiveNumber		SDDocumentCollectiveNumber
	CustomerPurchaseOrderSuplmnt		CustomerPurchaseOrderSuplmnt
	TrdgContrProdUsgeCat		TrdgContrProdUsgeCat
	TrdgContrProdUsgeCatName
	DocumentReferenceID		DocumentReferenceID	Reference
	TrdgContrTotalNetAmount		TrdgContrTotalNetAmount
	TradingContractExchangeRate		TradingContractExchangeRate
	TrdgContrExchangeRateDate		TrdgContrExchangeRateDate
	TrdgContrSalesPricingDate		TrdgContrSalesPricingDate
	CustomerTaxClassification1		CustomerTaxClassification1
	CustomerTaxClassification2		CustomerTaxClassification2
	CustomerTaxClassification3		CustomerTaxClassification3
	CustomerTaxClassification4		CustomerTaxClassification4
	CustomerTaxClassification5		CustomerTaxClassification5
	CustomerTaxClassification6		CustomerTaxClassification6
	CustomerTaxClassification7		CustomerTaxClassification7
	CustomerTaxClassification8		CustomerTaxClassification8
	CustomerTaxClassification9		CustomerTaxClassification9
	TaxDepartureCountry		TaxDepartureCountry	Tx Dep Ctry/Reg
	TaxDepartureCountryName
	VATRegistrationCountry		VATRegistrationCountry	CtryRgnSlsTxNo.
	VATRegistrationCountryName
	ShippingCondition		ShippingCondition	Shipping Conditions
	ShippingConditionName
	CompleteDeliveryIsDefined		CompleteDeliveryIsDefined	Complete Dlv.
	DeliveryBlockReason		DeliveryBlockReason	Delivery Block Reason
	DeliveryBlockReasonText
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	CustomerRiskCategory		CustomerRiskCategory
	TrdgContrAddlExpnsBlkRsn		TrdgContrAddlExpnsBlkRsn
	TrdgContrAddlExpnsBlkRsnName
	SalesOffice		SalesOffice	Sales Office
	SalesOfficeName
	TrdgContrCatName
	TradingContractIsComplete		TradingContractIsComplete
	HeaderBillingBlockReason		HeaderBillingBlockReason	Billing Block
	BillingBlockReasonDescription
	AccountingExchangeRate		AccountingExchangeRate	Exch.Rate Acct.
	TrdgContrSlsExternalReference		TrdgContrSlsExternalReference
	LastCustomerContactDate		LastCustomerContactDate
	TradingContractExtID		TradingContractExtID
	IsEUTriangularDeal		IsEUTriangularDeal	Is EU Triangular Deal
	TrdgContrProcessingLastAction		TrdgContrProcessingLastAction
	TrdgContrPOByCustomer		TrdgContrPOByCustomer
	TrdgContrSlsReqdDeliveryDate		TrdgContrSlsReqdDeliveryDate
	TrdgContrDate		TrdgContrDate
	TrdgContrPurgReqdDeliveryDate		TrdgContrPurgReqdDeliveryDate
	TrdgContrSlsPersonName		TrdgContrSlsPersonName
	PhoneNumber1		PhoneNumber1	Telephone 1
	TrdgContrSlsNrOfFollowUps		TrdgContrSlsNrOfFollowUps
	PurgIncotermsClassification		PurgIncotermsClassification
	PurgIncotermsClassfctnName
	SlsIncotermsClassification		SlsIncotermsClassification
	SlsIncotermsClassificationName
	PurchaseOrderByCustomer		PurchaseOrderByCustomer	Purchase Order Number
	SupplyingPlant		SupplyingPlant	Supplying Plant
	SupplyingPlantName
	SupplierRespSalesPersonName		SupplierRespSalesPersonName	Salesperson
	SupplierPhoneNumber		SupplierPhoneNumber	Telephone
	TrdgContrPurgDocExtReference		TrdgContrPurgDocExtReference
	TrdgContrPurgPaymentTerms		TrdgContrPurgPaymentTerms
	TrdgContrPurgPaymentTermsName
	TrdgContrSalesPaymentTerms		TrdgContrSalesPaymentTerms
	TrdgContrSalesPaymentTermsName
	PaymentTermsName		PaymentTermsName	Description
	PurgIncotermsTransferLocation		PurgIncotermsTransferLocation
	SlsIncotermsTransferLocation		SlsIncotermsTransferLocation
	PurchaseOrderByShipToParty		PurchaseOrderByShipToParty
	_SoldToParty		_SoldToParty
	_CustomerSalesArea		_CustomerSalesArea
	_Supplier		_Supplier
	_SupplierValueHelp		_SupplierValueHelp
	_TrdgContrQuickView		_TrdgContrQuickView
	_TradingContractCurrency		_TradingContractCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_TrdgContr_F6649.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_TrdgContr_F6649 AS
SELECT
  TradingContract,
  TradingContractType,
  _TradingContractType._Text[1: Language = $session.system_language].TrdgContrTypeName AS TrdgContrTypeName,
  SoldToParty,
  _SoldToParty.CustomerName AS CustomerName,
  _SoldToParty.BPCustomerName AS BPCustomerName,
  _SoldToParty.OrganizationBPName1 AS CustomerName_H,
  _SoldToParty.BusinessPartnerName1 AS TrdgContrCustomerBPName1,
  TradingContractReleaseStatus,
  _TrdgContrReleaseStatus._Text[1: Language = $session.system_language].TrdgDocReleaseStatusName AS TrdgContrReleaseStatusName,
  TrdgContrApplicationStatus,
  _TrdgContrApplStatus._Text[1: Language = $session.system_language].TrdgDocApplicationStatusName AS TrdgContrApplStsName,
  TradingContractCurrency,
  TrdgContrHasCnsldtdItem,
  _TrdgContrHasCnsldtdItem._Text[1: Language = $session.system_language].TrdgDocCnsldtdItemName AS TrdgContrCnsldtdItemName,
  TrdgContrSuccessorArchived,
  _TrdgContrSuccssrArchived._Text[1: Language = $session.system_language].TrdgDocSuccssrArchivedName AS TrdgContrSuccssrArchivedName,
  TrdgContrProcessingStatus,
  _TrdgContrProcgStatus._Text[1: Language = $session.system_language].TrdgDocProcgStatusName AS TrdgContrProcgStatusName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.BPSupplierName AS BPSupplierName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SalesDocumentType,
  _SalesOrderType._Text[1: Language = $session.system_language].SalesDocumentTypeName AS SalesDocumentTypeName,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  TrdgContrRelStsCritlty,
  TrdgContrPersonResponsible,
  CreationDate,
  CreationTime,
  CreationDateTime,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  SalesOrganization,
  _SalesOrganization._Text[1: Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannel._Text[1: Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  OrganizationDivision,
  _OrganizationDivision._Text[1: Language = $session.system_language].DivisionName AS DivisionName,
  SalesGroup,
  _SalesGroup._Text[1: Language = $session.system_language].SalesGroupName AS SalesGroupName,
  AdditionalCustomerGroup1,
  _AdditionalCustomerGroup1._Text[1: Language = $session.system_language].AdditionalCustomerGroup1Name AS AdditionalCustomerGroup1Name,
  AdditionalCustomerGroup2,
  _AdditionalCustomerGroup2._Text[1: Language = $session.system_language].AdditionalCustomerGroup2Name AS AdditionalCustomerGroup2Name,
  AdditionalCustomerGroup3,
  _AdditionalCustomerGroup3._Text[1: Language = $session.system_language].AdditionalCustomerGroup3Name AS AdditionalCustomerGroup3Name,
  AdditionalCustomerGroup4,
  _AdditionalCustomerGroup4._Text[1: Language = $session.system_language].AdditionalCustomerGroup4Name AS AdditionalCustomerGroup4Name,
  AdditionalCustomerGroup5,
  _AdditionalCustomerGroup5._Text[1: Language = $session.system_language].AdditionalCustomerGroup5Name AS AdditionalCustomerGroup5Name,
  SalesDocumentDate,
  SalesOrderReason,
  _SalesOrderReason._Text[1: Language = $session.system_language].SDDocumentReasonText AS SDDocumentReasonText,
  SDDocumentCollectiveNumber,
  CustomerPurchaseOrderSuplmnt,
  TrdgContrProdUsgeCat,
  _MatlUsageIndicator._Text[1: Language = $session.system_language].MatlUsageIndicatorText AS TrdgContrProdUsgeCatName,
  DocumentReferenceID,
  TrdgContrTotalNetAmount,
  TradingContractExchangeRate,
  TrdgContrExchangeRateDate,
  TrdgContrSalesPricingDate,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  TaxDepartureCountry,
  _TaxDepartureCountry._Text[1: Language = $session.system_language].CountryName AS TaxDepartureCountryName,
  VATRegistrationCountry,
  _VATRegistrationCountry._Text[1: Language = $session.system_language].CountryName AS VATRegistrationCountryName,
  ShippingCondition,
  _ShippingCondition._Text[1: Language = $session.system_language].ShippingConditionName AS ShippingConditionName,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  _DeliveryBlockReason._Text[1: Language = $session.system_language].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  CustomerRiskCategory,
  TrdgContrAddlExpnsBlkRsn,
  _TrdgContrAddlExpnsBlkRsn._Text[1: Language = $session.system_language].TrdgDocAddlExpnsBlkRsnName AS TrdgContrAddlExpnsBlkRsnName,
  SalesOffice,
  _SalesOffice._Text[1: Language = $session.system_language].SalesOfficeName AS SalesOfficeName,
  _TrdgContrCategory._Text[1: Language = $session.system_language].TrdgDocCategoryName AS TrdgContrCatName,
  TradingContractIsComplete,
  HeaderBillingBlockReason,
  _HeaderBillingBlockReason._Text[1: Language = $session.system_language].BillingBlockReasonDescription AS BillingBlockReasonDescription,
  AccountingExchangeRate,
  TrdgContrSlsExternalReference,
  LastCustomerContactDate,
  TradingContractExtID,
  IsEUTriangularDeal,
  TrdgContrProcessingLastAction,
  TrdgContrPOByCustomer,
  TrdgContrSlsReqdDeliveryDate,
  TrdgContrDate,
  TrdgContrPurgReqdDeliveryDate,
  TrdgContrSlsPersonName,
  PhoneNumber1,
  TrdgContrSlsNrOfFollowUps,
  PurgIncotermsClassification,
  _PurgIncotermsClassification._Text[1: Language = $session.system_language].IncotermsClassificationName AS PurgIncotermsClassfctnName,
  SlsIncotermsClassification,
  _SlsIncotermsClassification._Text[1: Language = $session.system_language].IncotermsClassificationName AS SlsIncotermsClassificationName,
  PurchaseOrderByCustomer,
  SupplyingPlant,
  _SupplyingPlant[1: Language = $session.system_language].PlantName AS SupplyingPlantName,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  TrdgContrPurgDocExtReference,
  TrdgContrPurgPaymentTerms,
  _TrdgContrPurgPaymentTerms._Text[1: Language = $session.system_language].PaymentTermsName AS TrdgContrPurgPaymentTermsName,
  TrdgContrSalesPaymentTerms,
  _TrdgContrSalesPaymentTerms._Text[1: Language = $session.system_language].PaymentTermsName AS TrdgContrSalesPaymentTermsName,
  PaymentTermsName,
  PurgIncotermsTransferLocation,
  SlsIncotermsTransferLocation,
  PurchaseOrderByShipToParty
FROM R_TrdgContrTP
LEFT OUTER JOIN C_TradingContractQuickView AS _TrdgContrQuickView ON TradingContract = _TrdgContrQuickView.TradingContract  -- association [0..1]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplierValueHelp ON Supplier = _SupplierValueHelp.Supplier AND PurchasingOrganization = _SupplierValueHelp.PurchasingOrganization  -- association [0..1]
;

Depth:

C_TrdgContr_F6649 view_entity

R_TrdgContrTP view_entity