I_RFM_SALESDOCUMENT

CDS View
112 Fields 4 CDS Views

Sales Document Basic

I_RFM_SALESDOCUMENT is a CDS View in S/4HANA. Sales Document Basic. It contains 112 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_RFM_MaSaDoSlsHdrCustBasic view from CONSUMPTION Sales Document and Customer Details
I_RFM_MaSaDoSlsDocumentHdr view from BASIC Sales Document Basic
I_RFM_PrvsnlSlsContrDocHdr view from BASIC Provisional Sales Contract Document Header
I_RFM_SlsOrdPrgrsMntrHdr view from COMPOSITE Sales Order header details

Fields (112)

KeyField CDS FieldsUsed in Views
KEY SalesDocument SalesContract,SalesOrder 2
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1 1
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2 1
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3 1
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4 1
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5 1
_ContactPersonStdDepartment _ContactPersonStdDepartment 1
_CreatedByUser _CreatedByUser 1
_CreditControlArea _CreditControlArea 1
_CreditControlAreaText _CreditControlAreaText 1
_CustomerGroup _CustomerGroup 1
_CustomerPaymentTerms _CustomerPaymentTerms 1
_CustomerPriceGroup _CustomerPriceGroup 1
_CustomerPurchaseOrderType _CustomerPurchaseOrderType 1
_DeliveryBlockReason _DeliveryBlockReason 1
_DistributionChannel _DistributionChannel 1
_EngagementProjectItem _EngagementProjectItem 1
_HdrGeneralIncompletionStatus _HdrGeneralIncompletionStatus 1
_HeaderBillgIncompletionStatus _HeaderBillgIncompletionStatus 1
_HeaderBillingBlockReason _HeaderBillingBlockReason 1
_HeaderDelivIncompletionStatus _HeaderDelivIncompletionStatus 1
_IncotermsClassification _IncotermsClassification 1
_OrganizationDivision _OrganizationDivision 1
_OverallPricingIncompletionSts _OverallPricingIncompletionSts 1
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_OverallTotalDeliveryStatus _OverallTotalDeliveryStatus 1
_OvrlItmBillingIncompletionSts _OvrlItmBillingIncompletionSts 1
_OvrlItmDelivIncompletionSts _OvrlItmDelivIncompletionSts 1
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts 1
_RetailAddlCustGrp10 _RetailAddlCustGrp10 1
_RetailAddlCustGrp6 _RetailAddlCustGrp6 1
_RetailAddlCustGrp7 _RetailAddlCustGrp7 1
_RetailAddlCustGrp8 _RetailAddlCustGrp8 1
_RetailAddlCustGrp9 _RetailAddlCustGrp9 1
_SalesArea _SalesArea 1
_SalesDistrict _SalesDistrict 1
_SalesDocumentType _SalesDocumentType 1
_SalesGroup _SalesGroup 1
_SalesOffice _SalesOffice 1
_SalesOrganization _SalesOrganization 1
_SDDocumentCategory _SDDocumentCategory 1
_SDDocumentReason _SDDocumentReason 1
_ShippingCondition _ShippingCondition 1
_ShippingType _ShippingType 1
_ShipToParty _ShipToParty 1
_SoldToParty _SoldToParty 1
_TotalBlockStatus _TotalBlockStatus 1
_TotalCreditCheckStatus _TotalCreditCheckStatus 1
AdditionalCustomerGroup1 AdditionalCustomerGroup1,SlsOrdAddlCustomerGroup1 2
AdditionalCustomerGroup2 AdditionalCustomerGroup2,SlsOrdAddlCustomerGroup2 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3,SlsOrdAddlCustomerGroup3 2
AdditionalCustomerGroup4 AdditionalCustomerGroup4,SlsOrdAddlCustomerGroup4 2
AdditionalCustomerGroup5 AdditionalCustomerGroup5,SlsOrdAddlCustomerGroup5 2
AgrmtValdtyEndDate SalesContractValidityEndDate 1
AgrmtValdtyStartDate SalesContractValidityStartDate 1
BillingDocumentDate BillingDocumentDate 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreditControlArea CreditControlArea 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
DepartmentClassificationByCust DepartmentClassificationByCust 1
DistributionChannel DistributionChannel 1
FashionCancelDate FashionCancelDate 1
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus 1
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus 1
HeaderBillingBlockReason HeaderBillingBlockReason 1
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus 1
IncotermsClassification IncotermsClassification,SlsOrdIncotermsClassification 2
IncotermsLocation1 IncotermsLocation1,SlsOrdIncotermsLocation1 2
OrganizationDivision OrganizationDivision 1
OverallPricingIncompletionSts OverallPricingIncompletionSts 1
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts 1
OverallSDProcessStatus OverallSDProcessStatus 1
OverallTotalDeliveryStatus OverallTotalDeliveryStatus 1
OvrlItmBillingIncompletionSts OvrlItmBillingIncompletionSts 1
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts 1
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts 1
PricingDate PricingDate 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RequestedDeliveryDate RequestedDeliveryDate 1
RetailAdditionalCustomerGrp10 RetailAdditionalCustomerGrp10,SlsOrdRetailAddlCustomerGrp10 2
RetailAdditionalCustomerGrp6 RetailAdditionalCustomerGrp6,SlsOrdRetailAddlCustomerGrp6 2
RetailAdditionalCustomerGrp7 RetailAdditionalCustomerGrp7,SlsOrdRetailAddlCustomerGrp7 2
RetailAdditionalCustomerGrp8 RetailAdditionalCustomerGrp8,SlsOrdRetailAddlCustomerGrp8 2
RetailAdditionalCustomerGrp9 RetailAdditionalCustomerGrp9,SlsOrdRetailAddlCustomerGrp9 2
SalesDistrict SalesDistrict,SalesOrderSalesDistrict 2
SalesDocumentDate SalesDocumentDate 1
SalesDocumentType SalesDocumentType 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice,SlsOrdSalesOffice 2
SalesOrganization SalesOrganization 1
SDDocumentCategory SDDocumentCategory 1
SDDocumentReason SDDocumentReason 1
ShippingCondition ShippingCondition,SlsOrdShippingCondition 2
ShippingType ShippingType 1
ShipToParty ShipToParty 1
SoldToParty SoldToParty 1
TotalBlockStatus TotalBlockStatus 1
TotalCreditCheckStatus TotalCreditCheckStatus 1
TotalNetAmount TotalNetAmount 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 Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RFM_SALESDOCUMENT (
    SALESDOCUMENT,
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _CONTACTPERSONSTDDEPARTMENT,
    _CREATEDBYUSER,
    _CREDITCONTROLAREA,
    _CREDITCONTROLAREATEXT,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _CUSTOMERPURCHASEORDERTYPE,
    _DELIVERYBLOCKREASON,
    _DISTRIBUTIONCHANNEL,
    _ENGAGEMENTPROJECTITEM,
    _HDRGENERALINCOMPLETIONSTATUS,
    _HEADERBILLGINCOMPLETIONSTATUS,
    _HEADERBILLINGBLOCKREASON,
    _HEADERDELIVINCOMPLETIONSTATUS,
    _INCOTERMSCLASSIFICATION,
    _ORGANIZATIONDIVISION,
    _OVERALLPRICINGINCOMPLETIONSTS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVERALLTOTALDELIVERYSTATUS,
    _OVRLITMBILLINGINCOMPLETIONSTS,
    _OVRLITMDELIVINCOMPLETIONSTS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _RETAILADDLCUSTGRP10,
    _RETAILADDLCUSTGRP6,
    _RETAILADDLCUSTGRP7,
    _RETAILADDLCUSTGRP8,
    _RETAILADDLCUSTGRP9,
    _SALESAREA,
    _SALESDISTRICT,
    _SALESDOCUMENTTYPE,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SDDOCUMENTCATEGORY,
    _SDDOCUMENTREASON,
    _SHIPPINGCONDITION,
    _SHIPPINGTYPE,
    _SHIPTOPARTY,
    _SOLDTOPARTY,
    _TOTALBLOCKSTATUS,
    _TOTALCREDITCHECKSTATUS,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    AGRMTVALDTYENDDATE,
    AGRMTVALDTYSTARTDATE,
    BILLINGDOCUMENTDATE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREDITCONTROLAREA,
    CUSTOMERCONDITIONGROUP1,
    CUSTOMERCONDITIONGROUP2,
    CUSTOMERCONDITIONGROUP3,
    CUSTOMERCONDITIONGROUP4,
    CUSTOMERCONDITIONGROUP5,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERPURCHASEORDERTYPE,
    DELIVERYBLOCKREASON,
    DEPARTMENTCLASSIFICATIONBYCUST,
    DISTRIBUTIONCHANNEL,
    FASHIONCANCELDATE,
    HDRGENERALINCOMPLETIONSTATUS,
    HEADERBILLGINCOMPLETIONSTATUS,
    HEADERBILLINGBLOCKREASON,
    HEADERDELIVINCOMPLETIONSTATUS,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    ORGANIZATIONDIVISION,
    OVERALLPRICINGINCOMPLETIONSTS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALDELIVERYSTATUS,
    OVRLITMBILLINGINCOMPLETIONSTS,
    OVRLITMDELIVINCOMPLETIONSTS,
    OVRLITMGENERALINCOMPLETIONSTS,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDDELIVERYDATE,
    RETAILADDITIONALCUSTOMERGRP10,
    RETAILADDITIONALCUSTOMERGRP6,
    RETAILADDITIONALCUSTOMERGRP7,
    RETAILADDITIONALCUSTOMERGRP8,
    RETAILADDITIONALCUSTOMERGRP9,
    SALESDISTRICT,
    SALESDOCUMENTDATE,
    SALESDOCUMENTTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SDDOCUMENTREASON,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    SHIPTOPARTY,
    SOLDTOPARTY,
    TOTALBLOCKSTATUS,
    TOTALCREDITCHECKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESDOCUMENT)
);

Learn More