C_TrdgContrCreditSalesDet

DDL: C_TRDGCONTRCREDITSALESDET SQL: CTRDGCONTRCS Type: view CONSUMPTION
20 Fields 3 Data Sources

Consumption Query for Trading Contract Credit Sales Details

C_TrdgContrCreditSalesDet (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

C_TrdgContrCreditSalesDet is a Consumption CDS View that provides data about "Consumption Query for Trading Contract Credit Sales Details" in SAP S/4HANA. It reads from 3 data sources (I_ACMTrdgContractBusinessData, I_TrdgContrCreditSalesDet, I_ACMTradingContractData) and exposes 20 fields with key fields TradingContractNumber, ACMTrdgContrAuditSequenceNmbr, TradingContractItem, TradingContractTradeOffice, TradingContractGovRgnCode.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AGR-CC
CapabilitiesData Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (3)

SourceAliasJoin Type
I_ACMTrdgContractBusinessData Business inner
I_TrdgContrCreditSalesDet I_TrdgContrCreditSalesDet from
I_ACMTradingContractData TrdgContrHdr inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CTRDGCONTRCS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Consumption Query for Trading Contract Credit Sales Details view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_TrdgContrCreditSalesDet TradingContractNumber Trading Contract
KEY ACMTrdgContrAuditSequenceNmbr ACMTrdgContrAuditSequenceNmbr Audit Sequence Number
KEY TradingContractItem I_TrdgContrCreditSalesDet TradingContractItem Item Number of Trading Contract
KEY TradingContractTradeOffice TradingContractTradeOffice Trade Office
KEY TradingContractGovRgnCode TradingContractGovRgnCode Governing Region Code
TradingContractCreditSales TradingContractCreditSales Credit Sale Indicator
ACMTrdgContrGovRgnCodeStatus ACMTrdgContrGovRgnCodeStatus GRC Status
ACMTrdgContrGovRgnCodeStsName ACMTrdgContrGovRgnCodeStsName Short Text for Fixed Values
TrdgContrCrdtSlsTypeOfAssgmt TrdgContrCrdtSlsTypeOfAssgmt Type Of Assignment
ProcessedTimeZone ProcessedTimeZone Time Zone
TrdgContrCreditSalesFromDate TrdgContrCreditSalesFromDate UTC Valid from Date
TrdgContrCreditSalesFromTime TrdgContrCreditSalesFromTime UTC Valid from Time
TrdgContractCreditSalesToDate TrdgContractCreditSalesToDate UTC Valid to Date
TrdgContractCreditSalesToTime TrdgContractCreditSalesToTime UTC Valid to Time
TradingContractType I_ACMTradingContractData TradingContractType Trading Contract Type
SalesOrganization SalesOrganization Sales Organization
Division Division Internal Division ID
DistributionChannel DistributionChannel Distribution Channel
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization

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_TrdgContrCreditSalesDet.
-- 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.
-- SQL view name: CTRDGCONTRCS

CREATE VIEW C_TrdgContrCreditSalesDet AS
SELECT
  I_TrdgContrCreditSalesDet.TradingContractNumber AS TradingContractNumber,
  ACMTrdgContrAuditSequenceNmbr,
  I_TrdgContrCreditSalesDet.TradingContractItem AS TradingContractItem,
  TradingContractTradeOffice,
  TradingContractGovRgnCode,
  TradingContractCreditSales,
  ACMTrdgContrGovRgnCodeStatus,
  ACMTrdgContrGovRgnCodeStsName,
  TrdgContrCrdtSlsTypeOfAssgmt,
  ProcessedTimeZone,
  TrdgContrCreditSalesFromDate,
  TrdgContrCreditSalesFromTime,
  TrdgContractCreditSalesToDate,
  TrdgContractCreditSalesToTime,
  TrdgContrHdr.TradingContractType AS TradingContractType,
  SalesOrganization,
  Division,
  DistributionChannel,
  PurchasingGroup,
  PurchasingOrganization
FROM I_TrdgContrCreditSalesDet
INNER JOIN I_ACMTradingContractData AS TrdgContrHdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContractBusinessData AS Business ON /* join condition not captured in parsed metadata */
;

Learn More