Fields (546)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocumentType | AccountingDocumentType | 1 |
| KEY | BankStatementInternalID | BankStatementInternalID | 1 |
| KEY | Batch | Batch | 1 |
| KEY | BillingDocument | BillingDocument | 2 |
| KEY | BillingDocumentItem | BillingDocumentItem | 1 |
| KEY | BusinessArea | BusinessArea | 1 |
| KEY | bwkey | bwkey | 1 |
| KEY | bwtar | bwtar | 1 |
| KEY | CalendarMonth | CalendarMonth | 1 |
| KEY | CalendarWeek | CalendarWeek | 1 |
| KEY | CalendarYear | CalendarYear | 2 |
| KEY | CAPostingDate | CAPostingDate | 1 |
| KEY | cmatnr | cmatnr | 1 |
| KEY | CompanyCode | CompanyCode | 4 |
| KEY | CostEstimate | CostEstimate | 1 |
| KEY | Currency | Currency | 1 |
| KEY | Customer | Customer | 3 |
| KEY | cwerks | cwerks | 1 |
| KEY | DocumentDate | DocumentDate | 1 |
| KEY | FinSGLErrorItemUUID | FinSGLErrorItemUUID | 1 |
| KEY | FiscalPeriod | FiscalPeriod | 1 |
| KEY | GLAccount | GLAccount | 2 |
| KEY | IBAN | IBAN | 1 |
| KEY | InventorySpecialStockType | InventorySpecialStockType | 1 |
| KEY | InventoryStockType | InventoryStockType | 1 |
| KEY | laufd | PaymentRunDate | 1 |
| KEY | laufi | PaymentRunID | 1 |
| KEY | Ledger | Ledger | 2 |
| KEY | mandt | mandt | 5 |
| KEY | Material | Material | 2 |
| KEY | MaterialBaseUnit | MaterialBaseUnit | 1 |
| KEY | MATNR | MATNR | 4 |
| KEY | Plant | Plant | 2 |
| KEY | ProfitCenter | ProfitCenter | 1 |
| KEY | SDDocument | SDDocument | 1 |
| KEY | SDDocumentItem | SDDocumentItem | 1 |
| KEY | Segment | Segment | 1 |
| KEY | SpecialGLCode | SpecialGLCode | 1 |
| KEY | spras | Language | 1 |
| KEY | StorageLocation | StorageLocation | 1 |
| KEY | Supplier | Supplier | 3 |
| KEY | timestamp | timestamp | 2 |
| KEY | WBSElementInternalID | WBSElementInternalID | 1 |
| KEY | werks | werks | 1 |
| abap_programname | programname | 1 | |
| AbapProgramname | AbapProgramname | 2 | |
| abciw | abciw | 1 | |
| ABOPVariantDescription | ABOPVariantDescription | 1 | |
| abwkz | abwkz | 1 | |
| actdat | actdat | 3 | |
| acttime | acttime | 3 | |
| actualqty | actualqty | 3 | |
| actuals | actuals | 3 | |
| actualuom | actualuom | 3 | |
| ADD_QTY | ADD_QTY | 2 | |
| ADQ_UOM | ADQ_UOM | 2 | |
| adqntp1 | adqntp1 | 1 | |
| adqntp10 | adqntp10 | 1 | |
| adqntp11 | adqntp11 | 1 | |
| adqntp12 | adqntp12 | 1 | |
| adqntp13 | adqntp13 | 1 | |
| adqntp14 | adqntp14 | 1 | |
| adqntp15 | adqntp15 | 1 | |
| adqntp16 | adqntp16 | 1 | |
| adqntp17 | adqntp17 | 1 | |
| adqntp18 | adqntp18 | 1 | |
| adqntp19 | adqntp19 | 1 | |
| adqntp2 | adqntp2 | 1 | |
| adqntp20 | adqntp20 | 1 | |
| adqntp21 | adqntp21 | 1 | |
| adqntp22 | adqntp22 | 1 | |
| adqntp23 | adqntp23 | 1 | |
| adqntp24 | adqntp24 | 1 | |
| adqntp25 | adqntp25 | 1 | |
| adqntp26 | adqntp26 | 1 | |
| adqntp27 | adqntp27 | 1 | |
| adqntp28 | adqntp28 | 1 | |
| adqntp29 | adqntp29 | 1 | |
| adqntp3 | adqntp3 | 1 | |
| adqntp30 | adqntp30 | 1 | |
| adqntp31 | adqntp31 | 1 | |
| adqntp32 | adqntp32 | 1 | |
| adqntp33 | adqntp33 | 1 | |
| adqntp34 | adqntp34 | 1 | |
| adqntp35 | adqntp35 | 1 | |
| adqntp36 | adqntp36 | 1 | |
| adqntp37 | adqntp37 | 1 | |
| adqntp38 | adqntp38 | 1 | |
| adqntp39 | adqntp39 | 1 | |
| adqntp4 | adqntp4 | 1 | |
| adqntp40 | adqntp40 | 1 | |
| adqntp41 | adqntp41 | 1 | |
| adqntp42 | adqntp42 | 1 | |
| adqntp43 | adqntp43 | 1 | |
| adqntp44 | adqntp44 | 1 | |
| adqntp45 | adqntp45 | 1 | |
| adqntp46 | adqntp46 | 1 | |
| adqntp47 | adqntp47 | 1 | |
| adqntp48 | adqntp48 | 1 | |
| adqntp49 | adqntp49 | 1 | |
| adqntp5 | adqntp5 | 1 | |
| adqntp50 | adqntp50 | 1 | |
| adqntp51 | adqntp51 | 1 | |
| adqntp52 | adqntp52 | 1 | |
| adqntp53 | adqntp53 | 1 | |
| adqntp54 | adqntp54 | 1 | |
| adqntp55 | adqntp55 | 1 | |
| adqntp56 | adqntp56 | 1 | |
| adqntp57 | adqntp57 | 1 | |
| adqntp58 | adqntp58 | 1 | |
| adqntp59 | adqntp59 | 1 | |
| adqntp6 | adqntp6 | 1 | |
| adqntp60 | adqntp60 | 1 | |
| adqntp7 | adqntp7 | 1 | |
| adqntp8 | adqntp8 | 1 | |
| adqntp9 | adqntp9 | 1 | |
| aedat | aedat,AEDAT_I | 4 | |
| AEDDTF | AEDDTF | 2 | |
| AEDDTT | AEDDTT | 2 | |
| AEDTMF | AEDTMF | 2 | |
| AEDTMT | AEDTMT | 2 | |
| aenam | aenam,AENAM_I | 4 | |
| aezeit | aezeit,AEZEIT_I | 4 | |
| AllocationRuleUnitOfMsmt | AllocationRuleUnitOfMsmt | 1 | |
| AllocConversionGroup | AllocConversionGroup | 1 | |
| AllocUnitOfMsmtGroup | AllocUnitOfMsmtGroup | 1 | |
| AmountFulfillmentPercent | AmountFulfillmentPercent | 1 | |
| apo_shipment_id | apo_shipment_id | 3 | |
| apo_shipment_num | apo_shipment_num | 3 | |
| ApplicationJobTemplate | ApplicationJobTemplate | 2 | |
| ApplJobTemplateText | ApplJobTemplateText | 1 | |
| assignedqty | assignedqty | 3 | |
| AssignmentReference | AssignmentReference | 1 | |
| ASTDTF | ASTDTF | 2 | |
| ASTDTT | ASTDTT | 2 | |
| ASTTMF | ASTTMF | 2 | |
| ASTTMT | ASTTMT | 2 | |
| atl_crdt_curr | atl_crdt_curr | 3 | |
| atl_crdt_qty | atl_crdt_qty | 3 | |
| atl_crdt_uom | atl_crdt_uom | 3 | |
| atl_crdt_val | atl_crdt_val | 3 | |
| atl_delv_itm | atl_delv_itm | 3 | |
| atl_delv_number | atl_delv_number | 3 | |
| BERID | BERID | 2 | |
| BERNR | BERNR | 2 | |
| bezei | RouteName | 1 | |
| bindings | bindings | 1 | |
| bklas | bklas | 1 | |
| bloind | bloind,bloind_i | 4 | |
| bookts | bookts | 4 | |
| bttypeDescription | TaskModelTypeDescription | 1 | |
| bustyp | bustyp | 4 | |
| bwpei | bwpei | 1 | |
| bwph1 | bwph1 | 1 | |
| bwprh | bwprh | 1 | |
| bwprs | bwprs | 1 | |
| bwps1 | bwps1 | 1 | |
| bwspa | bwspa | 1 | |
| bwtty | bwtty | 1 | |
| bwva1 | bwva1 | 1 | |
| bwva2 | bwva2 | 1 | |
| bwva3 | bwva3 | 1 | |
| CD_ADD_QTY | CD_ADD_QTY | 1 | |
| CD_ADQ_UOM | CD_ADQ_UOM | 1 | |
| CD_AEDDTF | CD_AEDDTF | 2 | |
| CD_AEDDTT | CD_AEDDTT | 2 | |
| CD_AEDTMF | CD_AEDTMF | 2 | |
| CD_AEDTMT | CD_AEDTMT | 2 | |
| CD_ASTDTF | CD_ASTDTF | 2 | |
| CD_ASTDTT | CD_ASTDTT | 2 | |
| CD_ASTTMF | CD_ASTTMF | 2 | |
| CD_ASTTMT | CD_ASTTMT | 2 | |
| CD_BERID | CD_BERID | 1 | |
| CD_BERNR | CD_BERNR | 1 | |
| CD_CHA_DATE | CD_CHA_DATE | 1 | |
| CD_CHA_NAME | CD_CHA_NAME | 1 | |
| CD_CHA_TIME | CD_CHA_TIME | 1 | |
| CD_CPARID | CD_CPARID | 1 | |
| CD_CRE_DATE | CD_CRE_DATE | 1 | |
| CD_CRE_NAME | CD_CRE_NAME | 1 | |
| CD_CRE_TIME | CD_CRE_TIME | 1 | |
| CD_DEFAULTED | CD_DEFAULTED | 1 | |
| CD_DELIND | CD_DELIND | 1 | |
| CD_DOC_NUMBER | CD_DOC_NUMBER | 1 | |
| CD_DOC_TYPE | CD_DOC_TYPE | 1 | |
| CD_DRIVER | CD_DRIVER | 1 | |
| CD_EV_SEQ | CD_EV_SEQ | 1 | |
| CD_EVENT_NR | CD_EVENT_NR | 1 | |
| CD_LT_EVOPPOINT | CD_LT_EVOPPOINT | 1 | |
| CD_MATNR | CD_MATNR | 1 | |
| CD_NOMNR | CD_NOMNR | 1 | |
| CD_PEDDTF | CD_PEDDTF | 2 | |
| CD_PEDDTT | CD_PEDDTT | 2 | |
| CD_PEDTMF | CD_PEDTMF | 2 | |
| CD_PEDTMT | CD_PEDTMT | 2 | |
| CD_PSTDTF | CD_PSTDTF | 2 | |
| CD_PSTDTT | CD_PSTDTT | 2 | |
| CD_PSTTMF | CD_PSTTMF | 2 | |
| CD_PSTTMT | CD_PSTTMT | 2 | |
| CD_SHITEM | CD_SHITEM | 1 | |
| CD_STATUS | CD_STATUS | 2 | |
| CD_TICKET_EV_NR | CD_TICKET_EV_NR | 1 | |
| CD_TICKET_ITEM | CD_TICKET_ITEM | 1 | |
| CD_TICKET_KEY | CD_TICKET_KEY | 1 | |
| CD_TPNUM | CD_TPNUM | 1 | |
| CD_TSRFO | CD_TSRFO | 1 | |
| CD_TYPE | CD_TYPE | 1 | |
| CD_UPDFLAG | CD_UPDFLAG | 1 | |
| CD_VEH_NR | CD_VEH_NR | 1 | |
| CHA_DATE | CHA_DATE | 2 | |
| CHA_NAME | CHA_NAME | 2 | |
| CHA_TIME | CHA_TIME | 2 | |
| char_field_ext | char_field_ext | 1 | |
| charg_d | charg_d | 3 | |
| charg_d_create | charg_d_create | 3 | |
| charg_l | charg_l | 3 | |
| charg_l_create | charg_l_create | 3 | |
| charg_o | charg_o | 3 | |
| charg_o_create | charg_o_create | 3 | |
| ChartOfAccounts | ChartOfAccounts | 2 | |
| co_carr | co_carr | 3 | |
| co_ship | co_ship | 3 | |
| co_tsyst | co_tsyst | 3 | |
| commctl | commctl | 3 | |
| Commodity | Commodity | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| conpat | conpat | 3 | |
| cons | cons | 3 | |
| ContractConsumptionInPct | ContractConsumptionInPct | 1 | |
| counter1 | counter1 | 3 | |
| counter2 | counter2 | 3 | |
| counter3 | counter3 | 3 | |
| counter4 | counter4 | 3 | |
| counter5 | counter5 | 3 | |
| counter6 | counter6 | 3 | |
| CPARID | CPARID | 2 | |
| CRE_DATE | CRE_DATE | 2 | |
| CRE_NAME | CRE_NAME | 2 | |
| CRE_TIME | CRE_TIME | 2 | |
| CreatedByUser | CreatedByUser | 1 | |
| CustomerProjectAgedDebt | CustomerProjectAgedDebt | 1 | |
| cycle | cycle | 3 | |
| cycle_item | cycle_item | 3 | |
| datatype | BusEvtLogCDSViewFieldDataType | 1 | |
| DEFAULTED | DEFAULTED | 2 | |
| DELIND | DELIND,delind_i | 6 | |
| description | description | 1 | |
| DisplayItem | DisplayItem | 1 | |
| DOC_NUMBER | DOC_NUMBER | 2 | |
| DOC_TYPE | DOC_TYPE | 2 | |
| docind | docind | 3 | |
| docitm | docitm | 3 | |
| docnr | docnr | 3 | |
| docschedln | docschedln | 3 | |
| doctyp | doctyp | 3 | |
| DRIVER | DRIVER | 2 | |
| ekalr | ekalr | 1 | |
| eklas | eklas | 1 | |
| EmbeddedSwVersionStatusDesc | EmbeddedSwVersionDescription | 1 | |
| empfg | PaymentRecipient | 1 | |
| enddate | enddate | 1 | |
| EndingBalanceAmtInCoCodeCrcy | EndingBalanceAmtInCoCodeCrcy | 2 | |
| endtime | endtime | 1 | |
| EngmtProjEmployeeIsStaffed | EngmtProjEmployeeIsStaffed | 1 | |
| erdat | erdat,ERDAT_I | 4 | |
| ernam | ernam,ERNAM_I | 4 | |
| erzeit | erzeit,ERZEIT_I | 4 | |
| ev_group | ev_group | 3 | |
| EV_SEQ | EV_SEQ | 2 | |
| EVENT_NR | EVENT_NR | 2 | |
| EVENT_SIM | EVENT_SIM | 2 | |
| fbwst | fbwst | 1 | |
| FinancialAccountType | FinancialAccountType | 1 | |
| FinSGLCorrectionCompanyCode | FinSGLCorrectionCompanyCode | 1 | |
| FinSGLCorrectionDocument | FinSGLCorrectionDocument | 1 | |
| FinSGLCorrectionFiscalYear | FinSGLCorrectionFiscalYear | 1 | |
| FinSGLCrrtnReversalDocument | FinSGLCrrtnReversalDocument | 1 | |
| FinSGLCrrtnRvslCompanyCode | FinSGLCrrtnRvslCompanyCode | 1 | |
| FinSGLCrrtnRvslFiscalYear | FinSGLCrrtnRvslFiscalYear | 1 | |
| FinSGLErrorDocument | FinSGLErrorDocument | 1 | |
| FinSGLErrorFiscalYear | FinSGLErrorFiscalYear | 1 | |
| FinSGLErrorItemSeverity | FinSGLErrorItemSeverity | 1 | |
| FinSGLErrorItemStatus | FinSGLErrorItemStatus | 1 | |
| flag_imex | flag_imex | 3 | |
| fplpx | fplpx | 1 | |
| fprfm | fprfm | 1 | |
| fsh_cust_field1 | ValueAddedServiceText1 | 1 | |
| fsh_cust_field2 | ValueAddedServiceText2 | 1 | |
| fsh_cust_field3 | ValueAddedServiceText3 | 1 | |
| fsh_mg_arun_req | fsh_mg_arun_req | 1 | |
| fsh_seaim | fsh_seaim | 1 | |
| ga_allocated_qty | ga_allocated_qty | 3 | |
| ga_allocated_uom | ga_allocated_uom | 3 | |
| ga_conf_qty | ga_conf_qty | 3 | |
| ga_conf_qty_cal | ga_conf_qty_cal | 3 | |
| ga_conf_uom | ga_conf_uom | 3 | |
| ga_nmshipper | ga_nmshipper | 3 | |
| ga_rank | ga_rank | 3 | |
| ga_techsch_qty | ga_techsch_qty | 3 | |
| ga_techsch_uom | ga_techsch_uom | 3 | |
| ga_tsch_qty_cal | ga_tsch_qty_cal | 3 | |
| HierarchyNode | HierarchyNode | 6 | |
| hkmat | hkmat | 1 | |
| hrkft | hrkft | 1 | |
| idate | idate | 3 | |
| ilock | ilock | 3 | |
| impoexpo | impoexpo | 3 | |
| incomplete_flag | incomplete_flag | 3 | |
| inspe | inspe | 3 | |
| int_field_ext | int_field_ext | 1 | |
| int1_field_ext | int1_field_ext | 1 | |
| ipw_txt | ipw_txt | 3 | |
| istat | istat | 3 | |
| isubstat | isubstat | 3 | |
| itbotol | itbotol | 3 | |
| itbotolabs | itbotolabs | 3 | |
| itbutol | itbutol | 3 | |
| itbutolabs | itbutolabs | 3 | |
| items | items | 3 | |
| ittolunit | ittolunit | 3 | |
| kalkl | kalkl | 1 | |
| kalkv | kalkv | 1 | |
| kalkz | kalkz | 1 | |
| kaln1 | kaln1 | 1 | |
| kalnr | kalnr | 1 | |
| kalsc | kalsc | 1 | |
| kosgr | kosgr | 1 | |
| kunnr | Customer | 1 | |
| kziwl | kziwl | 1 | |
| laepr | laepr | 1 | |
| last_modification_time | last_modification_time | 1 | |
| lbwst | lbwst | 1 | |
| ldgrp | LedgerGroup | 1 | |
| ldquom | ldquom | 3 | |
| ldrate | ldrate | 3 | |
| ldtuom | ldtuom | 3 | |
| LedgerGLLineItem | LedgerGLLineItem | 1 | |
| lesshnum | lesshnum | 3 | |
| lestpnum | lestpnum | 3 | |
| lfgja | lfgja | 1 | |
| lfmon | lfmon | 1 | |
| lgort | lgort | 1 | |
| lifnr | Supplier | 1 | |
| LiquidityItem | LiquidityItem | 6 | |
| loc_pt | locpt | 3 | |
| loc_sl | locsl | 3 | |
| locid | locid | 4 | |
| lov_gl | lov_gl | 3 | |
| lplpr | lplpr | 1 | |
| lplpx | lplpx | 1 | |
| LT_EVOPPOINT | LT_EVOPPOINT | 2 | |
| lvorm | lvorm | 1 | |
| matkl | MaterialGroup | 1 | |
| matnr_i | matnr_i | 3 | |
| mbrue | mbrue | 1 | |
| meins | meins | 1 | |
| menge | menge | 3 | |
| mlast | mlast | 1 | |
| mlmaa | mlmaa | 1 | |
| model_definition | model_definition | 1 | |
| model_specification | model_specification | 1 | |
| mtorg | mtorg | 1 | |
| mtuse | mtuse | 1 | |
| mypol | mypol | 1 | |
| name | LedgerGroupName | 1 | |
| nmbalch | nmbalch | 3 | |
| nmblock | nmblock | 3 | |
| nmcarrier | nmcarrier | 3 | |
| nmlgort | nmlgort | 3 | |
| nmshipper | nmshipper | 3 | |
| nmshtype | nmshtype | 3 | |
| nmtplst | nmtplst | 3 | |
| nmvehicle | nmvehicle | 3 | |
| nmvessel | nmvessel | 3 | |
| nmwerk | nmwerk | 3 | |
| nomcl | nomcl | 3 | |
| nomit | nomit | 3 | |
| NOMNR | NOMNR | 5 | |
| nomst | nomst | 3 | |
| nomtk | nomtk | 4 | |
| nomtyp | nomtyp | 3 | |
| nomtypdesc | nomtypdesc | 3 | |
| num_field_ext | num_field_ext | 1 | |
| NumberOfSuppliedEmployees | NumberOfSuppliedEmployees | 1 | |
| oklas | oklas | 1 | |
| owner | owner | 3 | |
| ownpr | ownpr | 1 | |
| partnr | partnr | 3 | |
| PaymentMediumRun | PaymentBatchMerge | 1 | |
| PaymentMediumRunDate | PaymentBatchMergeDate | 1 | |
| pdatl | pdatl | 1 | |
| pdatv | pdatv | 1 | |
| pdatz | pdatz | 1 | |
| PEDDTF | PEDDTF | 2 | |
| PEDDTT | PEDDTT | 2 | |
| PEDTMF | PEDTMF | 2 | |
| PEDTMT | PEDTMT | 2 | |
| peinh | peinh | 1 | |
| PlndEffortQty | EngmtProjStaffedEffortQty | 1 | |
| pperl | pperl | 1 | |
| pperv | pperv | 1 | |
| pperz | pperz | 1 | |
| pprdl | pprdl | 1 | |
| pprdv | pprdv | 1 | |
| pprdz | pprdz | 1 | |
| pre_exist_ind | pre_exist_ind | 3 | |
| programnameDescription | programnameDescription | 1 | |
| ProjectStaffingInstructionText | ProjectStaffingInstructionText | 1 | |
| prorate_routine | prorate_routine | 3 | |
| prorateqty | prorateqty | 3 | |
| pstat | pstat | 1 | |
| PSTDTF | PSTDTF | 2 | |
| PSTDTT | PSTDTT | 2 | |
| PSTTMF | PSTTMF | 2 | |
| PSTTMT | PSTTMT | 2 | |
| PurchaseContractClassification | PurchaseContractClassification | 1 | |
| PurchaseContractConsumedAmount | PurchaseContractConsumedAmount | 1 | |
| PurchaseContractTargetAmount | PurchaseContractTargetAmount | 1 | |
| PurchaseContractType | PurchaseContractType | 1 | |
| qklas | qklas | 1 | |
| qtyfcr | qtyfcr | 3 | |
| qtyfcr_uom | qtyfcr_uom | 3 | |
| qtyin | qtyin | 3 | |
| qtyout | qtyout | 3 | |
| QuantityFulfillmentPercent | QuantityFulfillmentPercent | 1 | |
| quickconf | QUICKCONF | 3 | |
| rcomp | rcomp | 2 | |
| refitem | refitem | 3 | |
| repr_rldnr | Ledger | 1 | |
| route | route | 3 | |
| rvp | rvp | 3 | |
| s_matnr_i | s_matnr_i | 3 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| scenario_id | scenario_id | 1 | |
| sched_comm | sched_comm | 3 | |
| sched_stat | sched_stat | 3 | |
| sched_tst_from | sched_tst_from | 3 | |
| sched_tst_to | sched_tst_to | 3 | |
| SemanticAction | SemanticAction | 1 | |
| SemanticObject | SemanticObject | 1 | |
| sentdat | sentdat | 3 | |
| sentnam | sentnam | 3 | |
| senttime | senttime | 3 | |
| SHITEM | SHITEM | 5 | |
| shnum | shnum,shnum_i | 3 | |
| shtyp | shtyp | 4 | |
| signature | signature | 1 | |
| sim_sched_id | sim_sched_id | 3 | |
| sim_sched_ln | sim_sched_ln | 3 | |
| sim_sched_typ | sim_sched_typ | 4 | |
| sim_version | sim_version | 4 | |
| sityp | sityp | 3 | |
| soldto | soldto | 3 | |
| sperw | sperw | 1 | |
| stages_id | stages_id | 3 | |
| STATUS | STATUS | 3 | |
| stlkn | stlkn | 3 | |
| stlty | stlty | 3 | |
| stprs | stprs | 1 | |
| stprv | stprv | 1 | |
| strtdate | strtdate | 1 | |
| strttime | strttime | 1 | |
| SuppliedEmploymentInternalID | SuppliedEmploymentInternalID | 1 | |
| tank | tank | 3 | |
| Tasktype | Tasktype | 2 | |
| tcitm | tcitm | 3 | |
| tcnum | tcnum | 3 | |
| TcodeDescription | TcodeDescription | 1 | |
| texta | ResultAnalysisDescription | 1 | |
| third_nomnr | third_nomnr | 3 | |
| TICKET_EV_NR | TICKET_EV_NR | 2 | |
| TICKET_ITEM | TICKET_ITEM | 2 | |
| TICKET_KEY | TICKET_KEY | 2 | |
| tknum | tknum | 3 | |
| TotalPostedAmountInCoCodeCurr | TotalPostedAmtInCoCodeCrcy | 1 | |
| TotalPostedAmountInTransaCurr | TotalPostedAmountInTransaCurr | 1 | |
| TPNUM | TPNUM | 2 | |
| Transactioncode | Transactioncode | 1 | |
| TSRFO | TSRFO | 2 | |
| tst_from_min | tst_from_min | 3 | |
| tst_to_max | tst_to_max | 3 | |
| tsyst | tsyst | 4 | |
| TYPE | TYPE | 2 | |
| unit | unit | 3 | |
| unit_i | unit_i | 3 | |
| unit_i_t | unit_i_t | 3 | |
| unlimited | unlimited | 4 | |
| updatexdok | updatexdok | 3 | |
| UPDFLAG | UPDFLAG | 2 | |
| UPDKZ | UPDKZ | 5 | |
| upmat | upmat | 3 | |
| USER_ID | USER_ID | 5 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 | |
| valuationtype_d | valuationtype_d | 3 | |
| valuationtype_o | valuationtype_o | 3 | |
| vblnr | AccountingDocument | 1 | |
| vbwst | vbwst | 1 | |
| VEH_NR | VEH_NR | 2 | |
| verpr | verpr | 1 | |
| vers1 | vers1 | 1 | |
| vers2 | vers2 | 1 | |
| vers3 | vers3 | 1 | |
| vjbkl | vjbkl | 1 | |
| vjbwh | vjbwh | 1 | |
| vjbws | vjbws | 1 | |
| vjkum | vjkum | 1 | |
| vjpei | vjpei | 1 | |
| vjsal | vjsal | 1 | |
| vjsav | vjsav | 1 | |
| vjstp | vjstp | 1 | |
| vjver | vjver | 1 | |
| vjvpr | vjvpr | 1 | |
| vktra | vktra | 4 | |
| vmbkl | vmbkl | 1 | |
| vmkum | vmkum | 1 | |
| vmpei | vmpei | 1 | |
| vmsal | vmsal | 1 | |
| vmsav | vmsav | 1 | |
| vmstp | vmstp | 1 | |
| vmver | vmver | 1 | |
| vmvpr | vmvpr | 1 | |
| vplpr | vplpr | 1 | |
| vplpx | vplpx | 1 | |
| vprsv | vprsv | 1 | |
| vvjlb | vvjlb | 1 | |
| vvjsl | vvjsl | 1 | |
| vvmlb | vvmlb | 1 | |
| vvsal | vvsal | 1 | |
| WebAppUrl | WebAppUrl | 1 | |
| wlinl | wlinl | 1 | |
| worklist | worklist | 3 | |
| worklist_i | worklist_i | 3 | |
| xbewm | xbewm | 1 | |
| xlifo | xlifo | 1 | |
| zbukr | PayingCompanyCode | 1 | |
| zkdat | zkdat | 1 | |
| zkprs | zkprs | 1 | |
| zpld1 | zpld1 | 1 | |
| zpld2 | zpld2 | 1 | |
| zpld3 | zpld3 | 1 | |
| zplp1 | zplp1 | 1 | |
| zplp2 | zplp2 | 1 | |
| zplp3 | zplp3 | 1 | |
| zplpr | zplpr | 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 B (
ACCOUNTINGDOCUMENTTYPE,
BANKSTATEMENTINTERNALID,
BATCH,
BILLINGDOCUMENT,
BILLINGDOCUMENTITEM,
BUSINESSAREA,
BWKEY,
BWTAR,
CALENDARMONTH,
CALENDARWEEK,
CALENDARYEAR,
CAPOSTINGDATE,
CMATNR,
COMPANYCODE,
COSTESTIMATE,
CURRENCY,
CUSTOMER,
CWERKS,
DOCUMENTDATE,
FINSGLERRORITEMUUID,
FISCALPERIOD,
GLACCOUNT,
IBAN,
INVENTORYSPECIALSTOCKTYPE,
INVENTORYSTOCKTYPE,
LAUFD,
LAUFI,
LEDGER,
MANDT,
MATERIAL,
MATERIALBASEUNIT,
MATNR,
PLANT,
PROFITCENTER,
SDDOCUMENT,
SDDOCUMENTITEM,
SEGMENT,
SPECIALGLCODE,
SPRAS,
STORAGELOCATION,
SUPPLIER,
TIMESTAMP,
WBSELEMENTINTERNALID,
WERKS,
ABAP_PROGRAMNAME,
ABAPPROGRAMNAME,
ABCIW,
ABOPVARIANTDESCRIPTION,
ABWKZ,
ACTDAT,
ACTTIME,
ACTUALQTY,
ACTUALS,
ACTUALUOM,
ADD_QTY,
ADQ_UOM,
ADQNTP1,
ADQNTP10,
ADQNTP11,
ADQNTP12,
ADQNTP13,
ADQNTP14,
ADQNTP15,
ADQNTP16,
ADQNTP17,
ADQNTP18,
ADQNTP19,
ADQNTP2,
ADQNTP20,
ADQNTP21,
ADQNTP22,
ADQNTP23,
ADQNTP24,
ADQNTP25,
ADQNTP26,
ADQNTP27,
ADQNTP28,
ADQNTP29,
ADQNTP3,
ADQNTP30,
ADQNTP31,
ADQNTP32,
ADQNTP33,
ADQNTP34,
ADQNTP35,
ADQNTP36,
ADQNTP37,
ADQNTP38,
ADQNTP39,
ADQNTP4,
ADQNTP40,
ADQNTP41,
ADQNTP42,
ADQNTP43,
ADQNTP44,
ADQNTP45,
ADQNTP46,
ADQNTP47,
ADQNTP48,
ADQNTP49,
ADQNTP5,
ADQNTP50,
ADQNTP51,
ADQNTP52,
ADQNTP53,
ADQNTP54,
ADQNTP55,
ADQNTP56,
ADQNTP57,
ADQNTP58,
ADQNTP59,
ADQNTP6,
ADQNTP60,
ADQNTP7,
ADQNTP8,
ADQNTP9,
AEDAT,
AEDDTF,
AEDDTT,
AEDTMF,
AEDTMT,
AENAM,
AEZEIT,
ALLOCATIONRULEUNITOFMSMT,
ALLOCCONVERSIONGROUP,
ALLOCUNITOFMSMTGROUP,
AMOUNTFULFILLMENTPERCENT,
APO_SHIPMENT_ID,
APO_SHIPMENT_NUM,
APPLICATIONJOBTEMPLATE,
APPLJOBTEMPLATETEXT,
ASSIGNEDQTY,
ASSIGNMENTREFERENCE,
ASTDTF,
ASTDTT,
ASTTMF,
ASTTMT,
ATL_CRDT_CURR,
ATL_CRDT_QTY,
ATL_CRDT_UOM,
ATL_CRDT_VAL,
ATL_DELV_ITM,
ATL_DELV_NUMBER,
BERID,
BERNR,
BEZEI,
BINDINGS,
BKLAS,
BLOIND,
BOOKTS,
BTTYPEDESCRIPTION,
BUSTYP,
BWPEI,
BWPH1,
BWPRH,
BWPRS,
BWPS1,
BWSPA,
BWTTY,
BWVA1,
BWVA2,
BWVA3,
CD_ADD_QTY,
CD_ADQ_UOM,
CD_AEDDTF,
CD_AEDDTT,
CD_AEDTMF,
CD_AEDTMT,
CD_ASTDTF,
CD_ASTDTT,
CD_ASTTMF,
CD_ASTTMT,
CD_BERID,
CD_BERNR,
CD_CHA_DATE,
CD_CHA_NAME,
CD_CHA_TIME,
CD_CPARID,
CD_CRE_DATE,
CD_CRE_NAME,
CD_CRE_TIME,
CD_DEFAULTED,
CD_DELIND,
CD_DOC_NUMBER,
CD_DOC_TYPE,
CD_DRIVER,
CD_EV_SEQ,
CD_EVENT_NR,
CD_LT_EVOPPOINT,
CD_MATNR,
CD_NOMNR,
CD_PEDDTF,
CD_PEDDTT,
CD_PEDTMF,
CD_PEDTMT,
CD_PSTDTF,
CD_PSTDTT,
CD_PSTTMF,
CD_PSTTMT,
CD_SHITEM,
CD_STATUS,
CD_TICKET_EV_NR,
CD_TICKET_ITEM,
CD_TICKET_KEY,
CD_TPNUM,
CD_TSRFO,
CD_TYPE,
CD_UPDFLAG,
CD_VEH_NR,
CHA_DATE,
CHA_NAME,
CHA_TIME,
CHAR_FIELD_EXT,
CHARG_D,
CHARG_D_CREATE,
CHARG_L,
CHARG_L_CREATE,
CHARG_O,
CHARG_O_CREATE,
CHARTOFACCOUNTS,
CO_CARR,
CO_SHIP,
CO_TSYST,
COMMCTL,
COMMODITY,
COMPANYCODECURRENCY,
CONPAT,
CONS,
CONTRACTCONSUMPTIONINPCT,
COUNTER1,
COUNTER2,
COUNTER3,
COUNTER4,
COUNTER5,
COUNTER6,
CPARID,
CRE_DATE,
CRE_NAME,
CRE_TIME,
CREATEDBYUSER,
CUSTOMERPROJECTAGEDDEBT,
CYCLE,
CYCLE_ITEM,
DATATYPE,
DEFAULTED,
DELIND,
DESCRIPTION,
DISPLAYITEM,
DOC_NUMBER,
DOC_TYPE,
DOCIND,
DOCITM,
DOCNR,
DOCSCHEDLN,
DOCTYP,
DRIVER,
EKALR,
EKLAS,
EMBEDDEDSWVERSIONSTATUSDESC,
EMPFG,
ENDDATE,
ENDINGBALANCEAMTINCOCODECRCY,
ENDTIME,
ENGMTPROJEMPLOYEEISSTAFFED,
ERDAT,
ERNAM,
ERZEIT,
EV_GROUP,
EV_SEQ,
EVENT_NR,
EVENT_SIM,
FBWST,
FINANCIALACCOUNTTYPE,
FINSGLCORRECTIONCOMPANYCODE,
FINSGLCORRECTIONDOCUMENT,
FINSGLCORRECTIONFISCALYEAR,
FINSGLCRRTNREVERSALDOCUMENT,
FINSGLCRRTNRVSLCOMPANYCODE,
FINSGLCRRTNRVSLFISCALYEAR,
FINSGLERRORDOCUMENT,
FINSGLERRORFISCALYEAR,
FINSGLERRORITEMSEVERITY,
FINSGLERRORITEMSTATUS,
FLAG_IMEX,
FPLPX,
FPRFM,
FSH_CUST_FIELD1,
FSH_CUST_FIELD2,
FSH_CUST_FIELD3,
FSH_MG_ARUN_REQ,
FSH_SEAIM,
GA_ALLOCATED_QTY,
GA_ALLOCATED_UOM,
GA_CONF_QTY,
GA_CONF_QTY_CAL,
GA_CONF_UOM,
GA_NMSHIPPER,
GA_RANK,
GA_TECHSCH_QTY,
GA_TECHSCH_UOM,
GA_TSCH_QTY_CAL,
HIERARCHYNODE,
HKMAT,
HRKFT,
IDATE,
ILOCK,
IMPOEXPO,
INCOMPLETE_FLAG,
INSPE,
INT_FIELD_EXT,
INT1_FIELD_EXT,
IPW_TXT,
ISTAT,
ISUBSTAT,
ITBOTOL,
ITBOTOLABS,
ITBUTOL,
ITBUTOLABS,
ITEMS,
ITTOLUNIT,
KALKL,
KALKV,
KALKZ,
KALN1,
KALNR,
KALSC,
KOSGR,
KUNNR,
KZIWL,
LAEPR,
LAST_MODIFICATION_TIME,
LBWST,
LDGRP,
LDQUOM,
LDRATE,
LDTUOM,
LEDGERGLLINEITEM,
LESSHNUM,
LESTPNUM,
LFGJA,
LFMON,
LGORT,
LIFNR,
LIQUIDITYITEM,
LOC_PT,
LOC_SL,
LOCID,
LOV_GL,
LPLPR,
LPLPX,
LT_EVOPPOINT,
LVORM,
MATKL,
MATNR_I,
MBRUE,
MEINS,
MENGE,
MLAST,
MLMAA,
MODEL_DEFINITION,
MODEL_SPECIFICATION,
MTORG,
MTUSE,
MYPOL,
NAME,
NMBALCH,
NMBLOCK,
NMCARRIER,
NMLGORT,
NMSHIPPER,
NMSHTYPE,
NMTPLST,
NMVEHICLE,
NMVESSEL,
NMWERK,
NOMCL,
NOMIT,
NOMNR,
NOMST,
NOMTK,
NOMTYP,
NOMTYPDESC,
NUM_FIELD_EXT,
NUMBEROFSUPPLIEDEMPLOYEES,
OKLAS,
OWNER,
OWNPR,
PARTNR,
PAYMENTMEDIUMRUN,
PAYMENTMEDIUMRUNDATE,
PDATL,
PDATV,
PDATZ,
PEDDTF,
PEDDTT,
PEDTMF,
PEDTMT,
PEINH,
PLNDEFFORTQTY,
PPERL,
PPERV,
PPERZ,
PPRDL,
PPRDV,
PPRDZ,
PRE_EXIST_IND,
PROGRAMNAMEDESCRIPTION,
PROJECTSTAFFINGINSTRUCTIONTEXT,
PRORATE_ROUTINE,
PRORATEQTY,
PSTAT,
PSTDTF,
PSTDTT,
PSTTMF,
PSTTMT,
PURCHASECONTRACTCLASSIFICATION,
PURCHASECONTRACTCONSUMEDAMOUNT,
PURCHASECONTRACTTARGETAMOUNT,
PURCHASECONTRACTTYPE,
QKLAS,
QTYFCR,
QTYFCR_UOM,
QTYIN,
QTYOUT,
QUANTITYFULFILLMENTPERCENT,
QUICKCONF,
RCOMP,
REFITEM,
REPR_RLDNR,
ROUTE,
RVP,
S_MATNR_I,
SALESORDER,
SALESORDERITEM,
SCENARIO_ID,
SCHED_COMM,
SCHED_STAT,
SCHED_TST_FROM,
SCHED_TST_TO,
SEMANTICACTION,
SEMANTICOBJECT,
SENTDAT,
SENTNAM,
SENTTIME,
SHITEM,
SHNUM,
SHTYP,
SIGNATURE,
SIM_SCHED_ID,
SIM_SCHED_LN,
SIM_SCHED_TYP,
SIM_VERSION,
SITYP,
SOLDTO,
SPERW,
STAGES_ID,
STATUS,
STLKN,
STLTY,
STPRS,
STPRV,
STRTDATE,
STRTTIME,
SUPPLIEDEMPLOYMENTINTERNALID,
TANK,
TASKTYPE,
TCITM,
TCNUM,
TCODEDESCRIPTION,
TEXTA,
THIRD_NOMNR,
TICKET_EV_NR,
TICKET_ITEM,
TICKET_KEY,
TKNUM,
TOTALPOSTEDAMOUNTINCOCODECURR,
TOTALPOSTEDAMOUNTINTRANSACURR,
TPNUM,
TRANSACTIONCODE,
TSRFO,
TST_FROM_MIN,
TST_TO_MAX,
TSYST,
TYPE,
UNIT,
UNIT_I,
UNIT_I_T,
UNLIMITED,
UPDATEXDOK,
UPDFLAG,
UPDKZ,
UPMAT,
USER_ID,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
VALUATIONTYPE_D,
VALUATIONTYPE_O,
VBLNR,
VBWST,
VEH_NR,
VERPR,
VERS1,
VERS2,
VERS3,
VJBKL,
VJBWH,
VJBWS,
VJKUM,
VJPEI,
VJSAL,
VJSAV,
VJSTP,
VJVER,
VJVPR,
VKTRA,
VMBKL,
VMKUM,
VMPEI,
VMSAL,
VMSAV,
VMSTP,
VMVER,
VMVPR,
VPLPR,
VPLPX,
VPRSV,
VVJLB,
VVJSL,
VVMLB,
VVSAL,
WEBAPPURL,
WLINL,
WORKLIST,
WORKLIST_I,
XBEWM,
XLIFO,
ZBUKR,
ZKDAT,
ZKPRS,
ZPLD1,
ZPLD2,
ZPLD3,
ZPLP1,
ZPLP2,
ZPLP3,
ZPLPR,
PRIMARY KEY (ACCOUNTINGDOCUMENTTYPE, BANKSTATEMENTINTERNALID, BATCH, BILLINGDOCUMENT, BILLINGDOCUMENTITEM, BUSINESSAREA, BWKEY, BWTAR, CALENDARMONTH, CALENDARWEEK, CALENDARYEAR, CAPOSTINGDATE, CMATNR, COMPANYCODE, COSTESTIMATE, CURRENCY, CUSTOMER, CWERKS, DOCUMENTDATE, FINSGLERRORITEMUUID, FISCALPERIOD, GLACCOUNT, IBAN, INVENTORYSPECIALSTOCKTYPE, INVENTORYSTOCKTYPE, LAUFD, LAUFI, LEDGER, MANDT, MATERIAL, MATERIALBASEUNIT, MATNR, PLANT, PROFITCENTER, SDDOCUMENT, SDDOCUMENTITEM, SEGMENT, SPECIALGLCODE, SPRAS, STORAGELOCATION, SUPPLIER, TIMESTAMP, WBSELEMENTINTERNALID, WERKS)
);
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