Documentação:
Descrição da tabela:
Tabela fato de atribuição de Listas de Tarefas para Tabela de Materiais
Tabelas utilizadas:
SAP.MAPL
SAP.PLKO
SAP.PLPO
Montagem:
1 - Select na tabela MAPL trazendo os seguintes campos:
(MATNR,WERKS,PLNTY,PLNNR,PLNAL,ZKRIZ,ZAEHL)
2 - Join com a tabela PLKO é o cabeçalho para acessar os dados da PLPO, não trazemos campos dessa tabela apenas ligação no join.
3 - Join com a tabela PLPO trazendo todos os campos:
PLNKN,DATUV,TECHV,AENNR,LOEKZ,PARKZ,ANDAT,ANNAM,AEDAT,AENAM,SUMNR,VORNR,STEUS,ARBID,OBJTY,KTSCH,LTXA1,LTXA2,TXTSP,VPLTY,VPLNR,VPLAL,VPLFL,VINTV,MEINH,UMREN,UMREZ,BMSCH,ZMERH,ZEIER,LAR01,VGE01,VGW01,LAR02,VGE02,VGW02,LAR03,VGE03,VGW03,LAR04,VGE04,VGW04,LAR05,VGE05,VGW05,LAR06,VGE06,VGW06,ZERMA,ZGDAT,ZCODE,ZULNR,RSANZ,PDEST,LOANZ,LOART,QUALF,ANZMA,RFGRPRFSCH,RASCH,AUFAK,LOGRP,UEMUS,UEKAN,FLIES,ZEIMU,ZMINU,MINWE,SPMUS,SPLIM,ZEIMB,ZMINB,ZEILM ,ZLMAX,ZEILP,ZLPRO,ZEIWN,ZWNOR,ZEIWM,ZWMIN,ZEITN,ZTNOR,ZEITM,ZTMIN,ABLIPKZ,RSTRA,BZOFFB ,OFFSTB,EHOFFB,BZOFFE,OFFSTE,EHOFFE,SORTL,LIFNR,PLIFZ,PREIS,PEINH,SAKTO,WAERS,INFNR,ESOKZ,EKORG,EKGRP,KZLGF,MATKL,DAUNO,DAUNE,DAUMI,DAUME,DDEHN,EINSA,EINSE,ARBEI,ARBEH,ANZZL,PRZNT,VERL,MLSTN,PPRIO,BUKRS,SLWID,USR00,USR01,USR02,USR03,USR04,USE04,USR05,USE05,USR06,USE06,USE07,USR08,USR09,USR10,USR11,ANFKO,ANFKOKRS,KAPAR,INDET,LARNT,PRKST,QRASTERMNG,QRASTEREH,ANLZU,ISTRU,ISTTY,ISTNR,ISTKN,ISTPO,IUPOZ,EBORT,KALID,FRSP,VERTN,ZGR01,ZGR02,ZGR03,ZGR04,ZGR05,ZGR06,MDLID,RUZUS,BMEIH,BMVRG,CKSELKZ,KALKZ,NPRIO,PVZKN,PHFLG,PHSEQ,KNOBJ,ERFSICHT,PSPNR ,QLOTYPE,QLOBJEKTID,QLKAPAR,QKZPRZEIT,QKZZTMG1,QKZPRMENG,QKZPRFREI,QRASTZEHT,QRASTZFAK ,QRASTMENG,QPPKTABS,KRIT1,CLASSID,PACKNO,EBELN,EBELP,CAPOC,FLG_CAPTXT,CN_WEIGHT,QKZTLSBEST,AUFKT,DAFKT,RWFAK,AAUFG,VERDART,UAVO_AUFL,FRDLB,QPART,PRZ01,TAKT,OPRID,NVADD,EVGEW ,RFPNT,FLG_TSK_GROUP,ADPSP,VALID_TO,LOEKZ_INHERITED,DUMMY_PLPO_INCL_EEW_PS,TPLNR,EQUNR ,MES_OPERID,MES_STEPID,MANU_PROC,VERSN,VERSN_SOURCE,VERSN_SOURCE_PLNKN,VERSN_TRACK_GUID,FAV_GUID,FAV_VERSN,FAV_GUID_OLD,FAV_VERSN_OLD,EXECUTION_STAGE,_SAPMP_MET_LRCH,_SAPMP_MAX_FERTL,_SAPMP_FIX_AS_J,_SAPMP_FIX_AS_E,_SAPMP_FIX_AS_L,_SAPMP_ABL_ZAHL,SUBPLNAL,SUBPLNNR
,SUBPLNTY,XEXCLTL
Databricks:
camada_semantica.roteiro