C_RFM_PrvsnlSlsContrItm

Provisional Sales Contract Item | view: CRFMPRVSNLITM | TRAN | Extraction: Not supported | Component: Retail & Fashion Sales and Distribution
Tables used: VBAK, VBAP, VBKD, VBPA, MARA, KNA1, T001W, MARA, WRF_CHARVALT, MARC, TVAK
Column Name Description
SalesContract FK Sales Document
SalesContractItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderQuantity Cumulative order quantity in sales units
RequestedQuantityInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
UnconfirmedQuantityInBaseUnit null
ContractItmCnsmdQtyInBsUnt null
AssignedQuantityInBaseUnit null
SupAssgmtReservedQtyInBaseUnit null
Column Name Description
CreationDate Date on which the record was created
CustomerPurchaseOrderDate Customer Reference Date
SalesDocumentDate Document Date (Date Received/Sent)
AgrmtValdtyStartDate Valid-From Date (Outline Agreements, Product Proposals)
AgrmtValdtyEndDate Valid-To Date (Outline Agreements, Product Proposals)
FashionCancelDate Cancellation Date
RequestedDeliveryDate Requested Delivery Date
FirstDeliveryDate Item delivery date
BillingDocumentDate Billing Date
PricingDate Date for Pricing and Exchange Rate
Column Name Description
RqmtIsSupAssgmtRelevant Indicates if Supply Assignment is Relevant for Item Show values
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
SalesDocumentHasRejection Checkbox Show values
ARunDocumentStatus ARun Document Status Show values
SeasonCompletenessStatus Season Completeness Indicator Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
ItemHasValueAddedService VAS Relevant Show values
Column Name Description Domain name
FormattedSalesDocumentItem Sales Document Item CHAR17
CreatedByUser Name of Person Responsible for Creating the Object USNAM
RequirementSegment Requirement Segment SGT_SRCA
Plant Plant (Own or External) WERKS
CustomerPaymentTerms Terms of payment key ZTERM
IncotermsLocation1 Incoterms Location 1 INCO_L
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic1Desc Characteristic value description ATWRT
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic2Desc Characteristic value description ATWRT
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
ProductCharacteristic3Desc Characteristic value description ATWRT
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
ConfdReqdRqmtQtyRatioPct null
AssgdReqdRqmtQtyRatioPct null
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
ARunDocumentStatusText Explanatory Short Text DDTEXT
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
ARunDocumentItemUniqueID Sales Document Item CHAR17
MaterialByCustomer Material Number Used by Customer IDNEX
Master Data Relations Join Conditions
Material Group 1
  • Material Group 1
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVM2.MANDT
Material Group 3
  • Material Group 3
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.BASEUNIT == T006.MSEHI
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Material Number
  • Plant (Own or External)
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.BATCH == MCHA.CHARG
  • C_RFM_PRVSNLSLSCONTRITM.MATERIAL == MCHA.MATNR
  • C_RFM_PRVSNLSLSCONTRITM.PLANT == MCHA.WERKS
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == MCHA.MANDT
Customer condition group 1
  • Customer condition group 1
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKGG.MANDT
Customer condition group 2
  • Customer condition group 2
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKGG.MANDT
Customer condition group 3
  • Customer condition group 3
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKGG.MANDT
Customer condition group 4
  • Customer condition group 4
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKGG.MANDT
Customer condition group 5
  • Customer condition group 5
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKGG.MANDT
Customer Group
  • Customer Group
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERGROUP == T151.KDGRP
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T188.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T176.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TPRIO.MANDT
Department number
  • Department number
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.DEPARTMENTCLASSIFICATIONBYCUST == TSAB.ABTNR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TSAB.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == TVKOV.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKOV.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TINC.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T148.MANDT
Material: order item
  • Material Number
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.MATERIAL == MARA.MATNR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == MARA.MANDT
Material Price Group
  • Material Price Group
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.MATERIALPRICINGGROUP == T178.KONDM
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T178.MANDT
Sales unit
  • Sales unit
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.ORDERQUANTITYUNIT == T006.MSEHI
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T006.MANDT
Division in order header
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_RFM_PRVSNLSLSCONTRITM.ORGANIZATIONDIVISION == TVTA.SPART
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == TVTA.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVTA.MANDT
Fashion Collection
  • Season
  • Season Year
  • Fashion Collection
  • Client
Product Group
  • Product Group
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTGROUP == T023.MATKL
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T023.MANDT
Season
  • Season
  • Season Year
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season
  • Season Year
  • Fashion Collection
  • Fashion Theme
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_RFM_PRVSNLSLSCONTRITM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_THEMES.MANDT
Customer Group 10
  • Customer Group 10
  • Sales Organization
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.RETAILADDITIONALCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == FSH_TVV10.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_TVV10.MANDT
Customer Group 6
  • Customer Group 6
  • Sales Organization
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.RETAILADDITIONALCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == FSH_TVV6.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_TVV6.MANDT
Customer Group 7
  • Customer Group 7
  • Sales Organization
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.RETAILADDITIONALCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == FSH_TVV7.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_TVV7.MANDT
Customer Group 8
  • Sales Organization
  • Customer Group 8
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == FSH_TVV8.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.RETAILADDITIONALCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_TVV8.MANDT
Customer Group 9
  • Sales Organization
  • Customer Group 9
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == FSH_TVV9.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.RETAILADDITIONALCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == FSH_TVV9.MANDT
Route
  • Route
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.ROUTE == TVRO.ROUTE
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVRO.MANDT
Sales District
  • Sales District
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESDISTRICT == T171.BZIRK
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVAG.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESDOCUMENTTYPE == TVAK.AUART
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVAK.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESOFFICE == TVBVK.VKBUR
  • C_RFM_PRVSNLSLSCONTRITM.SALESGROUP == TVBVK.VKGRP
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == TVKO.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SDDOCUMENTREASON == TVAU.AUGRU
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVAU.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SHIPPINGCONDITION == TVSB.VSBED
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SHIPPINGPOINT == TVST.VSTEL
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVST.MANDT
Shipping Type
  • Shipping Type
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SHIPPINGTYPE == T173.VSART
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T173.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SOLDTOPARTY == KNA1.KUNNR
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == KNA1.MANDT
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.STORAGELOCATION == T001L.LGORT
  • C_RFM_PRVSNLSLSCONTRITM.PLANT == T001L.WERKS
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == T001L.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • C_RFM_PRVSNLSLSCONTRITM.SALESOFFICE == TVKBZ.VKBUR
  • C_RFM_PRVSNLSLSCONTRITM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_RFM_PRVSNLSLSCONTRITM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_RFM_PRVSNLSLSCONTRITM.SALESORGANIZATION == TVKBZ.VKORG
  • C_RFM_PRVSNLSLSCONTRITM.MANDT == TVKBZ.MANDT