XB

XB is an SAP database table in S/4HANA. It contains 68 fields.

Fields (68)

KeyField CDS FieldsUsed 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
);