I_SALESDOCUMENTTYPE
Sales Document Type
I_SALESDOCUMENTTYPE is a CDS View in S/4HANA. Sales Document Type. It contains 2 fields. 50 CDS views read from this table.
CDS Views using this table (50)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_SalesOrderType | view | from | BASIC | Sales Order type |
| C_CreditMemoRequestTypeVH | view_entity | from | CONSUMPTION | Credit Memo Request Type |
| C_CustomerReturnTypeVH | view_entity | from | CONSUMPTION | Returns Order Type |
| C_DebitMemoRequestTypeVH | view_entity | from | CONSUMPTION | Debit Memo Request Type |
| C_DplSlsDocTypeVH | view | from | CONSUMPTION | Type of Duplicate Sales Document |
| C_Incompl_SalesDocTypeVH | view | from | CONSUMPTION | Sales Document Types |
| C_NonFerrousSalesDocTypeVH | view_entity | from | CONSUMPTION | Document Type |
| C_PartnerFuncBySalesDocTypeVH | view | from | CONSUMPTION | Partner Function By Sales Doc Type |
| C_PrdtdDelivDelaySlsDocTypeVH | view | from | CONSUMPTION | Sales Document Type |
| C_PrtnFuncBySlsContractTypeVH | view | from | CONSUMPTION | Partner Function By Sales Contract Type |
| C_SalesContractTypeValueHelp | view | from | CONSUMPTION | Sales Contract Specific Document Types |
| C_SalesInquiryTypeValueHelp | view | from | CONSUMPTION | Sales Inquiry specific document types |
| C_SalesOrderTypeValueHelp | view | from | CONSUMPTION | Sales Order Type |
| C_SalesOrderTypeVH_F2242 | view | from | CONSUMPTION | Sales Order Type |
| C_SalesQuotationTypeValueHelp | view | from | CONSUMPTION | Sales Quotation specific document types |
| C_SalesSchedgAgrmtTypeVH | view | from | CONSUMPTION | Sales Scheduling Agreement Types |
| C_SCChkSalesDocTypeVH | view | from | CONSUMPTION | Consumption VH for Sales Document Type |
| C_SegmtnSalesDocTypeVH_F9070 | view_entity | from | CONSUMPTION | Sales Document Type |
| C_SlsDocFlfmtSlsDocTypeVH | view | from | CONSUMPTION | Sales Document Type |
| C_SlsDocTypeTxtDetnProcedItmVH | view | from | CONSUMPTION | Text Detn Proced Items by Sls Doc Types |
| C_SlsOrdWthoutChrgTypeVH | view | from | CONSUMPTION | Sales Order Without Charge Type |
| I_AllwdCustRetTypePerSlsOrg | view_entity | inner | COMPOSITE | Allowed Return Type Per Sales Org |
| I_ARunRequirementDocumentType | view | from | BASIC | Requirement document type |
| I_CreditMemoRequestType | view | from | BASIC | Credit Memo Request Types |
| I_CustomerReturnType | view | from | BASIC | Returns Order Types |
| I_CustRetCpyCtrlSrceDocType | view_entity | inner | COMPOSITE | Source Document Type for Returns Order |
| I_DebitMemoRequestType | view | from | BASIC | Debit Memo Request Types |
| I_DigitalVehSalesDocumentType | view_entity | from | BASIC | Digital Vehicle Sales Document Type |
| I_JITSlsSchedgAgrmt | view | from | BASIC | JIT Sales Scheduling Agreement |
| I_JITSlsSchedgAgrmtBasic | view_entity | from | BASIC | JIT Sales Scheduling Agreement |
| I_MRPExtRqmtOrderTypeText | view_entity | union_all | BASIC | External Requirements Order Type - Text |
| I_SalesContractType | view | from | BASIC | Sales Contract Types |
| I_SalesInquiryType | view | from | BASIC | Sales Inquiry Types |
| I_SalesItemProposalType | view | from | BASIC | Sales Item Proposal Types |
| I_SalesOrderType | view | from | BASIC | Sales Order Types |
| I_SalesOrderWithoutChargeType | view | from | BASIC | Sales Order Without Charge Types |
| I_SalesQuotationType | view | from | BASIC | Sales Quotation Types |
| I_SalesSchedgAgrmtType | view | from | BASIC | Sales Scheduling Agreement Types |
| P_AllwdCustRetTypePerSlsOrg | view | inner | CONSUMPTION | |
| P_AutomXtrctnSalesOrderType | view | from | COMPOSITE | |
| P_MRPExtRqmtOrderType | view_entity | union_all | BASIC | |
| P_SalesDocGeneralRjcnRsn | view | inner | BASIC | |
| P_SDDocumentType | view | union_all | BASIC | |
| R_CreditMemoRequestTextTP | view_entity | inner | TRANSACTIONAL | Credit Memo Request - Text TP |
| R_CustomerReturnTextTP | view_entity | inner | TRANSACTIONAL | Returns Order - Text TP |
| R_DebitMemoRequestTextTP | view_entity | inner | TRANSACTIONAL | Debit Memo Request - Text TP |
| R_SalesContractTextTP | view_entity | inner | TRANSACTIONAL | Sales Contract - Text TP |
| R_SalesOrderTextTP | view_entity | inner | TRANSACTIONAL | Sales Order - Text TP |
| R_SalesQuotationTextTP | view_entity | inner | TRANSACTIONAL | Sales Quotation - Text TP |
| R_SlsSchedgAgrmtTextTP | view_entity | inner | TRANSACTIONAL | Sales Scheduling Agreement - Text TP |
Fields (2)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SalesDocumentType | SalesDocumentType | 7 |
| KEY | TextDeterminationProcedure | TextDeterminationProcedure | 8 |
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 Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCUMENTTYPE (
SALESDOCUMENTTYPE,
TEXTDETERMINATIONPROCEDURE,
PRIMARY KEY (SALESDOCUMENTTYPE, TEXTDETERMINATIONPROCEDURE)
);
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