_SALESDOCUMENTITMNEWVALUE
_SALESDOCUMENTITMNEWVALUE is an SAP database table in S/4HANA. It contains 20 fields.
Fields (20)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| Batch | Batch | 1 | |
| CustRetItmFollowUpActivity | CustRetItmFollowUpActivity | 1 | |
| DeliveryPriority | DeliveryPriority | 1 | |
| Division | Division | 1 | |
| ExpdDelivQuantityChangeReason | ExpdDelivQuantityChangeReason | 1 | |
| ItemBillingBlockReason | ItemBillingBlockReason | 1 | |
| MaterialByCustomer | MaterialByCustomer | 1 | |
| Plant | Plant | 1 | |
| PricingType | PricingType | 1 | |
| Product | Product | 1 | |
| ProductHierarchyNode | ProductHierarchyNode | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReturnReason | ReturnReason | 1 | |
| Route | Route | 1 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 1 | |
| SalesDocumentItemText | SalesDocumentItemText | 1 | |
| ShippingPoint | ShippingPoint | 1 | |
| StorageLocation | StorageLocation | 1 | |
| UnloadingPointName | UnloadingPointName | 1 | |
| WBSElementInternalID | WBSElementInternalID | 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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SALESDOCUMENTITMNEWVALUE (
BATCH,
CUSTRETITMFOLLOWUPACTIVITY,
DELIVERYPRIORITY,
DIVISION,
EXPDDELIVQUANTITYCHANGEREASON,
ITEMBILLINGBLOCKREASON,
MATERIALBYCUSTOMER,
PLANT,
PRICINGTYPE,
PRODUCT,
PRODUCTHIERARCHYNODE,
PROFITCENTER,
RETURNREASON,
ROUTE,
SALESDOCUMENTITEMCATEGORY,
SALESDOCUMENTITEMTEXT,
SHIPPINGPOINT,
STORAGELOCATION,
UNLOADINGPOINTNAME,
WBSELEMENTINTERNALID
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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