Fields (68)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| CommercialPrice1InCoCodeCrcy | CommercialPrice1InCoCodeCrcy | 1 | |
| CommercialPrice2InCoCodeCrcy | CommercialPrice2InCoCodeCrcy | 1 | |
| CommercialPrice3InCoCodeCrcy | CommercialPrice3InCoCodeCrcy | 1 | |
| CostingOverheadGroup | CostingOverheadGroup | 1 | |
| CostOriginGroup | CostOriginGroup | 1 | |
| CurCostEstValuationVariant | CurCostEstValuationVariant | 1 | |
| CurPlanProjSlsOrdValnStrategy | CurPlanProjSlsOrdValnStrategy | 1 | |
| CurrentCostEstCostingVersion | CurrentCostEstCostingVersion | 1 | |
| CurrentCostEstFiscalPeriod | CurrentCostEstFiscalPeriod | 1 | |
| CurrentCostEstFiscalYear | CurrentCostEstFiscalYear | 1 | |
| CurrentPlanPriceInCoCodeCrcy | CurrentPlanPriceInCoCodeCrcy | 1 | |
| DateOfLastPostedCntUnRstrcdStk | DateOfLastPostedCntUnRstrcdStk | 1 | |
| DevaluationYearCount | DevaluationYearCount | 1 | |
| FutrCostEstValuationVariant | FutrCostEstValuationVariant | 1 | |
| FutrPlanProjSlsOrdValnStrategy | FutrPlanProjSlsOrdValnStrategy | 1 | |
| FutureCostEstCostingVersion | FutureCostEstCostingVersion | 1 | |
| FutureCostEstFiscalYear | FutureCostEstFiscalYear | 1 | |
| FutureCostEstimateFiscalPeriod | FutureCostEstimateFiscalPeriod | 1 | |
| FuturePlndPrice1ValdtyDate | FuturePlndPrice1ValdtyDate | 1 | |
| FuturePlndPrice2ValdtyDate | FuturePlndPrice2ValdtyDate | 1 | |
| FuturePlndPrice3ValdtyDate | FuturePlndPrice3ValdtyDate | 1 | |
| FxdPortnOfFutPlPrcInCoCodeCrcy | FxdPortnOfFutPlPrcInCoCodeCrcy | 1 | |
| FxdPortnOfPlanPrcInCoCodeCrcy | FxdPortnOfPlanPrcInCoCodeCrcy | 1 | |
| FxdPortOfPrevPlPrcInCoCodeCrcy | FxdPortOfPrevPlPrcInCoCodeCrcy | 1 | |
| HasStdCostEstForCurrentPeriod | HasStdCostEstForCurrentPeriod | 1 | |
| HasStdCostEstForFuturePeriod | HasStdCostEstForFuturePeriod | 1 | |
| HasStdCostEstForPreviousPeriod | HasStdCostEstForPreviousPeriod | 1 | |
| InventoryForCycleCountInd | InventoryForCycleCountInd | 1 | |
| InventoryValuationCategory | InventoryValuationCategory | 1 | |
| InvtryValnSpecialStockType | InvtryValnSpecialStockType | 1 | |
| IsLIFOAndFIFORelevant | IsLIFOAndFIFORelevant | 1 | |
| IsMaterialCostedWithQtyStruc | IsMaterialCostedWithQtyStruc | 1 | |
| IsMaterialRelatedOrigin | IsMaterialRelatedOrigin | 1 | |
| IsMatlOfValnTypeMarkedForDeltn | IsMatlOfValnTypeMarkedForDeltn | 1 | |
| IsProducedInhouse | IsProducedInhouse | 1 | |
| LIFOValuationPoolNumber | LIFOValuationPoolNumber | 1 | |
| MaintenanceStatus | MaintenanceStatus | 1 | |
| MaterialValuationClass | MaterialValuationClass | 1 | |
| PhysicalInventoryBlockInd | PhysicalInventoryBlockInd | 1 | |
| PlannedPrice1InCoCodeCrcy | PlannedPrice1InCoCodeCrcy | 1 | |
| PlannedPrice2InCoCodeCrcy | PlannedPrice2InCoCodeCrcy | 1 | |
| PlannedPrice3InCoCodeCrcy | PlannedPrice3InCoCodeCrcy | 1 | |
| PlannedPriceInCoCodeCrcy | PlannedPriceInCoCodeCrcy | 1 | |
| PrevCostEstValuationVariant | PrevCostEstValuationVariant | 1 | |
| PreviousCostEstCostingVersion | PreviousCostEstCostingVersion | 1 | |
| PreviousCostEstFiscalPeriod | PreviousCostEstFiscalPeriod | 1 | |
| PreviousCostEstFiscalYear | PreviousCostEstFiscalYear | 1 | |
| PreviousPlanPriceInCoCodeCrcy | PreviousPlanPriceInCoCodeCrcy | 1 | |
| PrevPlanProjSlsOrdValnStrategy | PrevPlanProjSlsOrdValnStrategy | 1 | |
| PriceDeterminationControl | PriceDeterminationControl | 1 | |
| PriceLastChangeDate | PriceLastChangeDate | 1 | |
| ProductOriginType | ProductOriginType | 1 | |
| ProductUsageType | ProductUsageType | 1 | |
| ProjectStockValuationClass | ProjectStockValuationClass | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| Supplier | Supplier | 1 | |
| TaxBasedPricesPriceUnitQty | TaxBasedPricesPriceUnitQty | 1 | |
| TaxPrice2InCoCodeCrcy | TaxPrice2InCoCodeCrcy | 1 | |
| TaxPrice3InCoCodeCrcy | TaxPrice3InCoCodeCrcy | 1 | |
| TaxPricel1InCoCodeCrcy | TaxPricel1InCoCodeCrcy | 1 | |
| TotStkValAtSlsPrcInCoCodeCrcy | TotStkValAtSlsPrcInCoCodeCrcy | 1 | |
| ValnClsForSpclStkAtVndr | ValnClsForSpclStkAtVndr | 1 | |
| ValnIsBsdOnBatchSpecificUnit | ValnIsBsdOnBatchSpecificUnit | 1 | |
| ValuationClassInPrevPeriod | ValuationClassInPrevPeriod | 1 | |
| ValuationClassInPrevYear | ValuationClassInPrevYear | 1 | |
| ValuationClassSalesOrderStock | ValuationClassSalesOrderStock | 1 | |
| ValuationMargin | ValuationMargin | 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 XB (
COMMERCIALPRICE1INCOCODECRCY,
COMMERCIALPRICE2INCOCODECRCY,
COMMERCIALPRICE3INCOCODECRCY,
COSTINGOVERHEADGROUP,
COSTORIGINGROUP,
CURCOSTESTVALUATIONVARIANT,
CURPLANPROJSLSORDVALNSTRATEGY,
CURRENTCOSTESTCOSTINGVERSION,
CURRENTCOSTESTFISCALPERIOD,
CURRENTCOSTESTFISCALYEAR,
CURRENTPLANPRICEINCOCODECRCY,
DATEOFLASTPOSTEDCNTUNRSTRCDSTK,
DEVALUATIONYEARCOUNT,
FUTRCOSTESTVALUATIONVARIANT,
FUTRPLANPROJSLSORDVALNSTRATEGY,
FUTURECOSTESTCOSTINGVERSION,
FUTURECOSTESTFISCALYEAR,
FUTURECOSTESTIMATEFISCALPERIOD,
FUTUREPLNDPRICE1VALDTYDATE,
FUTUREPLNDPRICE2VALDTYDATE,
FUTUREPLNDPRICE3VALDTYDATE,
FXDPORTNOFFUTPLPRCINCOCODECRCY,
FXDPORTNOFPLANPRCINCOCODECRCY,
FXDPORTOFPREVPLPRCINCOCODECRCY,
HASSTDCOSTESTFORCURRENTPERIOD,
HASSTDCOSTESTFORFUTUREPERIOD,
HASSTDCOSTESTFORPREVIOUSPERIOD,
INVENTORYFORCYCLECOUNTIND,
INVENTORYVALUATIONCATEGORY,
INVTRYVALNSPECIALSTOCKTYPE,
ISLIFOANDFIFORELEVANT,
ISMATERIALCOSTEDWITHQTYSTRUC,
ISMATERIALRELATEDORIGIN,
ISMATLOFVALNTYPEMARKEDFORDELTN,
ISPRODUCEDINHOUSE,
LIFOVALUATIONPOOLNUMBER,
MAINTENANCESTATUS,
MATERIALVALUATIONCLASS,
PHYSICALINVENTORYBLOCKIND,
PLANNEDPRICE1INCOCODECRCY,
PLANNEDPRICE2INCOCODECRCY,
PLANNEDPRICE3INCOCODECRCY,
PLANNEDPRICEINCOCODECRCY,
PREVCOSTESTVALUATIONVARIANT,
PREVIOUSCOSTESTCOSTINGVERSION,
PREVIOUSCOSTESTFISCALPERIOD,
PREVIOUSCOSTESTFISCALYEAR,
PREVIOUSPLANPRICEINCOCODECRCY,
PREVPLANPROJSLSORDVALNSTRATEGY,
PRICEDETERMINATIONCONTROL,
PRICELASTCHANGEDATE,
PRODUCTORIGINTYPE,
PRODUCTUSAGETYPE,
PROJECTSTOCKVALUATIONCLASS,
SALESORDER,
SALESORDERITEM,
SUPPLIER,
TAXBASEDPRICESPRICEUNITQTY,
TAXPRICE2INCOCODECRCY,
TAXPRICE3INCOCODECRCY,
TAXPRICEL1INCOCODECRCY,
TOTSTKVALATSLSPRCINCOCODECRCY,
VALNCLSFORSPCLSTKATVNDR,
VALNISBSDONBATCHSPECIFICUNIT,
VALUATIONCLASSINPREVPERIOD,
VALUATIONCLASSINPREVYEAR,
VALUATIONCLASSSALESORDERSTOCK,
VALUATIONMARGIN
);
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