C_NonFerrousMatSlsDocItmTP

DDL: C_NONFERROUSMATSLSDOCITMTP Type: view_entity CONSUMPTION
88 Fields 1 Data Sources

NFM Sales Document Item

C_NonFerrousMatSlsDocItmTP is a Consumption CDS View that provides data about "NFM Sales Document Item" in SAP S/4HANA. It reads from 1 data source (I_NonFerrousMatSalesDocItem) and exposes 88 fields with key fields NonFerrousMatlDocumentCategory, CompanyCode, SalesOrganization, NonFerrousCode, NonFerrousMatlDocumentRef.

Data Sources (1)

SourceAliasJoin Type
I_NonFerrousMatSalesDocItem I_NonFerrousMatSalesDocItem projection

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label NFM Sales Document Item view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName NFM Sales Document view
UI.headerInfo.typeNamePlural NFM Sales Document List view
UI.headerInfo.title.value NonFerrousMatlDocumentRef view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.description.value SalesDocumentExTypeName view
UI.headerInfo.description.type #STANDARD view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (88)

KeyFieldSource TableSource FieldDescription
KEY NonFerrousMatlDocumentCategory NonFerrousMatlDocumentCategory
KEY CompanyCode CompanyCode Receiver Company Code
KEY SalesOrganization SalesOrganization Sales Organization
KEY NonFerrousCode NonFerrousCode
KEY NonFerrousMatlDocumentRef NonFerrousMatlDocumentRef
KEY NonFerrousMatlDocumentRefItem NonFerrousMatlDocumentRefItem
KEY PostingFiscalYear PostingFiscalYear Fiscal Year
MaterialBaseUnit MaterialBaseUnit NF Metal Base Unit
TotalNonFerrousChargeWeight TotalNonFerrousChargeWeight Total NF Charge Weight
NonFerrousWeight NonFerrousWeight
NonFerrousWgtBsRefQtyInBaseUoM NonFerrousWgtBsRefQtyInBaseUoM
BaseUnit BaseUnit Material Base Unit
NonFerrousPhysicalWeight NonFerrousPhysicalWeight Total Structural Weight
NonFerrousPhysWgtRefQty NonFerrousPhysWgtRefQty
Currency Currency Valuation Crcy
NonFerrousChargeValueInCCCrcy NonFerrousChargeValueInCCCrcy Charge value in company code currency
NonFerrousStrucValueInCCCrcy NonFerrousStrucValueInCCCrcy Struct. value in company code currency
NonFerrousPurValueInCCCrcy NonFerrousPurValueInCCCrcy Purchasing value in company code curr.
NonFerrousRateInCCrcy NonFerrousRateInCCrcy Rate in company code currency
NonFerrousBaseValueInCCCrcy NonFerrousBaseValueInCCCrcy Base value in company code currency
NonFerrousReportingBaseAmount NonFerrousReportingBaseAmount Reporting Base in company code currency
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentTypeLangDepdnt SalesDocumentTypeLangDepdnt
CreationDate CreationDate Time Stamp
Material Material Vehicle Model
OrderQuantity OrderQuantity Quantity
SalesUnit SalesUnit Unit
SoldToParty SoldToParty Sold-to Party
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
Plant Plant Valuation Area
NonFerrousBillgAndInvcgBlkgRsn NonFerrousBillgAndInvcgBlkgRsn
NonFerrousBaseAmtDocCurrency NonFerrousBaseAmtDocCurrency
NonFerrousMarketRateInDocCrcy NonFerrousMarketRateInDocCrcy Rate in document currency
NonFerrousBaseAmtInDocCrcy NonFerrousBaseAmtInDocCrcy Base value in Document Currency
NonFerrousNetRateAmount NonFerrousNetRateAmount Net Rate in Document Currency
NonFerrousCommodityExchCode NonFerrousCommodityExchCode
NonFerrousRateAmount NonFerrousRateAmount Rate in rate currency
NonFerrousRateAmountCurrency NonFerrousRateAmountCurrency
NonFerrousRateBasisQuantity NonFerrousRateBasisQuantity
NonFerrousRateCnvrsnFactor NonFerrousRateCnvrsnFactor
NonFerrousRateIsIndrctQtan NonFerrousRateIsIndrctQtan NF Rate in indirect Quotation
NonFerrousCurrencyCnvrsnRate NonFerrousCurrencyCnvrsnRate
NonFerrousExchRateIsIndrctQtan NonFerrousExchRateIsIndrctQtan Exchange Rate in indirect quotation
NonFerrousRateDeterminationKey NonFerrousRateDeterminationKey
NonFerrousLastRateDate NonFerrousLastRateDate
NonFerrousRDKDate NonFerrousRDKDate
EntryDateYearMonth EntryDateYearMonth
NonFerrousBaseCode NonFerrousBaseCode
NonFerrousBaseAmount NonFerrousBaseAmount Base Value in Base Value Currency
NonFerrousBaseAmountCurrency NonFerrousBaseAmountCurrency
NonFerrousBaseAmtCnvrsnRate NonFerrousBaseAmtCnvrsnRate
NonFerrousBaseRateIsIndrctQtan NonFerrousBaseRateIsIndrctQtan Base Rate indirect quotation
NonFerrousRateProcSurchrgInPct NonFerrousRateProcSurchrgInPct
NonFerrousCoverageBusPartner NonFerrousCoverageBusPartner
NonFerrousCoverageCode NonFerrousCoverageCode
NonFerrousCoverageQuantity NonFerrousCoverageQuantity
NonFerrousProvisionBusPartner NonFerrousProvisionBusPartner
NonFerrousProvisionedQuantity NonFerrousProvisionedQuantity
NonFerrousProvisionDiscount NonFerrousProvisionDiscount
NonFerrousRateIsStatistical NonFerrousRateIsStatistical
NonFerrousBaseAmtIsStstclPrice NonFerrousBaseAmtIsStstclPrice
NonFerrousCvrgIsUsingPhysWgt NonFerrousCvrgIsUsingPhysWgt
NonFerrousNumberOfPostingDays NonFerrousNumberOfPostingDays
NonFerrousBaseAmtIsChgdManual NonFerrousBaseAmtIsChgdManual
NonFerrousPreviousBaseAmount NonFerrousPreviousBaseAmount
NonFerrousIsProvisioned NonFerrousIsProvisioned
NonFerrousRateDetnIsCompleted NonFerrousRateDetnIsCompleted
NonFerrousSurchargeBaseAmount NonFerrousSurchargeBaseAmount
PricingDocumentItem PricingDocumentItem Item
NonFerrousPhysicalWeightIsMiss NonFerrousPhysicalWeightIsMiss
NonFerrousPostgIsBlkdByMisgWgt NonFerrousPostgIsBlkdByMisgWgt
NonFerrousPurDocItemIsDeleted NonFerrousPurDocItemIsDeleted
SalesDocumentTypeName SalesDocumentTypeName
SalesDocumentExTypeName SalesDocumentExTypeName
NonFerrousCodeText
NonFerrousMatlDocumentCatText
NonFerrousCmmdtyExchCodeText
BillingBlockReasonDescription
NonFerrousRDKText
_ChargeWeight _ChargeWeight
_ExchangeKeyVH _ExchangeKeyVH
_NonFerrousMetalKeyVH _NonFerrousMetalKeyVH
_SalesDocumentTypeLangDepdnt _SalesDocumentTypeLangDepdnt
_SalesOrganizationText _SalesOrganizationText
_DocumentCatVH _DocumentCatVH
_BillingBlockReason _BillingBlockReason
_NonFerrousRateDetnKeyVH _NonFerrousRateDetnKeyVH

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_NonFerrousMatSlsDocItmTP.
-- 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_NonFerrousMatSlsDocItmTP AS
SELECT
  NonFerrousMatlDocumentCategory,
  CompanyCode,
  SalesOrganization,
  NonFerrousCode,
  NonFerrousMatlDocumentRef,
  NonFerrousMatlDocumentRefItem,
  PostingFiscalYear,
  MaterialBaseUnit,
  TotalNonFerrousChargeWeight,
  NonFerrousWeight,
  NonFerrousWgtBsRefQtyInBaseUoM,
  BaseUnit,
  NonFerrousPhysicalWeight,
  NonFerrousPhysWgtRefQty,
  Currency,
  NonFerrousChargeValueInCCCrcy,
  NonFerrousStrucValueInCCCrcy,
  NonFerrousPurValueInCCCrcy,
  NonFerrousRateInCCrcy,
  NonFerrousBaseValueInCCCrcy,
  NonFerrousReportingBaseAmount,
  SalesDocumentType,
  SalesDocumentTypeLangDepdnt,
  CreationDate,
  Material,
  OrderQuantity,
  SalesUnit,
  SoldToParty,
  DistributionChannel,
  Division,
  Plant,
  NonFerrousBillgAndInvcgBlkgRsn,
  NonFerrousBaseAmtDocCurrency,
  NonFerrousMarketRateInDocCrcy,
  NonFerrousBaseAmtInDocCrcy,
  NonFerrousNetRateAmount,
  NonFerrousCommodityExchCode,
  NonFerrousRateAmount,
  NonFerrousRateAmountCurrency,
  NonFerrousRateBasisQuantity,
  NonFerrousRateCnvrsnFactor,
  NonFerrousRateIsIndrctQtan,
  NonFerrousCurrencyCnvrsnRate,
  NonFerrousExchRateIsIndrctQtan,
  NonFerrousRateDeterminationKey,
  NonFerrousLastRateDate,
  NonFerrousRDKDate,
  EntryDateYearMonth,
  NonFerrousBaseCode,
  NonFerrousBaseAmount,
  NonFerrousBaseAmountCurrency,
  NonFerrousBaseAmtCnvrsnRate,
  NonFerrousBaseRateIsIndrctQtan,
  NonFerrousRateProcSurchrgInPct,
  NonFerrousCoverageBusPartner,
  NonFerrousCoverageCode,
  NonFerrousCoverageQuantity,
  NonFerrousProvisionBusPartner,
  NonFerrousProvisionedQuantity,
  NonFerrousProvisionDiscount,
  NonFerrousRateIsStatistical,
  NonFerrousBaseAmtIsStstclPrice,
  NonFerrousCvrgIsUsingPhysWgt,
  NonFerrousNumberOfPostingDays,
  NonFerrousBaseAmtIsChgdManual,
  NonFerrousPreviousBaseAmount,
  NonFerrousIsProvisioned,
  NonFerrousRateDetnIsCompleted,
  NonFerrousSurchargeBaseAmount,
  PricingDocumentItem,
  NonFerrousPhysicalWeightIsMiss,
  NonFerrousPostgIsBlkdByMisgWgt,
  NonFerrousPurDocItemIsDeleted,
  SalesDocumentTypeName,
  SalesDocumentExTypeName,
  _NonFerrousMetalKeyVH._Text[1:Language=$session.system_language].NonFerrousCodeText AS NonFerrousCodeText,
  _DocumentCatVH._Text[1:Language=$session.system_language].NonFerrousMatlDocumentCatText AS NonFerrousMatlDocumentCatText,
  _ExchangeKeyVH._Text[1:Language=$session.system_language].NonFerrousCmmdtyExchCodeText AS NonFerrousCmmdtyExchCodeText,
  _BillingBlockReason._Text[1:Language=$session.system_language].BillingBlockReasonDescription AS BillingBlockReasonDescription,
  _NonFerrousRateDetnKeyVH._Text[1:Language=$session.system_language].NonFerrousRDKText AS NonFerrousRDKText
FROM I_NonFerrousMatSalesDocItem
;

Learn More