I_RFM_SALESDOCUMENTITEM
Sales Document Item
I_RFM_SALESDOCUMENTITEM is a CDS View in S/4HANA. Sales Document Item. It contains 156 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_RFM_MaSaDoSlsItmCustBasic | view | from | CONSUMPTION | Sales Document Item and Customer Details |
| I_ExcessRqmtQtySlsDocMainItm | view | from | BASIC | Sales Document Main(Non Value Added Service) Items |
| I_ExssRqmtMultiShipToOrdItm | view | from | BASIC | Sales Document Main MSO Items |
| I_RFM_MaSaDoSlsDocumentItm | view | from | BASIC | Sales Document Item |
| I_RFM_PrvsnlSlsContrDocItm | view | from | COMPOSITE | Provisional Sales Contract Document Item |
| I_RFM_SlsOrdPrgrsMntrGnrcItm | view | from | COMPOSITE | Sales Order Generic Article item details |
| I_RFM_SlsOrdPrgrsMntrItm | view | from | COMPOSITE | Sales Order item details |
Fields (156)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SalesDocument | SalesContract,SalesDocument,SalesOrder | 4 |
| KEY | SalesDocumentItem | SalesContractItem,SalesDocumentItem,SalesOrderItem | 4 |
| _AdditionalCustomerGroup1 | _AdditionalCustomerGroup1 | 1 | |
| _AdditionalCustomerGroup2 | _AdditionalCustomerGroup2 | 1 | |
| _AdditionalCustomerGroup3 | _AdditionalCustomerGroup3 | 1 | |
| _AdditionalCustomerGroup4 | _AdditionalCustomerGroup4 | 1 | |
| _AdditionalCustomerGroup5 | _AdditionalCustomerGroup5 | 1 | |
| _AdditionalMaterialGroup1 | _AdditionalMaterialGroup1 | 1 | |
| _AdditionalMaterialGroup2 | _AdditionalMaterialGroup2 | 1 | |
| _AdditionalMaterialGroup3 | _AdditionalMaterialGroup3 | 1 | |
| _AdditionalMaterialGroup4 | _AdditionalMaterialGroup4 | 1 | |
| _AdditionalMaterialGroup5 | _AdditionalMaterialGroup5 | 1 | |
| _BaseUnit | _BaseUnit | 1 | |
| _Batch | _Batch | 1 | |
| _ContactPersonStdDepartment | _ContactPersonStdDepartment | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerPaymentTerms | _CustomerPaymentTerms | 1 | |
| _CustomerPriceGroup | _CustomerPriceGroup | 1 | |
| _CustomerPurchaseOrderType | _CustomerPurchaseOrderType | 1 | |
| _DeliveryBlockReason | _DeliveryBlockReason | 1 | |
| _DeliveryPriority | _DeliveryPriority | 1 | |
| _HeaderBillingBlockReason | _HeaderBillingBlockReason | 1 | |
| _IncotermsClassification | _IncotermsClassification | 1 | |
| _ItemBillingIncompletionStatus | _ItemBillingIncompletionStatus | 1 | |
| _ItemCategory | _ItemCategory | 1 | |
| _ItemDelivIncompletionSts | _ItemDelivIncompletionSts | 1 | |
| _ItemGeneralIncompletionStatus | _ItemGeneralIncompletionStatus | 1 | |
| _MaterialPricingGroup | _MaterialPricingGroup | 1 | |
| _MaterialText | _MaterialText | 1 | |
| _OrderQuantityUnit | _OrderQuantityUnit | 1 | |
| _Plant | _Plant | 1 | |
| _PricingIncompletionStatus | _PricingIncompletionStatus | 1 | |
| _Product | _Product | 1 | |
| _ProductGroup | _ProductGroup | 1 | |
| _RetailAddlCustGrp10 | _RetailAddlCustGrp10 | 1 | |
| _RetailAddlCustGrp6 | _RetailAddlCustGrp6 | 1 | |
| _RetailAddlCustGrp7 | _RetailAddlCustGrp7 | 1 | |
| _RetailAddlCustGrp8 | _RetailAddlCustGrp8 | 1 | |
| _RetailAddlCustGrp9 | _RetailAddlCustGrp9 | 1 | |
| _Route | _Route | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesDocumentRjcnReason | _SalesDocumentRjcnReason | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SDDocumentReason | _SDDocumentReason | 1 | |
| _ShippingCondition | _ShippingCondition | 1 | |
| _ShippingPoint | _ShippingPoint | 1 | |
| _ShippingPointText | _ShippingPointText | 1 | |
| _ShippingType | _ShippingType | 1 | |
| _SoldToParty | _SoldToParty | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 1 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 1 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 1 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 1 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 1 | |
| AdditionalMaterialGroup1 | AdditionalMaterialGroup1 | 1 | |
| AdditionalMaterialGroup2 | AdditionalMaterialGroup2 | 1 | |
| AdditionalMaterialGroup3 | AdditionalMaterialGroup3 | 1 | |
| AdditionalMaterialGroup4 | AdditionalMaterialGroup4 | 1 | |
| AdditionalMaterialGroup5 | AdditionalMaterialGroup5 | 1 | |
| AgrmtValdtyEndDate | AgrmtValdtyEndDate | 1 | |
| AgrmtValdtyStartDate | AgrmtValdtyStartDate | 1 | |
| BaseUnit | BaseUnit | 1 | |
| Batch | Batch | 1 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| ConfdDelivQtyInOrderQtyUnit | ConfdDelivQtyInOrderQtyUnit | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CustomerConditionGroup1 | CustomerConditionGroup1 | 1 | |
| CustomerConditionGroup2 | CustomerConditionGroup2 | 1 | |
| CustomerConditionGroup3 | CustomerConditionGroup3 | 1 | |
| CustomerConditionGroup4 | CustomerConditionGroup4 | 1 | |
| CustomerConditionGroup5 | CustomerConditionGroup5 | 1 | |
| CustomerGroup | CustomerGroup,SalesOrderCustomerGroup | 2 | |
| CustomerPaymentTerms | CustomerPaymentTerms,SlsOrdCustomerPaymentTerms | 2 | |
| CustomerPriceGroup | CustomerPriceGroup,SalesOrderCustomerPriceGroup | 2 | |
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | 1 | |
| CustomerPurchaseOrderType | CustomerPurchaseOrderType | 1 | |
| DeliveryBlockReason | DeliveryBlockReason | 1 | |
| DeliveryPriority | DeliveryPriority,SalesOrderDeliveryPriority | 2 | |
| DeliveryStatus | DeliveryStatus | 1 | |
| DepartmentClassificationByCust | DepartmentClassificationByCust | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| FashionCancelDate | FashionCancelDate | 1 | |
| HdrGeneralIncompletionStatus | HdrGeneralIncompletionStatus | 1 | |
| HeaderBillgIncompletionStatus | HeaderBillgIncompletionStatus | 1 | |
| HeaderBillingBlockReason | HeaderBillingBlockReason | 1 | |
| HeaderDelivIncompletionStatus | HeaderDelivIncompletionStatus | 1 | |
| HigherLevelItem | HigherLevelItem | 1 | |
| IncotermsClassification | IncotermsClassification,SlsOrdIncotermsClassification | 2 | |
| IncotermsLocation1 | IncotermsLocation1,SlsOrdIncotermsLocation1 | 2 | |
| InventorySpecialStockType | InventorySpecialStockType | 1 | |
| ItemBillingIncompletionStatus | ItemBillingIncompletionStatus | 1 | |
| ItemDeliveryIncompletionStatus | ItemDeliveryIncompletionStatus | 1 | |
| ItemGeneralIncompletionStatus | ItemGeneralIncompletionStatus | 1 | |
| ItemHasValueAddedService | ItemHasValueAddedService | 1 | |
| Material | Material | 1 | |
| MaterialByCustomer | MaterialByCustomer | 1 | |
| MaterialPricingGroup | MaterialPricingGroup | 1 | |
| NetAmount | NetAmount | 1 | |
| OrderQuantity | OrderQuantity | 1 | |
| OrderQuantityUnit | OrderQuantityUnit | 1 | |
| OrderRelatedBillingStatus | OrderRelatedBillingStatus | 1 | |
| OrderToBaseQuantityDnmntr | OrderToBaseQuantityDnmntr | 1 | |
| OrderToBaseQuantityNmrtr | OrderToBaseQuantityNmrtr | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| OverallPricingIncompletionSts | OverallPricingIncompletionSts | 1 | |
| OverallSDProcessStatus | OverallSDProcessStatus | 1 | |
| OverallTotalDeliveryStatus | OverallTotalDeliveryStatus | 1 | |
| OvrlItmBillingIncompletionSts | OvrlItmBillingIncompletionSts | 1 | |
| OvrlItmDelivIncompletionSts | OvrlItmDelivIncompletionSts | 1 | |
| OvrlItmGeneralIncompletionSts | OvrlItmGeneralIncompletionSts | 1 | |
| Plant | Plant | 1 | |
| PricingDate | PricingDate | 1 | |
| PricingIncompletionStatus | PricingIncompletionStatus | 1 | |
| ProductCharacteristic1 | ProductCharacteristic1 | 1 | |
| ProductCharacteristic2 | ProductCharacteristic2 | 1 | |
| ProductCharacteristic3 | ProductCharacteristic3 | 1 | |
| ProductCollection | ProductCollection | 1 | |
| ProductGroup | ProductGroup | 1 | |
| ProductSeason | ProductSeason | 1 | |
| ProductSeasonYear | ProductSeasonYear | 1 | |
| ProductTheme | ProductTheme | 1 | |
| RequestedDeliveryDate | RequestedDeliveryDate | 4 | |
| RequirementSegment | RequirementSegment | 1 | |
| RetailAdditionalCustomerGrp10 | RetailAdditionalCustomerGrp10 | 1 | |
| RetailAdditionalCustomerGrp6 | RetailAdditionalCustomerGrp6 | 1 | |
| RetailAdditionalCustomerGrp7 | RetailAdditionalCustomerGrp7 | 1 | |
| RetailAdditionalCustomerGrp8 | RetailAdditionalCustomerGrp8 | 1 | |
| RetailAdditionalCustomerGrp9 | RetailAdditionalCustomerGrp9 | 1 | |
| Route | Route | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocumentDate | SalesDocumentDate | 1 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 1 | |
| SalesDocumentRjcnReason | SalesDocumentRjcnReason | 1 | |
| SalesDocumentType | SalesDocumentType | 1 | |
| SalesGroup | SalesGroup | 1 | |
| SalesOffice | SalesOffice | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| SDDocumentCategory | SDDocumentCategory | 1 | |
| SDDocumentReason | SDDocumentReason | 1 | |
| SeasonCompletenessStatus | SeasonCompletenessStatus | 1 | |
| ShippingCondition | ShippingCondition | 1 | |
| ShippingGroupNumber | ShippingGroupNumber | 1 | |
| ShippingGroupRule | ShippingGroupRule | 1 | |
| ShippingPoint | ShippingPoint | 1 | |
| ShippingType | ShippingType | 1 | |
| ShipToParty | ShipToParty | 2 | |
| SoldToParty | SoldToParty | 1 | |
| StorageLocation | StorageLocation | 1 | |
| TotalBlockStatus | TotalBlockStatus | 1 | |
| TotalCreditCheckStatus | TotalCreditCheckStatus | 1 | |
| TransactionCurrency | TransactionCurrency | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Sales Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RFM_SALESDOCUMENTITEM (
SALESDOCUMENT,
SALESDOCUMENTITEM,
_ADDITIONALCUSTOMERGROUP1,
_ADDITIONALCUSTOMERGROUP2,
_ADDITIONALCUSTOMERGROUP3,
_ADDITIONALCUSTOMERGROUP4,
_ADDITIONALCUSTOMERGROUP5,
_ADDITIONALMATERIALGROUP1,
_ADDITIONALMATERIALGROUP2,
_ADDITIONALMATERIALGROUP3,
_ADDITIONALMATERIALGROUP4,
_ADDITIONALMATERIALGROUP5,
_BASEUNIT,
_BATCH,
_CONTACTPERSONSTDDEPARTMENT,
_CUSTOMERGROUP,
_CUSTOMERPAYMENTTERMS,
_CUSTOMERPRICEGROUP,
_CUSTOMERPURCHASEORDERTYPE,
_DELIVERYBLOCKREASON,
_DELIVERYPRIORITY,
_HEADERBILLINGBLOCKREASON,
_INCOTERMSCLASSIFICATION,
_ITEMBILLINGINCOMPLETIONSTATUS,
_ITEMCATEGORY,
_ITEMDELIVINCOMPLETIONSTS,
_ITEMGENERALINCOMPLETIONSTATUS,
_MATERIALPRICINGGROUP,
_MATERIALTEXT,
_ORDERQUANTITYUNIT,
_PLANT,
_PRICINGINCOMPLETIONSTATUS,
_PRODUCT,
_PRODUCTGROUP,
_RETAILADDLCUSTGRP10,
_RETAILADDLCUSTGRP6,
_RETAILADDLCUSTGRP7,
_RETAILADDLCUSTGRP8,
_RETAILADDLCUSTGRP9,
_ROUTE,
_SALESDISTRICT,
_SALESDOCUMENT,
_SALESDOCUMENTRJCNREASON,
_SALESGROUP,
_SALESOFFICE,
_SDDOCUMENTREASON,
_SHIPPINGCONDITION,
_SHIPPINGPOINT,
_SHIPPINGPOINTTEXT,
_SHIPPINGTYPE,
_SOLDTOPARTY,
_STORAGELOCATION,
_TRANSACTIONCURRENCY,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALMATERIALGROUP1,
ADDITIONALMATERIALGROUP2,
ADDITIONALMATERIALGROUP3,
ADDITIONALMATERIALGROUP4,
ADDITIONALMATERIALGROUP5,
AGRMTVALDTYENDDATE,
AGRMTVALDTYSTARTDATE,
BASEUNIT,
BATCH,
BILLINGDOCUMENTDATE,
CONFDDELIVQTYINORDERQTYUNIT,
CREATEDBYUSER,
CREATIONDATE,
CUSTOMERCONDITIONGROUP1,
CUSTOMERCONDITIONGROUP2,
CUSTOMERCONDITIONGROUP3,
CUSTOMERCONDITIONGROUP4,
CUSTOMERCONDITIONGROUP5,
CUSTOMERGROUP,
CUSTOMERPAYMENTTERMS,
CUSTOMERPRICEGROUP,
CUSTOMERPURCHASEORDERDATE,
CUSTOMERPURCHASEORDERTYPE,
DELIVERYBLOCKREASON,
DELIVERYPRIORITY,
DELIVERYSTATUS,
DEPARTMENTCLASSIFICATIONBYCUST,
DISTRIBUTIONCHANNEL,
FASHIONCANCELDATE,
HDRGENERALINCOMPLETIONSTATUS,
HEADERBILLGINCOMPLETIONSTATUS,
HEADERBILLINGBLOCKREASON,
HEADERDELIVINCOMPLETIONSTATUS,
HIGHERLEVELITEM,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INVENTORYSPECIALSTOCKTYPE,
ITEMBILLINGINCOMPLETIONSTATUS,
ITEMDELIVERYINCOMPLETIONSTATUS,
ITEMGENERALINCOMPLETIONSTATUS,
ITEMHASVALUEADDEDSERVICE,
MATERIAL,
MATERIALBYCUSTOMER,
MATERIALPRICINGGROUP,
NETAMOUNT,
ORDERQUANTITY,
ORDERQUANTITYUNIT,
ORDERRELATEDBILLINGSTATUS,
ORDERTOBASEQUANTITYDNMNTR,
ORDERTOBASEQUANTITYNMRTR,
ORGANIZATIONDIVISION,
OVERALLPRICINGINCOMPLETIONSTS,
OVERALLSDPROCESSSTATUS,
OVERALLTOTALDELIVERYSTATUS,
OVRLITMBILLINGINCOMPLETIONSTS,
OVRLITMDELIVINCOMPLETIONSTS,
OVRLITMGENERALINCOMPLETIONSTS,
PLANT,
PRICINGDATE,
PRICINGINCOMPLETIONSTATUS,
PRODUCTCHARACTERISTIC1,
PRODUCTCHARACTERISTIC2,
PRODUCTCHARACTERISTIC3,
PRODUCTCOLLECTION,
PRODUCTGROUP,
PRODUCTSEASON,
PRODUCTSEASONYEAR,
PRODUCTTHEME,
REQUESTEDDELIVERYDATE,
REQUIREMENTSEGMENT,
RETAILADDITIONALCUSTOMERGRP10,
RETAILADDITIONALCUSTOMERGRP6,
RETAILADDITIONALCUSTOMERGRP7,
RETAILADDITIONALCUSTOMERGRP8,
RETAILADDITIONALCUSTOMERGRP9,
ROUTE,
SALESDISTRICT,
SALESDOCUMENTDATE,
SALESDOCUMENTITEMCATEGORY,
SALESDOCUMENTRJCNREASON,
SALESDOCUMENTTYPE,
SALESGROUP,
SALESOFFICE,
SALESORGANIZATION,
SDDOCUMENTCATEGORY,
SDDOCUMENTREASON,
SEASONCOMPLETENESSSTATUS,
SHIPPINGCONDITION,
SHIPPINGGROUPNUMBER,
SHIPPINGGROUPRULE,
SHIPPINGPOINT,
SHIPPINGTYPE,
SHIPTOPARTY,
SOLDTOPARTY,
STORAGELOCATION,
TOTALBLOCKSTATUS,
TOTALCREDITCHECKSTATUS,
TRANSACTIONCURRENCY,
PRIMARY KEY (SALESDOCUMENT, SALESDOCUMENTITEM)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA