I_SALESORDERWITHOUTCHARGEITEM
Item for Sales Order Without Charge
I_SALESORDERWITHOUTCHARGEITEM is a CDS View in S/4HANA. Item for Sales Order Without Charge. It contains 81 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_SalesOrderWithoutChargeItem | view | from | COMPOSITE | Sales Order Without Charge Item |
| C_BSOrdItmProcFlwSlsOrdFOC | view | from | CONSUMPTION | SlsOrdWthoutChrgItm Attrib BSOrd Prgrs |
| C_OrdWthoutChrgItmWrkflwInbox | view | from | CONSUMPTION | Sls Ord Wthout Chrg Item Workflow Inbox |
| C_SalesOrderWithoutChargeItem | view | from | CONSUMPTION | Sales Order Without Charge Item |
| C_SalesOrderWithoutChargeItmFS | view | from | CONSUMPTION | Sales Ord. without Charge Item |
| C_SlsOrdWthoutChrgRplcmtMatl | view | from | CONSUMPTION | Order Without Charge Rplcmt Material |
| C_SubsqntSOWithoutChargeItem | view | from | CONSUMPTION | |
| I_SlsOrdWthoutChrgItemImport | view_entity | from | COMPOSITE | Sales Order Without Charge Item for Import |
| R_SlsOrderWithoutChargeItemTP | view_entity | from | TRANSACTIONAL | Sales Order Without Charge Item - TP |
Fields (81)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SalesOrderWithoutCharge | SalesDocument,SalesOrderWithoutCharge | 5 |
| KEY | SalesOrderWithoutChargeItem | SalesOrderWithoutChargeItem | 3 |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerPaymentTerms | _CustomerPaymentTerms | 1 | |
| _DeliveryBlockStatus | _DeliveryBlockStatus | 1 | |
| _DeliveryDateTypeRule | _DeliveryDateTypeRule | 1 | |
| _DeliveryPriority | _DeliveryPriority | 1 | |
| _DeliveryStatus | _DeliveryStatus | 1 | |
| _IncotermsClassification | _IncotermsClassification | 1 | |
| _ItemCategory | _ItemCategory | 1 | |
| _ItemGeneralIncompletionStatus | _ItemGeneralIncompletionStatus | 1 | |
| _ItemVolumeUnit | _ItemVolumeUnit | 1 | |
| _ItemWeightUnit | _ItemWeightUnit | 1 | |
| _PartialDeliveryItem | _PartialDeliveryItem | 1 | |
| _Plant | _Plant | 1 | |
| _Product | _Product | 1 | |
| _ProductGroup | _ProductGroup | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _RequestedQuantityUnit | _RequestedQuantityUnit | 1 | |
| _Route | _Route | 1 | |
| _SalesDocumentRjcnReason | _SalesDocumentRjcnReason | 1 | |
| _SalesOrderWithoutCharge | _SalesOrderWithoutCharge | 1 | |
| _SDDocumentRejectionStatus | _SDDocumentRejectionStatus | 1 | |
| _SDProcessStatus | _SDProcessStatus | 2 | |
| _ShippingPoint | _ShippingPoint | 1 | |
| _ShippingType | _ShippingType | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| Batch | Batch | 2 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CreationDate | CreationDate | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 1 | |
| DeliveryBlockStatus | DeliveryBlockStatus | 2 | |
| DeliveryDateTypeRule | DeliveryDateTypeRule | 1 | |
| DeliveryGroup | DeliveryGroup | 1 | |
| DeliveryPriority | DeliveryPriority | 1 | |
| DeliveryStatus | DeliveryStatus | 2 | |
| FixedValueDate | FixedValueDate | 1 | |
| HigherLevelItem | HigherLevelItem | 2 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| ItemGeneralIncompletionStatus | ItemGeneralIncompletionStatus | 1 | |
| ItemGrossWeight | ItemGrossWeight | 1 | |
| ItemNetWeight | ItemNetWeight | 1 | |
| ItemVolume | ItemVolume | 1 | |
| ItemVolumeUnit | ItemVolumeUnit | 1 | |
| ItemWeightUnit | ItemWeightUnit | 1 | |
| MaterialByCustomer | MaterialByCustomer | 2 | |
| MaxNmbrOfPartialDelivery | MaxNmbrOfPartialDelivery | 1 | |
| NetAmount | NetAmount | 3 | |
| OrderQuantity | OrderQuantity | 3 | |
| OrderQuantityUnit | OrderQuantityUnit | 4 | |
| PartialDeliveryIsAllowed | PartialDeliveryIsAllowed | 1 | |
| Plant | Plant,ProductionPlant | 2 | |
| PricingDate | PricingDate | 1 | |
| Product | Product | 2 | |
| ProductGroup | ProductGroup | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 1 | |
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | 1 | |
| RequestedQuantity | RequestedQuantity | 1 | |
| RequestedQuantityInBaseUnit | RequestedQuantityInBaseUnit | 1 | |
| RequestedQuantityUnit | RequestedQuantityUnit | 1 | |
| Route | Route | 1 | |
| SalesDocumentRjcnReason | SalesDocumentRjcnReason | 1 | |
| SalesOrderWthoutChrgItemText | SalesOrderWthoutChrgItemText | 2 | |
| SDDocumentRejectionStatus | SDDocumentRejectionStatus | 1 | |
| SDProcessStatus | SDProcessStatus | 3 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShippingPoint | ShippingPoint | 2 | |
| ShippingType | ShippingType | 1 | |
| SlsOrdWthoutChrgItemCategory | SlsOrdWthoutChrgItemCategory | 2 | |
| StorageLocation | StorageLocation | 2 | |
| TargetToBaseQuantityDnmntr | TargetToBaseQuantityDnmntr | 1 | |
| TargetToBaseQuantityNmrtr | TargetToBaseQuantityNmrtr | 1 | |
| TransactionCurrency | TransactionCurrency | 3 | |
| 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.
-- Item for Sales Order Without Charge
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORDERWITHOUTCHARGEITEM (
SALESORDERWITHOUTCHARGE,
SALESORDERWITHOUTCHARGEITEM,
_CUSTOMERGROUP,
_CUSTOMERPAYMENTTERMS,
_DELIVERYBLOCKSTATUS,
_DELIVERYDATETYPERULE,
_DELIVERYPRIORITY,
_DELIVERYSTATUS,
_INCOTERMSCLASSIFICATION,
_ITEMCATEGORY,
_ITEMGENERALINCOMPLETIONSTATUS,
_ITEMVOLUMEUNIT,
_ITEMWEIGHTUNIT,
_PARTIALDELIVERYITEM,
_PLANT,
_PRODUCT,
_PRODUCTGROUP,
_PROFITCENTER,
_REQUESTEDQUANTITYUNIT,
_ROUTE,
_SALESDOCUMENTRJCNREASON,
_SALESORDERWITHOUTCHARGE,
_SDDOCUMENTREJECTIONSTATUS,
_SDPROCESSSTATUS,
_SHIPPINGPOINT,
_SHIPPINGTYPE,
_STORAGELOCATION,
_TRANSACTIONCURRENCY,
BATCH,
BILLINGDOCUMENTDATE,
CONTROLLINGAREA,
CREATIONDATE,
CUSTOMERGROUP,
CUSTOMERPAYMENTTERMS,
DELIVERYBLOCKSTATUS,
DELIVERYDATETYPERULE,
DELIVERYGROUP,
DELIVERYPRIORITY,
DELIVERYSTATUS,
FIXEDVALUEDATE,
HIGHERLEVELITEM,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
ITEMGENERALINCOMPLETIONSTATUS,
ITEMGROSSWEIGHT,
ITEMNETWEIGHT,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
MATERIALBYCUSTOMER,
MAXNMBROFPARTIALDELIVERY,
NETAMOUNT,
ORDERQUANTITY,
ORDERQUANTITYUNIT,
PARTIALDELIVERYISALLOWED,
PLANT,
PRICINGDATE,
PRODUCT,
PRODUCTGROUP,
PROFITCENTER,
PURCHASEORDERBYCUSTOMER,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTITEM,
REQUESTEDQUANTITY,
REQUESTEDQUANTITYINBASEUNIT,
REQUESTEDQUANTITYUNIT,
ROUTE,
SALESDOCUMENTRJCNREASON,
SALESORDERWTHOUTCHRGITEMTEXT,
SDDOCUMENTREJECTIONSTATUS,
SDPROCESSSTATUS,
SERVICESRENDEREDDATE,
SHIPPINGPOINT,
SHIPPINGTYPE,
SLSORDWTHOUTCHRGITEMCATEGORY,
STORAGELOCATION,
TARGETTOBASEQUANTITYDNMNTR,
TARGETTOBASEQUANTITYNMRTR,
TRANSACTIONCURRENCY,
WBSELEMENTINTERNALID,
PRIMARY KEY (SALESORDERWITHOUTCHARGE, SALESORDERWITHOUTCHARGEITEM)
);
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