LIPS
SD document: Delivery: Item data
LIPS is an SAP database table in S/4HANA. SD document: Delivery: Item data. It contains 376 fields. 20 CDS views read from this table.
CDS Views using this table (20)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /sapapo/v_tdl_outb_delivery | view | inner | SAPAPO TDL: Outbound delivery | |
| Arun_Spo_Reqmt | view | left_outer | Subcontracting PO Requirement | |
| ARun_ValAddedSrvcInbDelivBsc | view | inner | ||
| E_DeliveryDocumentItem | view_entity | from | EXTENSION | Extension view for Delivery Document Item |
| I_ACMDeliveryItemDetail | view | from | BASIC | Delivery details |
| I_DeliveryDocumentItem | view | from | BASIC | Delivery Document Item |
| I_FldLogsDeliveryDocItem | view | from | BASIC | Delivery Items for FL |
| I_SupDmndAllDocGdsIssdDeliv | view | from | BASIC | View for Goods Issued Deliveries |
| I_SupDmndAllDocOpenDeliveries | view | inner | BASIC | View for Open Deliveries |
| I_SupDmndAllDocRetDeliv | view | inner | BASIC | View for Return Deliveries |
| I_SupDmndReservationBasic | view | left_outer | BASIC | Basic View for Reservations |
| I_TripOutbDeliveryItemTP | view | left_outer | TRANSACTIONAL | Outbound Delivery Items |
| I_TripOutboundDelivery | view | inner | BASIC | Outbound Delivery details |
| I_TripOutboundDeliveryVH | view | inner | BASIC | Value Help for Outbound Delivery |
| I_TripShptItmTP | view | left_outer | TRANSACTIONAL | Shipment Items |
| NSDM_E_MB_SIT_OBDLV | view | inner | MB_SIT_OBDLV Compatibility View | |
| P_SupDmndAllDocDelivComp | view | from | BASIC | |
| pp_mrp_read_outbound_deliv | view | inner | Read Outbound Deliveries | |
| PRODCMPLNCLICRLVTDELIVDOC | view | from | License Relevant Outbound Delivery Items | |
| V_Vbup_S4 | view | union_all | DDL for VBUP CDS view |
Fields (376)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | vbeln | VBELN_VL | Delivery | |||
| KEY | posnr | POSNR_VL | Item | |||
| pstyv | PSTYV_VL | Item Category | ||||
| ernam | ERNAM | Created By | ||||
| erzet | ERZET | Time | ||||
| erdat | ERDAT | Created On | ||||
| matnr | MATNR | Material | ||||
| matwa | MATWA | MaterialEntered | ||||
| matkl | MATKL | Material Group | ||||
| werks | WERKS_D | Plant | ||||
| lgort | LGORT_D | Location | ||||
| charg | CHARG_D | Batch | ||||
| lichn | LICHN | Supplier Batch | ||||
| kdmat | KDMAT | Customer Mat. | ||||
| prodh | PRODH_D | Prod. Hierarchy | ||||
| prdh_uni_batdet_parnt_nodid | NODID | Node ID | ||||
| lfimg | LFIMG | Delivery Qty | ||||
| meins | MEINS | Base Unit | ||||
| vrkme | VRKME | Sales Unit | ||||
| umvkz | UMVKZ | Numerator | ||||
| umvkn | UMVKN | Denominat. | ||||
| ntgew | NTGEW_15 | Net Weight | ||||
| brgew | BRGEW_15 | Gross Weight | ||||
| gewei | GEWEI | Unit of Weight | ||||
| volum | VOLUM_15 | Volume | ||||
| voleh | VOLEH | Volume Unit | ||||
| kztlf | KZTLF | Part.dlv./item | ||||
| uebtk | UEBTK | Unlimited | ||||
| uebto | UEBTO | Overdeliv. Tol. | ||||
| untto | UNTTO | Underdel. Tol. | ||||
| chspl | CHSPL | Batch split | ||||
| faksp | FAKSP | Billing Block | ||||
| mbdat | MBDAT | Mat.Avail.Date | ||||
| lgmng | LGMNG | Qty (stckp.unt) | ||||
| arktx | ARKTX | Item Descr. | ||||
| lgpbe | LGPBE | Storage Bin | ||||
| vbelv | VBELV | Originating Doc | ||||
| posnv | POSNV | Origin. Item | ||||
| vbtyv | VBTYPL | Document Cat. | ||||
| vgsys | VGLOGSYS | PrDocLogSys | ||||
| vgbel | VGBEL | Reference Doc. | ||||
| vgpos | VGPOS | Reference Item | ||||
| upflu | UPFLL | Update doc.flow | ||||
| uepos | UEPOS | Higher-Lev.Item | ||||
| fkrel | FKREL | Relev.for Bill. | ||||
| batch_billing_variant | SDBIL_BATCH_BILLING_VARIANT | BatchItmBillVar | ||||
| ladgr | LADGR | Loading Group | ||||
| tragr | TRAGR | Trans. Group | ||||
| komkz | KOMKZ | Picking ID | ||||
| lgnum | LGNUM | Warehouse No. | ||||
| lispl | LNSPL_LIPS | Whse no. split | ||||
| lgtyp | LGTYP | Storage Type | ||||
| lgpla | LGPLA | Storage Bin | ||||
| bwtex | BWTEX | Separate val. | ||||
| ettyp | ETTYP | Sched.Line Cat. | ||||
| bwart | BWART | Movement Type | ||||
| bwlvs | BWLVS | Movement Type | ||||
| kzdlg | LVS_KZDLG | Ind.dynamic bin | ||||
| bdart | BDART | RequirementType | ||||
| plart | PLART | Planning type | ||||
| mtart | MTART | Material Type | ||||
| xchpf | XCHPF | Batch Mgmt Rqt | ||||
| xchar | XCHAR | Batches | ||||
| vgref | VGREF | Preced. with ref. | ||||
| posar | POSAR | Item Type | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| sumbd | SUMBD | Req'mt totals. | ||||
| mtvfp | MTVFP | Avail. check | ||||
| eannr | EANNR | EAN Number | ||||
| gsber | GSBER | Business Area | ||||
| vkbur | VKBUR | Sales Office | ||||
| vkgrp | VKGRP | Sales Group | ||||
| vtweg | VTWEG | Distr. Channel | ||||
| spart | SPART | Division | ||||
| grkor | GRKOR | Delivery Group | ||||
| fmeng | FMENG | Qty. is fixed | ||||
| antlf | ANTLF | Max.Part.Deliv. | ||||
| vbeaf | VBEAF | Fixed proc.time | ||||
| vbeav | VBEAV | Var. proc. time | ||||
| stafo | STAFO | Update Group | ||||
| wavwr | WAVWR | Cost | ||||
| kzwi1 | KZWI1 | Subtotal 1 | ||||
| kzwi2 | KZWI2 | Subtotal 2 | ||||
| kzwi3 | KZWI3 | Subtotal 3 | ||||
| kzwi4 | KZWI4 | Subtotal 4 | ||||
| kzwi5 | KZWI5 | Subtotal 5 | ||||
| kzwi6 | KZWI6 | Subtotal 6 | ||||
| sobkz | SOBKZ | Special Stock | ||||
| aedat | AEDAT | Changed On | ||||
| ean11 | EAN11 | EAN/UPC | ||||
| kvgr1 | KVGR1 | Customer Grp 1 | ||||
| kvgr2 | KVGR2 | Customer Grp 2 | ||||
| kvgr3 | KVGR3 | Customer Grp 3 | ||||
| kvgr4 | KVGR4 | Customer Grp 4 | ||||
| kvgr5 | KVGR5 | Customer Grp 5 | ||||
| mvgr1 | MVGR1 | MaterialGroup 1 | ||||
| mvgr2 | MVGR2 | MaterialGroup 2 | ||||
| mvgr3 | MVGR3 | MaterialGroup 3 | ||||
| mvgr4 | MVGR4 | MaterialGroup 4 | ||||
| mvgr5 | MVGR5 | MaterialGroup 5 | ||||
| vpzuo | VPZUO | Allocation Ind. | ||||
| vgtyp | VBTYPL_V | Prec.Doc.Categ. | ||||
| rfvgtyp | RFVGTYPL | PrecedDocCentrl | ||||
| kostl | KOSTL | Cost Center | ||||
| kokrs | KOKRS | CO Area | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| prctr | PRCTR | Profit Center | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| aufnr | AUFNR | Order | ||||
| posnr_pp | CO_POSNR | Item Number | ||||
| vornr | VORNR | Activity | ||||
| recipient_location_code | RECIPIENT_LOCATION_CODE | Recipient Loc. | ||||
| aufpl | CO_AUFPL | Plan No.f.Oper. | ||||
| aplzl | CIM_COUNT | Counter | ||||
| kdauf | KDAUF | Sales Order | ||||
| kdpos | KDPOS | Sales Ord. Item | ||||
| vpmat | VPMAT | Plng material | ||||
| vpwrk | VPWRK | Planning Plant | ||||
| prbme | PRBME | Prod. grp unit | ||||
| umref | UMREFF | Conversion | ||||
| knttp | KNTTP | Acct Assgmt Cat | ||||
| kzvbr | KZVBR | Consumption | ||||
| fipos | FIPOS | Commitment item | ||||
| fistl | FISTL | Funds Center | ||||
| geber | BP_GEBER | Fund | ||||
| pckpf | PCKPF | Packing Control | ||||
| bedar_lf | BEDAR | Reqmts Class | ||||
| cmpnt | CMPNT | Credit Active | ||||
| kcmeng | KCMENG | Cumul.batch qty | ||||
| kcbrgew | KCBRGEW | Cum.gross wght | ||||
| kcntgew | KCNTGEW | Cumul.net wght | ||||
| kcvolum | KCVOLUM | Cumul.volume | ||||
| uecha | UECHA | HghLevItmBatch | ||||
| cuobj | CUOBJ_VA | Configuration | ||||
| cuobj_ch | CUOBJ_CH | Int.object no. | ||||
| anzsn | ANZSN | No.serial no. | ||||
| serail | SERAIL | SerialNoProfile | ||||
| kcgewei | GEWEI | Unit of Weight | ||||
| kcvoleh | VOLEH | Volume Unit | ||||
| sernr | SERNR | BOM expl.number | ||||
| abrli | ABRLI | Int.dlv.scd.no. | ||||
| abart | ABART | Release type | ||||
| abrvw | ABRVW | Usage | ||||
| qplos | QPLOS | Inspection Lot | ||||
| qtlos | QTLOS | Partial Lot | ||||
| nachl | NACHL | No GR posted | ||||
| magrv | MAGRV | Matl Grp Pckmat | ||||
| objko | OBJKO | Object No. Hdr | ||||
| objpo | OBJPO | ObjNo Item | ||||
| aeskd | AESKD | Engin. Change | ||||
| shkzg | SHKZG_DLV | Returns | ||||
| prosa | PROSA | MatDetermActive | ||||
| uepvw | UEPVW | Usage HL Item | ||||
| empst | EMPST | Recv. Point | ||||
| abtnr | ABTNR | Department | ||||
| koqui | KOQUI | Confirmation | ||||
| stadat | STADAT | Statistics Date | ||||
| aktnr | WAKTION | Promotion | ||||
| knumh_ch | KNUMH_CH | NoCondRec.Batch | ||||
| prefe | PREFE | Cus. Preference | ||||
| exart | EXART | Bus.Trans.Type | ||||
| clint | CLINT | Int class no. | ||||
| chmvs | CHMVS | Qty proposal | ||||
| abeln | ABELN | Alloc. Table | ||||
| abelp | ABELP | Item | ||||
| lfimg_flo | LFIMG_FLO | Internal field/ Do not use / LFIMG in float / MUM | ||||
| lgmng_flo | LGMNG_FLO | Internal field/ Do not use / LGMNG in float / MUM | ||||
| kcmeng_flo | KCMENG_FLO | Internal field/ Do not use / KCMENG in float / MUM | ||||
| kzumw | KZUMW | Envt. relevant | ||||
| kmpmg | KMPMG | Quantity | ||||
| aurel | AUREL | AT-Relevant | ||||
| kpein | KPEIN | Pricing Unit | ||||
| kmein | KMEIN | Unit of Measure | ||||
| netpr | NETPR | Net Price | ||||
| netwr | NETWR | Net Value | ||||
| kowrr | KOWRR | Stat. Value | ||||
| kzbew | KZBEW | Movement ind. | ||||
| mfrgr | MFRGR | Mat.Freight Grp | ||||
| chhpv | CHHPV | Pack acc.batch | ||||
| abfor | ABSFORM_CM | PaytGuarantForm | ||||
| abges | ABGES_CM | Guaranteed | ||||
| mbuhr | MBUHR | Matl Staging Tme | ||||
| wktnr | WKTNR | Value Contract No. | ||||
| wktps | WKTPS | Val. Cont.Item | ||||
| j_1bcfop | J_1BCFOP | CFOP | ||||
| j_1btaxlw1 | J_1BTAXLW1 | ICMS Law | ||||
| j_1btaxlw2 | J_1BTAXLW2 | IPI Law | ||||
| j_1btxsdc | J_1BTXSDC_ | Tax Code | ||||
| situa | SITUA | Situation | ||||
| rsnum | RSNUM | Reservation | ||||
| rspos | RSPOS | Item no. | ||||
| rsart | RSART | Record type | ||||
| kannr | KANNR | Sequence Number | ||||
| kzfme | KZFME | Leading UoM | ||||
| profl | ADGE_PROFL | DGIndProfile | ||||
| kcmengvme | KCMENG_VME | Cumul.batch qty | ||||
| kcmengvmef | KCMENGVMEF | Cumulated batch split quantity in VRKME and float | ||||
| kzbws | KZBWS | Valuation | ||||
| pspnr | PS_INTNR | Project def. | ||||
| eprio | EPRIO | Withdr.Seq.Grp | ||||
| rules | BF_RULES | Stk Determ.Rule | ||||
| kzbef | LVS_KZBEF | Inv.Mgmt active | ||||
| mprof | MPROF | Mfr Part Profile | ||||
| ematn | EMATN | MPN: Material | ||||
| lgbzo | LGBZO | Staging Area | ||||
| handle | TSEGGUID_LIPS | Key | ||||
| verurpos | VERURPOS | Orig. item | ||||
| lifexpos | LIFEXPOS | Ext. item | ||||
| noatp | NO_ATP_CHECK | No avail. check | ||||
| nopck | NO_PICKING | Not rel.picking | ||||
| rblvs | RBLVS | RefMvtType WM | ||||
| berid | BERID | MRP Area | ||||
| bestq | BESTQ | Stock Category | ||||
| umbsq | BESTQ | Stock Category | ||||
| ummat | UMMAT | Receiving Mat. | ||||
| umwrk | UMWRK | Receiving plant | ||||
| umlgo | UMLGO | Receiving SLoc. | ||||
| umcha | UMCHA | Receiving Batch | ||||
| umbar | UMBAR | Val. Type Tfr. | ||||
| umsok | UMSOK | Sp.ind.st.tfr. | ||||
| sonum | LVS_SONUM | Spec.Stock No. | ||||
| usonu | LVS_SONUM | Spec.Stock No. | ||||
| akkur | AKKUR | LettofCredRate | ||||
| akmng | AKMNG | Current qty | ||||
| vkgru | VKGRU | Class. of Items | ||||
| shkzg_um | SHKZG_UM | Main posting id | ||||
| insmk | MB_INSMK | Stock Type | ||||
| kzech | KZECH | Enter batch | ||||
| flgwm | FLGWM | Indicator: Copy dest. storage data from preceding document | ||||
| berkz | BERKZ | Staging Ind. | ||||
| hupos | HUPOS | Indicator: Delivery item is a HU item | ||||
| nowab | NOWAB | No gds movement | ||||
| konto | SAKNR | G/L Account | ||||
| kzear | KZEAR | Final Issue | ||||
| hsdat | HSDAT | Date of Manuf. | ||||
| vfdat | VFDAT | SLED/BBD | ||||
| lfgja | LFGJA | Year Cur.Period | ||||
| lfbnr | LFBNR | Reference Doc. | ||||
| lfpos | LFPOS | Ref. Doc. Item | ||||
| grund | MB_GRUND | Reason for mvt. | ||||
| fobwa | FOBWA | Sub.movmnt type | ||||
| dlvtp | DLVTP | Delivery Cat. | ||||
| exbwr | EXBWR | Ext. Amount LC | ||||
| bpmng | BPMNG | Qty in OPUn | ||||
| exvkw | EXVKW | Sales Value | ||||
| cmpre_flt | CMPRE_FLT | Credit Price | ||||
| kzpod | KZPOD | POD indicator | ||||
| lfdez | LFDEZ | Not WMS-relevnt | ||||
| umrev | LE_UMREV | ConversionFactr | ||||
| podrel | PODREL | POD rel. RC/SC | ||||
| kzuml | KZUML | St.tfr./tfr.pst | ||||
| fkber | FKBER | Functional Area | ||||
| grant_nbr | GM_GRANT_NBR | Grant | ||||
| kzwso | KZWSO | Units meas. use | ||||
| gmcontrol | GMCONTROL | Gds mvmt contrl | ||||
| posting_change | POSTING_CHANGE | WBWKZ | ||||
| um_ps_psp_pnr | UM_PS_PSP_PNR | Trsfr WBS Elmnt | ||||
| pre_vl_etens | ETENS | Sequential No. | ||||
| spe_gen_elikz | ELIKZ | Deliv. Compl. | ||||
| spe_scrap_ind | /SPE/DELIVERY_SCRAP_IND | Scrap Indicator | ||||
| spe_auth_number | /SPE/RET_RMA | RMA Number | ||||
| spe_inspout_guid | /SPE/INSP_OUT_GUID_16 | Inspection GUID | ||||
| spe_follow_up | /SPE/RET_FOLLOW_UP | Follow-Up Code | ||||
| spe_exp_date_ext | /SPE/RET_EXPIRY_DATE_EXT | End Validity Period | ||||
| spe_exp_date_int | /SPE/RET_EXPIRY_DATE_INT | End internal val. | ||||
| spe_auth_complet | /SPE/RET_RMA_COMPLETED | RMA No. Completed | ||||
| ormng | ORMNG_VL | Delivery Qty | ||||
| spe_atp_tmstmp | /SPE/DE_ATP_TIMESTAMP | ATP Time Stamp | ||||
| spe_orig_sys | /SPE/INB_ORIGIN_SYS | Original System Type | ||||
| spe_lieffz | /SPE/LIEFFZ | CQ Vendor | ||||
| spe_imwrk | /SPE/IMWRK_ITEM | In Plant | ||||
| spe_lifexpos2 | /SPE/DE_EXT_IDENT | Ext. ident. | ||||
| spe_except_code | /SPE/INB_EXCEPT_CODE_WM | Except.Code WH | ||||
| spe_keep_qty | /SPE/KEEP_QUANTITY | Retention Qty | ||||
| spe_alternate | /SPE/DE_ALTERNATE_PART_NR | Alt.ProdNr. | ||||
| spe_mat_subst | /SPE/MAT_SUBST | Reasn | ||||
| spe_struc | /SPE/STRUC | Structure | ||||
| spe_apo_qntyfac | APOQUANFACTOR | Numerator | ||||
| spe_apo_qntydiv | APOQUANDIVISOR | Denominator | ||||
| spe_herkl | HERKL | C/R of Origin | ||||
| spe_bxp_date_ext | /SPE/RET_EXPIRY_DATE_EXT_B | Begin Valid. Period | ||||
| spe_version | /SPE/DE_DLV_VERSION | DeliveryVsn | ||||
| spe_compl_mvt | /SPE/COMPL_MVT | GM Completion | ||||
| j_1btaxlw4 | J_1BTAXLW4 | COFINS Law | ||||
| j_1btaxlw5 | J_1BTAXLW5 | PIS Law | ||||
| j_1btaxlw3 | J_1BTAXLW3 | ISS Law | ||||
| budget_pd | FM_BUDGET_PERIOD | Budget Period | ||||
| kbnkz | KBNKZ | Kanban Indicat. | ||||
| farr_reltype | FARR_RELTYPE | Type | ||||
| sitkz | SITKZ | Spec.Iss. Val. SiT | ||||
| sgt_rcat | SGT_RCAT | Req. Segment | ||||
| sgt_scat | SGT_SCAT | Stock Segment | ||||
| resource_id | LE_RESOURCENAME_SID | Resource | ||||
| umresource_id | LE_RESOURCENAME_CID | Receiv. Resource | ||||
| flpkz | FLPKZ | Fld. Logs. Ind. | ||||
| loading_point | /SCMTMS/LOADING_POINT_ID | Load./Unload. Pt | ||||
| solution_order_id | CRMS4_SOLO_OBJECT_ID | Solution Order | ||||
| solution_order_itm_id | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| spe_herkr | HERKR | Reg. of Origin | ||||
| itm_comco | /SAPSLL/COMCO | Commodity Code | ||||
| wempf | WEMPF | Recipient | ||||
| creation_ts | TIMESTAMPL | Time Stamp | ||||
| changed_ts | TIMESTAMPL | Time Stamp | ||||
| pikmg_wh | PIKMG_WH | Pick quantity | ||||
| pikmg_wh_bu | PIKMG_WH_BU | Pick quantity | ||||
| service_doc_type | FCO_SRVDOC_TYPE | Service Doc. Type | ||||
| service_doc_id | FCO_SRVDOC_ID | Service Document | ||||
| service_doc_item_id | FCO_SRVDOC_ITEM_ID | Service Doc. Item | ||||
| besta | BESTA | Deliv. Conf.Sts | ||||
| cmppi | CMPSI | Financial Doc. | ||||
| cmppj | CMPSJ | ExptCreditInsur | ||||
| fkivp | FKIVP | Intco Bllg Sts | ||||
| fksta | FKSTA | Del.Rel.BillgSt | ||||
| gbsta | GBSTA | Overall Status | ||||
| hdall | /SPE/INB_HDALL_ITM | DlyItemNotComp. | ||||
| koqua | KOQUA | Confirmation | ||||
| kosta | KOSTA | Picking Status | ||||
| lvsta | LVSTA | WM Activity Sts | ||||
| pdsta | PDSTA | POD status | ||||
| pksta | PKSTA | Packing Status | ||||
| uvall | UVALL_UP | Item | ||||
| uvfak | UVFAK_UP | Billing – Item | ||||
| uvpak | UVPAP_UP | Packing – Item | ||||
| uvpik | UVPIP_UP | Picking/Putaway–Item | ||||
| uvvlk | UVVLK_UP | Delivery – Item | ||||
| uvwak | UVWAP_UP | Goods Mvt –Item | ||||
| vlstp | VLSTP | Decentr.whse | ||||
| wbsta | WBSTA | Goods Mvmnt Sts | ||||
| uvp01 | UVP01 | Item reserves 1 | ||||
| uvp02 | UVP02 | Item reserves 2 | ||||
| uvp03 | UVP03 | Item reserves 3 | ||||
| uvp04 | UVP04 | Item reserves 4 | ||||
| uvp05 | UVP05 | Item reserves 5 | ||||
| emcst | /SAPSLL/EMCST | Embargo Status | ||||
| slcst | /SAPSLL/SLCST | Screening Status | ||||
| lccst | /SAPSLL/LCCST | Legal Control Status | ||||
| pcsta | TDD_PCSTA_LE | Prod. Marktablty Sts | ||||
| dgsta | TDD_DGSTA_LE | Dangerous Goods Sts | ||||
| sdssta | TDD_SDSSTA_LE | Sfty Data Sheet Sts | ||||
| ico_fkivp | ICO_FKIVP | Intco Billing Status | ||||
| kosta_wh | KOSTA_WH | Picking Status | ||||
| arc_status | ET_ARC_STATUS | ET ARC Status | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| dummy_delitm_incl_eew_ps | DUMMY | Dummy function in length 1 | ||||
| ico_vgtyp | ICO_VGTYP | Intco Ref Doc Cat | ||||
| ico_vgbel | ICO_VGBEL | Intco Ref Doc | ||||
| ico_vgpos | ICO_VGPOS | Intco Ref Doc Item | ||||
| ico_fkaiv | ICO_FKAIV | Intco Billing Type | ||||
| ico_vkoiv | ICO_VKOIV | Sales Org. ICB | ||||
| ico_pioiv | ICO_PIOIV | Billing date | ||||
| ico_fkdiv | ICO_FKDIV | Billing Date | ||||
| vcm_chain_uuid | GUID_32 | GUID 16 | ||||
| vcm_chain_category | VCM_CHAIN_CATEGORY | Value Chain Category | ||||
| lgtor | LGTOR | Door for Whse | ||||
| fsh_season_year | FSH_SAISJ | Season Year | ||||
| fsh_season | FSH_SAISO | Season | ||||
| fsh_collection | FSH_COLLECTION | Collection | ||||
| fsh_theme | FSH_THEME | Theme | ||||
| fsh_kvgr6 | FSH_KVGR6 | Customer Grp 6 | ||||
| fsh_kvgr7 | FSH_KVGR7 | Customer Grp 7 | ||||
| fsh_kvgr8 | FSH_KVGR8 | Customer Grp 8 | ||||
| fsh_kvgr9 | FSH_KVGR9 | Customer Grp 9 | ||||
| fsh_kvgr10 | FSH_KVGR10 | Customer Grp 10 | ||||
| fsh_vas_rel | FSH_VAS_REL | VAS Relevant | ||||
| fsh_vas_prnt_id | POSNR_VL | Item | ||||
| fsh_transaction | FSH_TRANSACTION | Transaction Number | ||||
| fsh_item_group | FSH_ITEM_GROUP | Item Group | ||||
| fsh_item | FSH_ITEM | Item Number | ||||
| fsh_rsnum | RSNUM | Reservation | ||||
| fsh_rspos | RSPOS | Item no. | ||||
| mill_ucdet | MILL_UCDET | OB Purity | ||||
| cons_order | WRF_CONS_ORDER | Consignment? | ||||
| wrf_charstc1 | WRF_CHARSTC1 | Characteristic 1 | ||||
| wrf_charstc2 | WRF_CHARSTC2 | Characteristic 2 | ||||
| wrf_charstc3 | WRF_CHARSTC3 | Characteristic 3 |
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.
-- SD document: Delivery: Item data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LIPS (
MANDT, -- Client [MANDT]
VBELN, -- Delivery [VBELN_VL]
POSNR, -- Item [POSNR_VL]
PSTYV, -- Item Category [PSTYV_VL]
ERNAM, -- Created By [ERNAM]
ERZET, -- Time [ERZET]
ERDAT, -- Created On [ERDAT]
MATNR, -- Material [MATNR]
MATWA, -- MaterialEntered [MATWA]
MATKL, -- Material Group [MATKL]
WERKS, -- Plant [WERKS_D]
LGORT, -- Location [LGORT_D]
CHARG, -- Batch [CHARG_D]
LICHN, -- Supplier Batch [LICHN]
KDMAT, -- Customer Mat. [KDMAT]
PRODH, -- Prod. Hierarchy [PRODH_D]
PRDH_UNI_BATDET_PARNT_NODID, -- Node ID [NODID]
LFIMG, -- Delivery Qty [LFIMG]
MEINS, -- Base Unit [MEINS]
VRKME, -- Sales Unit [VRKME]
UMVKZ, -- Numerator [UMVKZ]
UMVKN, -- Denominat. [UMVKN]
NTGEW, -- Net Weight [NTGEW_15]
BRGEW, -- Gross Weight [BRGEW_15]
GEWEI, -- Unit of Weight [GEWEI]
VOLUM, -- Volume [VOLUM_15]
VOLEH, -- Volume Unit [VOLEH]
KZTLF, -- Part.dlv./item [KZTLF]
UEBTK, -- Unlimited [UEBTK]
UEBTO, -- Overdeliv. Tol. [UEBTO]
UNTTO, -- Underdel. Tol. [UNTTO]
CHSPL, -- Batch split [CHSPL]
FAKSP, -- Billing Block [FAKSP]
MBDAT, -- Mat.Avail.Date [MBDAT]
LGMNG, -- Qty (stckp.unt) [LGMNG]
ARKTX, -- Item Descr. [ARKTX]
LGPBE, -- Storage Bin [LGPBE]
VBELV, -- Originating Doc [VBELV]
POSNV, -- Origin. Item [POSNV]
VBTYV, -- Document Cat. [VBTYPL]
VGSYS, -- PrDocLogSys [VGLOGSYS]
VGBEL, -- Reference Doc. [VGBEL]
VGPOS, -- Reference Item [VGPOS]
UPFLU, -- Update doc.flow [UPFLL]
UEPOS, -- Higher-Lev.Item [UEPOS]
FKREL, -- Relev.for Bill. [FKREL]
BATCH_BILLING_VARIANT, -- BatchItmBillVar [SDBIL_BATCH_BILLING_VARIANT]
LADGR, -- Loading Group [LADGR]
TRAGR, -- Trans. Group [TRAGR]
KOMKZ, -- Picking ID [KOMKZ]
LGNUM, -- Warehouse No. [LGNUM]
LISPL, -- Whse no. split [LNSPL_LIPS]
LGTYP, -- Storage Type [LGTYP]
LGPLA, -- Storage Bin [LGPLA]
BWTEX, -- Separate val. [BWTEX]
ETTYP, -- Sched.Line Cat. [ETTYP]
BWART, -- Movement Type [BWART]
BWLVS, -- Movement Type [BWLVS]
KZDLG, -- Ind.dynamic bin [LVS_KZDLG]
BDART, -- RequirementType [BDART]
PLART, -- Planning type [PLART]
MTART, -- Material Type [MTART]
XCHPF, -- Batch Mgmt Rqt [XCHPF]
XCHAR, -- Batches [XCHAR]
VGREF, -- Preced. with ref. [VGREF]
POSAR, -- Item Type [POSAR]
BWTAR, -- Valuation Type [BWTAR_D]
SUMBD, -- Req'mt totals. [SUMBD]
MTVFP, -- Avail. check [MTVFP]
EANNR, -- EAN Number [EANNR]
GSBER, -- Business Area [GSBER]
VKBUR, -- Sales Office [VKBUR]
VKGRP, -- Sales Group [VKGRP]
VTWEG, -- Distr. Channel [VTWEG]
SPART, -- Division [SPART]
GRKOR, -- Delivery Group [GRKOR]
FMENG, -- Qty. is fixed [FMENG]
ANTLF, -- Max.Part.Deliv. [ANTLF]
VBEAF, -- Fixed proc.time [VBEAF]
VBEAV, -- Var. proc. time [VBEAV]
STAFO, -- Update Group [STAFO]
WAVWR, -- Cost [WAVWR]
KZWI1, -- Subtotal 1 [KZWI1]
KZWI2, -- Subtotal 2 [KZWI2]
KZWI3, -- Subtotal 3 [KZWI3]
KZWI4, -- Subtotal 4 [KZWI4]
KZWI5, -- Subtotal 5 [KZWI5]
KZWI6, -- Subtotal 6 [KZWI6]
SOBKZ, -- Special Stock [SOBKZ]
AEDAT, -- Changed On [AEDAT]
EAN11, -- EAN/UPC [EAN11]
KVGR1, -- Customer Grp 1 [KVGR1]
KVGR2, -- Customer Grp 2 [KVGR2]
KVGR3, -- Customer Grp 3 [KVGR3]
KVGR4, -- Customer Grp 4 [KVGR4]
KVGR5, -- Customer Grp 5 [KVGR5]
MVGR1, -- MaterialGroup 1 [MVGR1]
MVGR2, -- MaterialGroup 2 [MVGR2]
MVGR3, -- MaterialGroup 3 [MVGR3]
MVGR4, -- MaterialGroup 4 [MVGR4]
MVGR5, -- MaterialGroup 5 [MVGR5]
VPZUO, -- Allocation Ind. [VPZUO]
VGTYP, -- Prec.Doc.Categ. [VBTYPL_V]
RFVGTYP, -- PrecedDocCentrl [RFVGTYPL]
KOSTL, -- Cost Center [KOSTL]
KOKRS, -- CO Area [KOKRS]
PAOBJNR, -- Profit. segment [RKEOBJNR]
PRCTR, -- Profit Center [PRCTR]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
AUFNR, -- Order [AUFNR]
POSNR_PP, -- Item Number [CO_POSNR]
VORNR, -- Activity [VORNR]
RECIPIENT_LOCATION_CODE, -- Recipient Loc. [RECIPIENT_LOCATION_CODE]
AUFPL, -- Plan No.f.Oper. [CO_AUFPL]
APLZL, -- Counter [CIM_COUNT]
KDAUF, -- Sales Order [KDAUF]
KDPOS, -- Sales Ord. Item [KDPOS]
VPMAT, -- Plng material [VPMAT]
VPWRK, -- Planning Plant [VPWRK]
PRBME, -- Prod. grp unit [PRBME]
UMREF, -- Conversion [UMREFF]
KNTTP, -- Acct Assgmt Cat [KNTTP]
KZVBR, -- Consumption [KZVBR]
FIPOS, -- Commitment item [FIPOS]
FISTL, -- Funds Center [FISTL]
GEBER, -- Fund [BP_GEBER]
PCKPF, -- Packing Control [PCKPF]
BEDAR_LF, -- Reqmts Class [BEDAR]
CMPNT, -- Credit Active [CMPNT]
KCMENG, -- Cumul.batch qty [KCMENG]
KCBRGEW, -- Cum.gross wght [KCBRGEW]
KCNTGEW, -- Cumul.net wght [KCNTGEW]
KCVOLUM, -- Cumul.volume [KCVOLUM]
UECHA, -- HghLevItmBatch [UECHA]
CUOBJ, -- Configuration [CUOBJ_VA]
CUOBJ_CH, -- Int.object no. [CUOBJ_CH]
ANZSN, -- No.serial no. [ANZSN]
SERAIL, -- SerialNoProfile [SERAIL]
KCGEWEI, -- Unit of Weight [GEWEI]
KCVOLEH, -- Volume Unit [VOLEH]
SERNR, -- BOM expl.number [SERNR]
ABRLI, -- Int.dlv.scd.no. [ABRLI]
ABART, -- Release type [ABART]
ABRVW, -- Usage [ABRVW]
QPLOS, -- Inspection Lot [QPLOS]
QTLOS, -- Partial Lot [QTLOS]
NACHL, -- No GR posted [NACHL]
MAGRV, -- Matl Grp Pckmat [MAGRV]
OBJKO, -- Object No. Hdr [OBJKO]
OBJPO, -- ObjNo Item [OBJPO]
AESKD, -- Engin. Change [AESKD]
SHKZG, -- Returns [SHKZG_DLV]
PROSA, -- MatDetermActive [PROSA]
UEPVW, -- Usage HL Item [UEPVW]
EMPST, -- Recv. Point [EMPST]
ABTNR, -- Department [ABTNR]
KOQUI, -- Confirmation [KOQUI]
STADAT, -- Statistics Date [STADAT]
AKTNR, -- Promotion [WAKTION]
KNUMH_CH, -- NoCondRec.Batch [KNUMH_CH]
PREFE, -- Cus. Preference [PREFE]
EXART, -- Bus.Trans.Type [EXART]
CLINT, -- Int class no. [CLINT]
CHMVS, -- Qty proposal [CHMVS]
ABELN, -- Alloc. Table [ABELN]
ABELP, -- Item [ABELP]
LFIMG_FLO, -- Internal field/ Do not use / LFIMG in float / MUM [LFIMG_FLO]
LGMNG_FLO, -- Internal field/ Do not use / LGMNG in float / MUM [LGMNG_FLO]
KCMENG_FLO, -- Internal field/ Do not use / KCMENG in float / MUM [KCMENG_FLO]
KZUMW, -- Envt. relevant [KZUMW]
KMPMG, -- Quantity [KMPMG]
AUREL, -- AT-Relevant [AUREL]
KPEIN, -- Pricing Unit [KPEIN]
KMEIN, -- Unit of Measure [KMEIN]
NETPR, -- Net Price [NETPR]
NETWR, -- Net Value [NETWR]
KOWRR, -- Stat. Value [KOWRR]
KZBEW, -- Movement ind. [KZBEW]
MFRGR, -- Mat.Freight Grp [MFRGR]
CHHPV, -- Pack acc.batch [CHHPV]
ABFOR, -- PaytGuarantForm [ABSFORM_CM]
ABGES, -- Guaranteed [ABGES_CM]
MBUHR, -- Matl Staging Tme [MBUHR]
WKTNR, -- Value Contract No. [WKTNR]
WKTPS, -- Val. Cont.Item [WKTPS]
J_1BCFOP, -- CFOP [J_1BCFOP]
J_1BTAXLW1, -- ICMS Law [J_1BTAXLW1]
J_1BTAXLW2, -- IPI Law [J_1BTAXLW2]
J_1BTXSDC, -- Tax Code [J_1BTXSDC_]
SITUA, -- Situation [SITUA]
RSNUM, -- Reservation [RSNUM]
RSPOS, -- Item no. [RSPOS]
RSART, -- Record type [RSART]
KANNR, -- Sequence Number [KANNR]
KZFME, -- Leading UoM [KZFME]
PROFL, -- DGIndProfile [ADGE_PROFL]
KCMENGVME, -- Cumul.batch qty [KCMENG_VME]
KCMENGVMEF, -- Cumulated batch split quantity in VRKME and float [KCMENGVMEF]
KZBWS, -- Valuation [KZBWS]
PSPNR, -- Project def. [PS_INTNR]
EPRIO, -- Withdr.Seq.Grp [EPRIO]
RULES, -- Stk Determ.Rule [BF_RULES]
KZBEF, -- Inv.Mgmt active [LVS_KZBEF]
MPROF, -- Mfr Part Profile [MPROF]
EMATN, -- MPN: Material [EMATN]
LGBZO, -- Staging Area [LGBZO]
HANDLE, -- Key [TSEGGUID_LIPS]
VERURPOS, -- Orig. item [VERURPOS]
LIFEXPOS, -- Ext. item [LIFEXPOS]
NOATP, -- No avail. check [NO_ATP_CHECK]
NOPCK, -- Not rel.picking [NO_PICKING]
RBLVS, -- RefMvtType WM [RBLVS]
BERID, -- MRP Area [BERID]
BESTQ, -- Stock Category [BESTQ]
UMBSQ, -- Stock Category [BESTQ]
UMMAT, -- Receiving Mat. [UMMAT]
UMWRK, -- Receiving plant [UMWRK]
UMLGO, -- Receiving SLoc. [UMLGO]
UMCHA, -- Receiving Batch [UMCHA]
UMBAR, -- Val. Type Tfr. [UMBAR]
UMSOK, -- Sp.ind.st.tfr. [UMSOK]
SONUM, -- Spec.Stock No. [LVS_SONUM]
USONU, -- Spec.Stock No. [LVS_SONUM]
AKKUR, -- LettofCredRate [AKKUR]
AKMNG, -- Current qty [AKMNG]
VKGRU, -- Class. of Items [VKGRU]
SHKZG_UM, -- Main posting id [SHKZG_UM]
INSMK, -- Stock Type [MB_INSMK]
KZECH, -- Enter batch [KZECH]
FLGWM, -- Indicator: Copy dest. storage data from preceding document [FLGWM]
BERKZ, -- Staging Ind. [BERKZ]
HUPOS, -- Indicator: Delivery item is a HU item [HUPOS]
NOWAB, -- No gds movement [NOWAB]
KONTO, -- G/L Account [SAKNR]
KZEAR, -- Final Issue [KZEAR]
HSDAT, -- Date of Manuf. [HSDAT]
VFDAT, -- SLED/BBD [VFDAT]
LFGJA, -- Year Cur.Period [LFGJA]
LFBNR, -- Reference Doc. [LFBNR]
LFPOS, -- Ref. Doc. Item [LFPOS]
GRUND, -- Reason for mvt. [MB_GRUND]
FOBWA, -- Sub.movmnt type [FOBWA]
DLVTP, -- Delivery Cat. [DLVTP]
EXBWR, -- Ext. Amount LC [EXBWR]
BPMNG, -- Qty in OPUn [BPMNG]
EXVKW, -- Sales Value [EXVKW]
CMPRE_FLT, -- Credit Price [CMPRE_FLT]
KZPOD, -- POD indicator [KZPOD]
LFDEZ, -- Not WMS-relevnt [LFDEZ]
UMREV, -- ConversionFactr [LE_UMREV]
PODREL, -- POD rel. RC/SC [PODREL]
KZUML, -- St.tfr./tfr.pst [KZUML]
FKBER, -- Functional Area [FKBER]
GRANT_NBR, -- Grant [GM_GRANT_NBR]
KZWSO, -- Units meas. use [KZWSO]
GMCONTROL, -- Gds mvmt contrl [GMCONTROL]
POSTING_CHANGE, -- WBWKZ [POSTING_CHANGE]
UM_PS_PSP_PNR, -- Trsfr WBS Elmnt [UM_PS_PSP_PNR]
PRE_VL_ETENS, -- Sequential No. [ETENS]
SPE_GEN_ELIKZ, -- Deliv. Compl. [ELIKZ]
SPE_SCRAP_IND, -- Scrap Indicator [/SPE/DELIVERY_SCRAP_IND]
SPE_AUTH_NUMBER, -- RMA Number [/SPE/RET_RMA]
SPE_INSPOUT_GUID, -- Inspection GUID [/SPE/INSP_OUT_GUID_16]
SPE_FOLLOW_UP, -- Follow-Up Code [/SPE/RET_FOLLOW_UP]
SPE_EXP_DATE_EXT, -- End Validity Period [/SPE/RET_EXPIRY_DATE_EXT]
SPE_EXP_DATE_INT, -- End internal val. [/SPE/RET_EXPIRY_DATE_INT]
SPE_AUTH_COMPLET, -- RMA No. Completed [/SPE/RET_RMA_COMPLETED]
ORMNG, -- Delivery Qty [ORMNG_VL]
SPE_ATP_TMSTMP, -- ATP Time Stamp [/SPE/DE_ATP_TIMESTAMP]
SPE_ORIG_SYS, -- Original System Type [/SPE/INB_ORIGIN_SYS]
SPE_LIEFFZ, -- CQ Vendor [/SPE/LIEFFZ]
SPE_IMWRK, -- In Plant [/SPE/IMWRK_ITEM]
SPE_LIFEXPOS2, -- Ext. ident. [/SPE/DE_EXT_IDENT]
SPE_EXCEPT_CODE, -- Except.Code WH [/SPE/INB_EXCEPT_CODE_WM]
SPE_KEEP_QTY, -- Retention Qty [/SPE/KEEP_QUANTITY]
SPE_ALTERNATE, -- Alt.ProdNr. [/SPE/DE_ALTERNATE_PART_NR]
SPE_MAT_SUBST, -- Reasn [/SPE/MAT_SUBST]
SPE_STRUC, -- Structure [/SPE/STRUC]
SPE_APO_QNTYFAC, -- Numerator [APOQUANFACTOR]
SPE_APO_QNTYDIV, -- Denominator [APOQUANDIVISOR]
SPE_HERKL, -- C/R of Origin [HERKL]
SPE_BXP_DATE_EXT, -- Begin Valid. Period [/SPE/RET_EXPIRY_DATE_EXT_B]
SPE_VERSION, -- DeliveryVsn [/SPE/DE_DLV_VERSION]
SPE_COMPL_MVT, -- GM Completion [/SPE/COMPL_MVT]
J_1BTAXLW4, -- COFINS Law [J_1BTAXLW4]
J_1BTAXLW5, -- PIS Law [J_1BTAXLW5]
J_1BTAXLW3, -- ISS Law [J_1BTAXLW3]
BUDGET_PD, -- Budget Period [FM_BUDGET_PERIOD]
KBNKZ, -- Kanban Indicat. [KBNKZ]
FARR_RELTYPE, -- Type [FARR_RELTYPE]
SITKZ, -- Spec.Iss. Val. SiT [SITKZ]
SGT_RCAT, -- Req. Segment [SGT_RCAT]
SGT_SCAT, -- Stock Segment [SGT_SCAT]
RESOURCE_ID, -- Resource [LE_RESOURCENAME_SID]
UMRESOURCE_ID, -- Receiv. Resource [LE_RESOURCENAME_CID]
FLPKZ, -- Fld. Logs. Ind. [FLPKZ]
LOADING_POINT, -- Load./Unload. Pt [/SCMTMS/LOADING_POINT_ID]
SOLUTION_ORDER_ID, -- Solution Order [CRMS4_SOLO_OBJECT_ID]
SOLUTION_ORDER_ITM_ID, -- Item Number in Doc. [CRMS4_NUMBER_INT]
SPE_HERKR, -- Reg. of Origin [HERKR]
ITM_COMCO, -- Commodity Code [/SAPSLL/COMCO]
WEMPF, -- Recipient [WEMPF]
CREATION_TS, -- Time Stamp [TIMESTAMPL]
CHANGED_TS, -- Time Stamp [TIMESTAMPL]
PIKMG_WH, -- Pick quantity [PIKMG_WH]
PIKMG_WH_BU, -- Pick quantity [PIKMG_WH_BU]
SERVICE_DOC_TYPE, -- Service Doc. Type [FCO_SRVDOC_TYPE]
SERVICE_DOC_ID, -- Service Document [FCO_SRVDOC_ID]
SERVICE_DOC_ITEM_ID, -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
BESTA, -- Deliv. Conf.Sts [BESTA]
CMPPI, -- Financial Doc. [CMPSI]
CMPPJ, -- ExptCreditInsur [CMPSJ]
FKIVP, -- Intco Bllg Sts [FKIVP]
FKSTA, -- Del.Rel.BillgSt [FKSTA]
GBSTA, -- Overall Status [GBSTA]
HDALL, -- DlyItemNotComp. [/SPE/INB_HDALL_ITM]
KOQUA, -- Confirmation [KOQUA]
KOSTA, -- Picking Status [KOSTA]
LVSTA, -- WM Activity Sts [LVSTA]
PDSTA, -- POD status [PDSTA]
PKSTA, -- Packing Status [PKSTA]
UVALL, -- Item [UVALL_UP]
UVFAK, -- Billing – Item [UVFAK_UP]
UVPAK, -- Packing – Item [UVPAP_UP]
UVPIK, -- Picking/Putaway–Item [UVPIP_UP]
UVVLK, -- Delivery – Item [UVVLK_UP]
UVWAK, -- Goods Mvt –Item [UVWAP_UP]
VLSTP, -- Decentr.whse [VLSTP]
WBSTA, -- Goods Mvmnt Sts [WBSTA]
UVP01, -- Item reserves 1 [UVP01]
UVP02, -- Item reserves 2 [UVP02]
UVP03, -- Item reserves 3 [UVP03]
UVP04, -- Item reserves 4 [UVP04]
UVP05, -- Item reserves 5 [UVP05]
EMCST, -- Embargo Status [/SAPSLL/EMCST]
SLCST, -- Screening Status [/SAPSLL/SLCST]
LCCST, -- Legal Control Status [/SAPSLL/LCCST]
PCSTA, -- Prod. Marktablty Sts [TDD_PCSTA_LE]
DGSTA, -- Dangerous Goods Sts [TDD_DGSTA_LE]
SDSSTA, -- Sfty Data Sheet Sts [TDD_SDSSTA_LE]
ICO_FKIVP, -- Intco Billing Status [ICO_FKIVP]
KOSTA_WH, -- Picking Status [KOSTA_WH]
ARC_STATUS, -- ET ARC Status [ET_ARC_STATUS]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
DUMMY_DELITM_INCL_EEW_PS, -- Dummy function in length 1 [DUMMY]
ICO_VGTYP, -- Intco Ref Doc Cat [ICO_VGTYP]
ICO_VGBEL, -- Intco Ref Doc [ICO_VGBEL]
ICO_VGPOS, -- Intco Ref Doc Item [ICO_VGPOS]
ICO_FKAIV, -- Intco Billing Type [ICO_FKAIV]
ICO_VKOIV, -- Sales Org. ICB [ICO_VKOIV]
ICO_PIOIV, -- Billing date [ICO_PIOIV]
ICO_FKDIV, -- Billing Date [ICO_FKDIV]
VCM_CHAIN_UUID, -- GUID 16 [GUID_32]
VCM_CHAIN_CATEGORY, -- Value Chain Category [VCM_CHAIN_CATEGORY]
LGTOR, -- Door for Whse [LGTOR]
FSH_SEASON_YEAR, -- Season Year [FSH_SAISJ]
FSH_SEASON, -- Season [FSH_SAISO]
FSH_COLLECTION, -- Collection [FSH_COLLECTION]
FSH_THEME, -- Theme [FSH_THEME]
FSH_KVGR6, -- Customer Grp 6 [FSH_KVGR6]
FSH_KVGR7, -- Customer Grp 7 [FSH_KVGR7]
FSH_KVGR8, -- Customer Grp 8 [FSH_KVGR8]
FSH_KVGR9, -- Customer Grp 9 [FSH_KVGR9]
FSH_KVGR10, -- Customer Grp 10 [FSH_KVGR10]
FSH_VAS_REL, -- VAS Relevant [FSH_VAS_REL]
FSH_VAS_PRNT_ID, -- Item [POSNR_VL]
FSH_TRANSACTION, -- Transaction Number [FSH_TRANSACTION]
FSH_ITEM_GROUP, -- Item Group [FSH_ITEM_GROUP]
FSH_ITEM, -- Item Number [FSH_ITEM]
FSH_RSNUM, -- Reservation [RSNUM]
FSH_RSPOS, -- Item no. [RSPOS]
MILL_UCDET, -- OB Purity [MILL_UCDET]
CONS_ORDER, -- Consignment? [WRF_CONS_ORDER]
WRF_CHARSTC1, -- Characteristic 1 [WRF_CHARSTC1]
WRF_CHARSTC2, -- Characteristic 2 [WRF_CHARSTC2]
WRF_CHARSTC3, -- Characteristic 3 [WRF_CHARSTC3]
PRIMARY KEY (MANDT, VBELN, POSNR)
);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